Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 151:

  Your database instance is running with full workload after database creation. You have decided to use a fixedsize undo tablespace. You want to use the undo Advisor to estimate the capacity of the undo tablespace.

  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo tablespace? (Choose two.)

  A. The retention period to support flashback

  B. The expected length of the longest-running query

  C. The number of undo tablespaces in the database

  D. The size of the Flash Recovery Area for the database instance

  Correct Answer: AB

• Question 152:

  The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?

  A. Inactive and current redo log files are required to accomplish recovery

  B. Online and archived redo files are required to accomplish instance recovery

  C. All redo log entries after the last checkpoint are applied from redo log files to data files

  D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

  Correct Answer: C

• Question 153:

  Note the following points describing various utilities in Oracle Database 11g:

  1.

  It enables the high-speed transfer of data from one database to another

  2.

  It provides a complete solution for the backup, restoration and recovery needs of the entire database

  3.

  It enables the loading of data from an external file into table of an Oracle Database

  4.

  It provides a tape backup management for the Oracle ecosystem Which point describes Oracle Secure Backup?

  A. 1

  B. 2

  C. 3

  D. 4

  E. 1,2 and 4

  F. 1,2,3, and 4

  Correct Answer: D

• Question 154:

  The database instance has the following parameter setting: OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD. You create a database user OPS$SKD, and then assign

  external authentication. The user OPS$SKD has the CREATE SESSION privilege. What would you achieve by the above process?

  A. The database user OPS$SKD will be able to administer the database.

  B. The authentication detail for the database user OPS$SKD is recorded in the password file.

  C. The local operating system user SKD will be able to access the database instance without specifying the username and password.

  D. The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.

  Correct Answer: C

• Question 155:

  Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOP

  What happens to the sessions that are presently connected to the database instance?

  A. The sessions are able to perform only queries

  B. The sessions are not affected and continue to function normally

  C. The sessions are terminated and the active transactions are rolled back

  D. The sessions are not allowed to perform any operations till the listener is started

  Correct Answer: B

• Question 156:

  In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

  A. When the data file of the undo tablespace is autoextensible

  B. When there are more than one undo tablespace available in the database

  C. When the undo tablespace is of a fixed size and retention guarantee is not enabled

  D. When the undo tablespace is autoextensible and retention guarantee is not enabled

  Correct Answer: C

• Question 157:

  You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sunday to tape:

  Which two statements are true about differential incremental backups? (Choose two.)

  A. The backup performed on Sundays contains all the blocks that have ever been used in the database

  B. The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup

  C. The backup performed on each working day contains all the blocks that have changed since the last level 0 backup

  D. The backup performed on Monday contains all the blocks that have changed since the level 0 backup and every other working day contains all the blocks that have changed since the level 1 backup

  Correct Answer: AD

• Question 158:

  User A executes the following command to drop a large table in your database:

  SQL> DROP TABLE trans;

  While the drop table operation is in progress; user B executes the following command on the same table;

  SQL> DELETE FROM trans WHERE tr_type='SL';

  Which statement is true regarding the DELETE command?

  A. It fails to delete the records because the records are locked in the SHARE mode

  B. It deletes the rows successfully because the table is locked in the SHARE mod

  C. It fails to delete the records because the table is locked in EXCLUSIVE mode

  D. It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode

  Correct Answer: C

• Question 159:

  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 every successful DROP TABLE command executed in the session of SCOTT

  B. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users

  C. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session

  D. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully

  E. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT

  Correct Answer: C

• Question 160:

  You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data in an important table having various integrity constraint defined on it.

  Which constraints will remain enabled by default during this operation? (Choose all that apply.)

  A. CHECK

  B. UNIQUE

  C. NOT NULL

  D. PRIMARY KEY

  E. FOREIGN KEY

  Correct Answer: BCD