Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 411:

  If a backup set is expired, what can you do to correct the problem?

  A. Change the retention criteria.
  B. Make the lost backup set pieces available to RMAN again.
  C. Run the crosscheck command to correct the location for the backup set piece contained in the metadata.
  D. Nothing. The backup set piece is lost forever.
  E. Call Oracle support, their assistance is required.
  B. Make the lost backup set pieces available to RMAN again.

• Question 412:

  Your database is running In ARCHIVELOG mode. One of the data files, USERDATA01.DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)? (Choose three.)

  A. redo logs
  B. control file
  C. temporary files of temporary tablespace
  D. the latest backup of only the damaged data file
  E. the latest backup of all the data files In the USERS tablespace
  A. redo logs
  B. control file
  D. the latest backup of only the damaged data file

• Question 413:

  What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)

  A. ORACLE_BASE should be set explicitly.
  B. An Oracle base should have only one Oracle home created in it.
  C. Flash recovery area and data file location should be on separate disks.
  D. Flash recovery area and data file location should be created under Oracle base in a non- Automatic Storage Management (ASM) setup.
  A. ORACLE_BASE should be set explicitly.
  C. Flash recovery area and data file location should be on separate disks.
  D. Flash recovery area and data file location should be created under Oracle base in a non- Automatic Storage Management (ASM) setup.

• Question 414:

  After executing the command

  ALTER DISKGROUP diskgroup2 DROP DISK dg2a;

  You issue the following command from the ASM instance:

  SELECT group_number, COUNT(*) FROM v$asm_operation;

  What is the implication if the query against V$ASM_OPERATION returns zero rows?

  A. The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.
  B. The drop disk operation is complete and you can run the undrop disks command if needed.
  C. The drop disk operation is complete and you cannot run the undrop disks command.
  D. The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance.
  E. None of the above is true.
  C. The drop disk operation is complete and you cannot run the undrop disks command.

• Question 415:

  Which of the following are true concerning block media recovery? (Choose all that apply.)

  A. Any gap in archive logs ends the recovery.
  B. If a gap in archive logs is encountered, RMAN will search forward for newer versions of the blocks that are not corrupt.
  C. Uncorrupted blocks from the flashback logs may be used to speed recovery.
  D. The database can be in NOARCHIVELOG mode.
  E. None of the above.
  B. If a gap in archive logs is encountered, RMAN will search forward for newer versions of the blocks that are not corrupt.
  C. Uncorrupted blocks from the flashback logs may be used to speed recovery.

• Question 416:

  Which of these appropriately describes the results of a manual SQL Tuning Advisor task?

  A. A list of SQL statements and recommendations for tuning
  B. A list of SQL statements that have been tuned by the Advisor, with before and after metrics
  C. Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes
  D. All of the above
  A. A list of SQL statements and recommendations for tuning

• Question 417:

  To reference existing ASM files, you need to use a fully qualified ASM filename. Your development database has a disk group named DG2A, the database name is DEV19, and the ASM file that you want to reference is a datafile for the USERS02 tablespace.

  Which of the following is a valid ASM filename for this ASM file?

  A. dev19/+DG2A/datafile/users02.701.2
  B. +DG2A/dev19/datafile/users02.701.2
  C. +DG2A/dev19/users02/datafile.701.2
  D. +DG2A.701.2
  E. +DG2A/datafile/dev19.users.02.701.2
  B. +DG2A/dev19/datafile/users02.701.2

• Question 418:

  You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? (Choose two)

  A. You must configure block change tracking file
  B. You must have first level 1 backups for RMAN to restore blocks
  C. You must ensure that the SALES database is mounted or open
  D. You must have full or level 0 backups for RMAN to restore blocks
  E. You must take the tools01.dbf data file offline before you start a block media recovery
  C. You must ensure that the SALES database is mounted or open
  D. You must have full or level 0 backups for RMAN to restore blocks

• Question 419:

  View the Exhibit and examine the output.

  You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:

  ALTER TABLE exchange_rate FLASHBACK ARCHIVE;

  What is the outcome of this command?

  Exhibit:

  

  A. The Flashback Archive is created on the same tablespace where the tables are stored.
  B. The Flashback Archive is created on the SYSAUX tablespace.
  C. The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive.
  D. The table uses the default Flashback Archive.
  C. The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive.

• Question 420:

  Which statement describes the effect of table redefinition on the triggers attached to the table?

  A. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table.
  B. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.
  C. All triggers on the table remain valid.
  D. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table.
  A. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table.