Oracle certification

oracle database 10g:new features for oracle8i ocps : 1z0-045 Exam

Why choose Greatexam 1z0-045 braindumps

Quality and Value for the 1z0-045 Exam
100% Guarantee to Pass Your 1z0-045 Exam
Downloadable, Interactive 1z0-045 Testing engines
Verified Answers Researched by Industry Experts
Drag and Drop questions as experienced in the Actual Exams
Practice Test Questions accompanied by exhibits
Our Practice Test Questions are backed by our 100% MONEY BACK GUARANTEE.

Greatexam 1z0-045 Exam Features

1z0-045 News

　
　
Exam : Oracle 1Z0-045
Title : Oracle(r) Database 10g:New Features for Oracle8i ocps


1. Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct? (Choose two.)
A. You can find information about only active transactions from the view.
B.You can find information about read only transactions from the view.
C.You require the SELECT ANY TRANSACTION system privilege to access the view.
D.You can find information about both active and committed transactions from the view.
E.You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view.
Answer: CD

2. Your Data Guard architecture consists of one primary database and one standby database, both located on the same machine. What is the minimum that you need in order to use the command-line interface of the Oracle 10g Data Guard Manager tool to monitor your Data Guard architecture?
A.only one Data Guard Monitor (DMON)
B.only the Oracle Management Server (OMS)
C.two Data Guard Monitors, one for each instance
D.one Data Guard Monitor and one Oracle Management Server
Answer: C

3. After changing the PCTFREE value of the automatic space management table EMPLOYEES, which task can you perform in order for your change to take effect immediately?
B.Execute the command ANALYZE TABLE employees COMPUTE STATISTICS.
C.Execute the command DBMS_STATS.GATHER_TABLE_STATISTICS on the EMPLOYEES table.
D.Execute the DBMS_REPAIR.SEGMENT_FIX_STATUS procedure on the EMPLOYEES table.
Answer: D

4. ou want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 a.m.
Which command terminates with an error if the backup is not complete at the end of the specified duration?
A.RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE;
B.RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE;
C.RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE;
D.RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE;
Answer: A

5. Consider this syntax:
MERGE INTO t1
USING t2 ON (join predicate)..
What does the MERGE syntax do?
A.It performs a merge join of the row from T2 only if it doesn't exist in the T1 table.
B.It creates a natural join of tables T1 and T2 for all columns that have the same name.
C.It creates a Cartesian product of table T1 and table T2 for all columns that have the same name.
D.For each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.
Answer: D

6. You can use Oracle Flashback technology to look at past activity in your database.
What are two other characteristics of Oracle Flashback technology? (Choose two.)
A.Oracle Flashback technology uses undo information to construct consistent data.
B.You can use a PL/SQL cursor opened while using an Oracle Flashback image to perform DML once you deactivate the Flashback option in your session.
C.You can only use an Oracle Flashback view of the data if the required records are still in the online redo log files.
D.Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.
Answer: AB

7. You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down:
SQL> shutdown immediate;
What is the result of executing this command?
A.All the instances, including the ASM instance, are shut down in the ABORT mode.
B.The ASM instance is shut down, but the other instances are still running.
C.The ASM instance is still functional, but the other instances are shut down.
D.All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
E.HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
F.HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode.
Answer: D

8. You have three temporary tablespace groups named G1, G2, and G3 in your database.
You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP '';
Which statement regarding the above command is correct?
A.It will create the tablespace TEMP1 in group G1.
B.It will create the tablespace TEMP1 in group G3.
C.It will not add the tablespace TEMP1 to any group.
D.It will create the tablespace TEMP1 in the default group.
E.It will throw an error with message 'specified group is not available'.
F.It will create a new group with a system-generated name and add the tablespace TEMP1 to it.
Answer: C