Free Oracle 1Z0-052 Exam Dumps Questions & Answers

Given below is a list of scenarios:
1. A user terminates his session abnormally.
2. The connection between the server and the client application terminates because of a network failure.
3 . A schema is accidentally dropped.
4 . The tablespace is accidentally dropped from the database.
5 . The hard disk gets corrupted and the data files in the disk are lost.
6 . The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?

• A.4, 5, and 6
• B.1, 2, and 6
• C.3, 4, and 5
• D.1, 3, and 6

You are managing an Oracle Database 11g database with the following backup strategy:
1. On Sunday, an incremental level 0 tape backup is performed
2. Monday through Saturday, a cumulative incremental level 1 tape backup is performed Which two statements are true regarding the backups performed? (Choose two.)

• A.The backup performed in step 1 backs up all blocks that have ever been in use in the database
• B.The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup
• C.The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup
• D.The backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1

In which of the scenario will the DBA perform recovery? (Choose all that apply.)

• A.A database user terminates the session abnormally
• B.The alert log file is corrupted
• C.A tablespace is accidentally dropped
• D.One of the redo log members is corrupted
• E.The hard disk on which the data files is stored is corrupted

SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?

• A.One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session
• B.One audit record is created for every successful DROP TABLE command executed in the session of SCOTT
• C.One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully
• D.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users
• E.One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT

Which two are true about Optimizer Statistics? (Choose two.)

• A.They are gathered by the Manageability Monitor (MMON) background process
• B.They can be gathered by executing the PL/SQL procedures in the DBMS_STATS package
• C.They can be used to determine the events on which a database instance waited
• D.They do not persist across instance restarts
• E.They are automatically updated when DDL statements execute
• F.They provide information to the Optimizer so that it can determine optimal execution plans for SQL statements