Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 661:

  Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.

  You are informed that some important tables in the BILLING tablespace have been dropped on February 28, 2007 at 10.30 AM and must be recovered.

  You decide to perform an incomplete recovery using the following command:

  SQL> RECOVER DATABASE UNTIL TIME '2007-02-28:10:15:00';

  Identify the files that must be restored to recover the missing tables successfully.

  A. Restore the backup of all the data files.
  B. Restore the backup of all the data files and the control file.
  C. Restore the backup of only the data files that contain the dropped tables.
  D. Restore the backup of all the data files belonging to the tablespace containing the dropped tables.
  A. Restore the backup of all the data files.

• Question 662:

  What is the advantage of setting the ASM-preferred mirror read for the stretch cluster configuration?

  A. It improves resync operations.
  B. This feature enables much faster file opens.
  C. It improves performance as fewer extent pointers are needed in the shared pool.
  D. It improves performance by reading from a copy of an extent closest to the node.
  D. It improves performance by reading from a copy of an extent closest to the node.

• Question 663:

  True or false: tablespace point-in-time recovery is possible only with RMAN.

  A. True
  B. False
  B. False

• Question 664:

  View the Exhibit and examine the data manipulation language (DML) operations that you performed on the NEWEMP table. Note that the first two updated are not listed by the Flashback Versions Query.

  What could be the reason?

  Exhibit:

  

  A. The first two updated were not explicitly committed.
  B. ALTER TABLE caused the recycle bin to release the space.
  C. The data definition language (DDL) operation caused a log switch.
  D. Flashback Versions Query stops producing versions of rows that existed before a change in the table structure.
  C. The data definition language (DDL) operation caused a log switch.

• Question 665:

  Which two client requests are captured during database replay Capture? (Choose two)

  A. Flashback queries
  B. Shared server requests
  C. Login and logoff activities of sessions
  D. Direct path load of data from external files by using utilities such as SQL *loader
  E. Data definition language (DDL) and data manipulation language (DML) operations
  C. Login and logoff activities of sessions
  E. Data definition language (DDL) and data manipulation language (DML) operations

• Question 666:

  While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available.

  What would the optimizer do in this situation?

  A. It updates the existing SQL profiles with current statistics.
  B. It makes the statistics information available to GATHER_STATS_JOB.
  C. It initiates the statistics collection process by running GATHER_STATS_JOB.
  D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
  B. It makes the statistics information available to GATHER_STATS_JOB.

• Question 667:

  Which of the following advisors is run in every maintenance window by the auto-task system?

  A. The Memory Advisor
  B. The SQL Tuning Advisor
  C. The Undo Advisor
  D. The SQL Access Advisor
  B. The SQL Tuning Advisor

• Question 668:

  Examine the CREATE DISKGROUP command used to create a disk group:

  SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY

  DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2;

  In which situation would you use this method of disk group creation?

  A. When two-way disk mirroring is required for the allocation units
  B. When three-way disk mirroring is required for the allocation units
  C. When using hardware mirroring or RAID
  D. When disk mirroring is required for the Automatic Storage Management (ASM) disks
  C. When using hardware mirroring or RAID

• Question 669:

  View the Exhibit and examine the Data Pump architecture. Identify the numbered components.

  

  A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API
  B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader
  C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump
  D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump
  A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API

• Question 670:

  You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?

  A. A different procedure is required to restore a database from compressed backups
  B. The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
  C. Using this command to create backups minimizes the bandwidth consumed
  D. Using this command to create backups improves the performance of the backup process
  C. Using this command to create backups minimizes the bandwidth consumed