Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 201:

  What RMAN command is used to execute a tablespace point-in-time recovery?

  A. recover
  B. duplicate
  C. restore
  D. copy
  E. None of the above
  A. recover

• Question 202:

  Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)

  A. A single SQL statement provided by a user
  B. An existing SQL Tuning Set (STS)
  C. A preprocessed Database Replay workload
  D. A schema name
  E. SQL statement identified in EM as using excessive resources
  C. A preprocessed Database Replay workload
  D. A schema name

• Question 203:

  You plan to execute the following command to perform a Flashback Database operation in your database:

  SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);

  Which two statements are true about this? (Choose two)

  A. The database must have multiplexed redo log files
  B. The database must be in the MOUNT state to execute the command
  C. The database must be in the NOMOUNT state to execute the command
  D. The database must be opened in RESTRICTED mode before this operation
  E. The database must be opened with the RESETLOGS option after the flashback operation
  B. The database must be in the MOUNT state to execute the command
  E. The database must be opened with the RESETLOGS option after the flashback operation

• Question 204:

  The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline.

  Which two operations are performed by the optimizer in this scenario? (Choose two.)

  A. The optimizer adds the new plan to the plan history.
  B. The optimizer selects the new plan for the execution of the SQL statement.
  C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
  D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
  E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
  A. The optimizer adds the new plan to the plan history.
  E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

• Question 205:

  You want to set the following initialization parameters for your database instance:

  LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch' LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY'

  Identify the statement that correctly describes this setting.

  A. The MANDATORY location must be a flash recovery area.
  B. The optional destinations may not use the flash recovery area.
  C. This setting is not allowed because the first destination is not set as MANDATORY.
  D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.
  D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

• Question 206:

  You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.

  What must you do accomplish this task?

  A. Enable supplemental logging for the database.
  B. Specify undo retention guarantee for the database
  C. Create Flashback Data Archive in the tablespace where the tables are stored.
  D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables
  D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables

• Question 207:

  What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?

  A. 100KB default, 10TB maximum
  B. 256KB default, 1024MB maximum
  C. 10MB default, 126PB maximum
  D. 64KB default, 1EB maximum
  E. 1MB default, 64MB maximum
  E. 1MB default, 64MB maximum

• Question 208:

  The following command is executed to create the baseline template:

  SQL> EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE

  ( START_TIME=> TO_TIESTAMP(SYSDATE+2),

  END_TIME=>TO_TIMESTAMP(SYSDATE+10),

  BASELINE_NAME=>'Mybase4',

  TEMPLATE_NAME=>'Mytemp4',

  EXPIRATION=>NULL);

  Which statement is true about the effect of the above command?

  A. It creates a baseline template that never expires.
  B. It produces an error because no snapshot information is provided to create the baseline.
  C. It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.
  D. It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.
  A. It creates a baseline template that never expires.

• Question 209:

  You want to migrate your database to ASM, so you have done a clean shutdown, made a closed backup of the entire database. You noted the location of your control files and online redo log files, and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion. Using the following steps, what is the correct order in which the following RMAN commands should be executed?

  1.

  STARTUP NOMOUNT

  2.

  ALTER DATABASE OPEN RESETLOGS

  3.

  SQL "ALTER DATABASE RENAME 'logfile1' path TO '+dgrp4'" # plus all other logfiles

  4.

  SWITCH DATABASE TO COPY

  5.

  BACKUP AS COPY DATABASE FORMAT '+dgrp4'

  6.

  ALTER DATABASE MOUNT

  7.

  RESTORE CONTROLFILE FROM 'controlfile_location'

  A. 2, 5, 3, 1, 7, 6, 4
  B. 1, 7, 6, 5, 4, 3, 2
  C. 5, 1, 2, 7, 4, 6, 3
  D. 7, 3, 1, 5, 6, 2, 4
  B. 1, 7, 6, 5, 4, 3, 2

• Question 210:

  Your production database is functional on the SHOST1 host. You are backing up the production database by using Recovery Manager (RMAN) with the recovery catalog. You want to replicate the production database to anther host, SHOST2, for testing new applications. After you ensured that the backups of the target database are accessible on the new host, what must you do to restore and recover the backup for the test environment?

  A. Restoring the control file from the backup by using the NOCATALOG option to restore, and recovering the data files
  B. Restoring the data files by using the NOCATALOG option and using the SET NEWNAME command to change the location
  C. Restoring the server parameter file from the backup by using the recovery catalog to restore,
  D. Restoring the data files from the backup by using the recovery catalog to recover the files, and using the SWITCH command to change the location.
  A. Restoring the control file from the backup by using the NOCATALOG option to restore, and recovering the data files