Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 111:

  In which situation would you use static database registration for a listener?

  A. When multiple databases are to be registered with the listener

  B. When DBAs need to connect remotely to start up the database instance

  C. When users need to connect the database instance using the host naming method

  D. When the database instance that is to be registered with the listener is configured in shared server mode

  Correct Answer: B

• Question 112:

  Which is the correct description of a pinned buffer in the database buffer cache?

  A. The buffer is currently being accessed

  B. The buffer is empty and has not been used

  C. The contents of the buffer have changed and must be flushed to the disk by the DBWn process

  D. The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk

  Correct Answer: A

• Question 113:

  You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.

  What will be the implications on the archiving and the location of archive redo log files?

  A. Archiving will be disabled because the destination for the redo log files is missing

  B. The database instance will shut down and the error details will be logged in the alert log file

  C. Archiving will be enabled and the destination for the archived redo log file will be set to the Flash Recovery Area implicitly

  D. Archiving will be enabled and the location for the archive redo log file will be created in the default location $ORACLE_HOME/log

  Correct Answer: C

• Question 114:

  Your database instance is configured with automatic undo management and the UNDO_RETENTION

  parameter is set to 900 seconds. You executed the following command to enable retention guarantee:

  SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;

  What affect would this command have on the database?

  A. The extents in the undo tablespace retain data until the next full database backup

  B. The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes

  C. The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down

  D. The extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area before being overwritten

  Correct Answer: B

• Question 115:

  Which two statements are true regarding undo tablespaces? (Choose two.)

  A. The database can have more than one undo tablespace

  B. The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management

  C. Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions

  D. An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up

  Correct Answer: AC

• Question 116:

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

  A. The alert log file is corrupted

  B. A tablespace is accidentally dropped

  C. One of the redo log members is corrupted

  D. A database user terminates the session abnormally

  E. The hard disk on which the data files is stored is corrupted

  Correct Answer: BE

• Question 117:

  You want to configure and schedule offline database backups to run automatically.

  Which tool or utility would you use to achieve this?

  A. The XML script

  B. The PL/SQL script

  C. The DBMS_SCHEDULER package

  D. Enterprise Manager to schedule the backup

  Correct Answer: D

• Question 118:

  View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a large volume of transactions from non-DBA users in the last one hour. The undo tablespace NDOTBS1 is full with transactions and no transaction was committed more than one hour ago. The database has two more undo tablespaces.

  What happens to the new DML operations in this scenario?

  Exhibit:

  

  A. The DML commands will fail

  B. The undo data generated by the DML is stored in one of the two other undo tablespace

  C. The undo data generated by the DML will overwrite the extents that contain committed undo data

  D. The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM tablespace

  Correct Answer: A

• Question 119:

  Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?

  A. The DML operations re-create the bitmap index blocks

  B. The bitmap index is rebuilt automatically after a DML operation

  C. The smallest amount of a bitmap that can be locked is a bitmap segment

  D. Additional time is taken to remove NULL values from the bitmap index after a DML operation

  Correct Answer: C

• Question 120:

  Which statement is true about loading data using the conventional path of SQL*Loader?

  A. Redo is not generated while performing conventional path loads

  B. Only PRIMARY KEY, UNIQUE KEY and NOT NULL constraints are checked

  C. No exclusive locks are acquired when the conventional path loads are performed

  D. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files

  E. INSERT triggers are disabled before the conventional path load and reenabled at the end of the load

  Correct Answer: C