Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 501:

  Which of the following statements is true regarding implementing a Flashback Table recovery?

  A. An SCN is never used to perform a Flashback Table recovery.
  B. If a significant number of changes have been made to the table, row movement must be enabled.
  C. The tablespace must be offline before performing a Flashback Table recovery.
  D. Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.
  D. Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.

• Question 502:

  What is the correct order of steps to perform an online database backup?

  a: alter database begin backup;

  b: alter database end backup;

  c: Back up the database datafiles.

  d: Back up the archive log files.

  e:

  alter system switch logfile;

  A. a, b, c, d, e
  B. e, d, a, b, c
  C. a, c, b, d, e
  D. d, b, c, a, e
  E. a, c, b, e, d
  E. a, c, b, e, d

• Question 503:

  Which background process coordinates the rebalance activity for disk groups?

  A. ORBn
  B. OSMB
  C. RBAL
  D. ASMn
  C. RBAL

• Question 504:

  A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?

  A. It remains valid.
  B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
  C. It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
  D. It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
  A. It remains valid.

• Question 505:

  Which statements are true regarding system-partitioned tables? (Choose all that apply.)

  A. Only a single partitioning key column can be specified.
  B. All DML statements must use partition-extended syntax.
  C. The same physical attributes must be specified for each partition.
  D. Unique local indexes cannot be created on a system-partitioned table.
  E. Traditional partition pruning and partitionwise joins are not supported on these tables.
  D. Unique local indexes cannot be created on a system-partitioned table.
  E. Traditional partition pruning and partitionwise joins are not supported on these tables.

• Question 506:

  Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.)

  A. Database datafiles
  B. Online redo logs
  C. Archived redo logs
  D. Backup control file
  E. Control file from a backup
  A. Database datafiles
  C. Archived redo logs
  D. Backup control file

• Question 507:

  Which of the following is true about job chains?

  A. They consist of one or more Scheduler programs.
  B. They are used to implement dependency scheduling.
  C. They are used to implement time-based scheduling.
  D. They are used to implement event-based scheduling.
  E. None of the above.
  B. They are used to implement dependency scheduling.

• Question 508:

  View the exhibit and examine the TRANS table's storage information. After a massive delete operation, you executed the following statement to shrink the TRANS table:

  SQL> ALTER TABLE trans SHRINK SPACE CASCADE;

  Which statement describes the outcome of the command?

  Exhibit:

  

  A. An error is produced.
  B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted
  C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged
  D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
  B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted

• Question 509:

  Which two statements regarding the Flashback Table feature are correct? (Choose two.)

  A. Flashback Table can be performed on system tables.
  B. Flashback Table operation does not shrink the segments.
  C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
  D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.
  B. Flashback Table operation does not shrink the segments.
  D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.

• Question 510:

  The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)

  A. The initialization parameter should be set to 0 when the RMAN repository is being used.
  B. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the recovery catalog only.
  C. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the control file or the recovery catalog.
  D. The initialization parameter should be set to 0 with the RMAN repository utilizing the control file or the recovery catalog.
  E. The initialization parameter should never be set to 0 if you are using RMAN.
  C. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the control file or the recovery catalog.
  E. The initialization parameter should never be set to 0 if you are using RMAN.