Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 421:

  Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?

  A. AWR baselines are always created as repeating baselines.
  B. AWR baselines can be created on the basis of two time values.
  C. AWR baselines are always created with infinite expiration duration.
  D. AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.
  B. AWR baselines can be created on the basis of two time values.

• Question 422:

  Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.)

  A. Diagnose and repair a data file corruption offline.
  B. Diagnose and repair a data file corruption online.
  C. Diagnose and repair failures on a standby database.
  D. Recover from failures in the Real Application Cluster (RAC) environment.
  C. Diagnose and repair failures on a standby database.
  D. Recover from failures in the Real Application Cluster (RAC) environment.

• Question 423:

  Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.)

  A. ASCII
  B. ANSI
  C. BINARY
  D. MONOLINGUAL
  E. MULTILINGUAL
  B. ANSI
  C. BINARY

• Question 424:

  Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation?

  A. ADD DIRECTORY
  B. DROP DISK
  C. RESIZE DISK
  D. REBALANCE
  E. ADD FAILGROUP
  A. ADD DIRECTORY

• Question 425:

  What is the impact of the following backup if it exceeds the duration allowance?

  backup as compressed backupset duration 2:00 partial minimize load database ;

  A. The entire backup will fail. It will not be usable for recovery.
  B. The entire backup will fail, but any datafile successfully backed up will be usable for recovery.
  C. If this backup fails, subsequent backups will prioritize datafiles not backed up.
  D. If this backup fails, an error will be raised and any other commands will not be executed.
  E. If this backup fails, no error will be raised and any other commands will be executed.
  B. The entire backup will fail, but any datafile successfully backed up will be usable for recovery.

• Question 426:

  What are the two different types of database duplication? (Choose two.)

  A. Active
  B. Passive
  C. Online
  D. Backup-based
  E. Failure driven
  A. Active
  D. Backup-based

• Question 427:

  While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.

  A. An entry is created in the alert log file and the database instance continues to function normally
  B. The log switch hangs occur for transactions until free space is available in the flash recovery area
  C. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
  D. The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
  B. The log switch hangs occur for transactions until free space is available in the flash recovery area
  C. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area

• Question 428:

  You are performing incomplete recovery using RMAN. You execute the following RUN block:

  RUN

  {

  SET UNTIL SCN 1107600;

  RESTORE DATABASE;

  RECOVER DATABASE;

  }

  Which statement is true about the result?

  A. RMAN restores all datafiles from the most recent backup available since the failure and applies the redo logs necessary to recover the database to SCN 1107600
  B. RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.
  C. RMAN restores all datafiles and control files from the most recent backup
  D. The RUN block fails because you did not specify an UNTIL clause in your RECOVER DATABASE command
  B. RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.

• Question 429:

  View the Exhibit.

  As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals.

  Which background process performs this activity?

  

  A. CKPT
  B. SMON
  C. MMON
  D. DBWR
  C. MMON

• Question 430:

  The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.

  What action is required for the dependent objects when you perform online redefinition on the table?

  A. The materialized view should have a complete refresh performed after the online table redefinition is completed.
  B. The materialized view should have a fast refresh performed after the online table redefinition is completed.
  C. The materialized view, materialized log, and the index should be dropped and re-created after the online table redefinition is complete.
  D. The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
  A. The materialized view should have a complete refresh performed after the online table redefinition is completed.