Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 221:

  Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours?

  A. restore datafiles until time '09/28/2008:21:03:11';
  B. restore database files until time '09/28/2008:18:00:00';
  C. restore database until time '09/28/2008:18:00:00';
  D. recover database until time '09/28/2008:18:00:00';
  E. recover database until timestamp '09/28/2008:18:00:00';
  C. restore database until time '09/28/2008:18:00:00';

• Question 222:

  View Exhibit1 to examine the CRS11G disk group when all the disks are online. View Exhibit2 to examine the CRS11G disk group when one disk is offline.

  Why is the rebalancing not performed and the content of the disk group not empty in Exhibit2?

  ASM-disk-group-1 (exhibit):

  

  ASM-disk-group-2 (exhibit):

  

  A. Because the disk group is created with NORMAL redundancy
  B. Because the disk repair time attribute is set to a nonzero value
  C. Because the mirrored extents cannot be rebalanced across the other three disks
  D. Because the other three disks have 60% free space, the disk rebalancing is delayed
  B. Because the disk repair time attribute is set to a nonzero value

• Question 223:

  What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?

  A. MMON
  B. LGWR
  C. ARCH
  D. ARWR
  E. COPY
  C. ARCH

• Question 224:

  Which statement about recovering from the loss of a redo log group is true?

  A. If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
  B. If the lost redo log group is CURRENT, you must clear the log file.
  C. If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
  D. If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
  D. If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

• Question 225:

  In your production database, you:

  Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals

  Set the control file autobackup to "on"

  Are maintaining image copies of the database files

  You have lost the server parameter file (SPFILE) and the control file.

  Which option must you consider before restoring the SPFILE and the control file by using the control file autobackup?

  A. Setting DBID for the database
  B. Using the RMAN SWITCH command
  C. Using the RMAN SET NEWNAME command
  D. Starting up the database instance in the NOMOUNT state
  D. Starting up the database instance in the NOMOUNT state

• Question 226:

  Which of the following are not disabled by default?

  A. Jobs B. Chains
  C. Windows
  D. Window groups
  E. Schedule
  E. Schedule

• Question 227:

  You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure.

  Which statements will be true in this scenario? (Choose all that apply.)

  A. The disk is immediately dropped from the disk group.
  B. The ASM tracks the extents that are modified during the outage.
  C. The ASM migrates the extents from the unavailable disk to the remaining disks.
  D. The disk automatically goes offline.
  B. The ASM tracks the extents that are modified during the outage.
  D. The disk automatically goes offline.

• Question 228:

  What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels?

  A. Channel failover
  B. Restartable backups
  C. Rescheduable backups
  D. Automatic backup recovery
  E. Channel recovery
  A. Channel failover

• Question 229:

  Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:

  ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;

  What would be the outcome of this command?

  A. It produces an error because data already exists in the table.
  B. It produces an error because compression can be enabled at table creation only.
  C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
  D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.
  C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.

• Question 230:

  What two are the prerequisites for enabling Flashback Database? (Choose two)

  A. The database must be in ARCHIVELOG mode
  B. The database must be in MOUNT EXCLUSIVE mode
  C. The database must be opened in RESTRICTED mode
  D. The database instance must be started in the NOMOUNT state
  E. The database instance must have the keep buffer pool defined
  A. The database must be in ARCHIVELOG mode
  B. The database must be in MOUNT EXCLUSIVE mode