Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 651:

  Which two prerequisites are needed for performing workload capture and replay? (Choose two.)

  A. Close all sessions performing queries using database links.
  B. running the database in shared server mode
  C. The database on which the workload is replayed has to be a restore of the original database to a specific SCN.
  D. setting up the directory to capture the workload
  C. The database on which the workload is replayed has to be a restore of the original database to a specific SCN.
  D. setting up the directory to capture the workload

• Question 652:

  You have backed up your database using image copies. You have lost the SYSTEM tablespace and need to restart your database as quickly as possible. What is the correct solution?

  A. Restore the SYSTEM tablespace from the last backup set and then recover the database.
  B. Restore the SYSTEM tablespace image copy using the restore command and then restore the database.
  C. Use the switch datafile command to instantly switch to the datafile copy, recover the tablespace, and open the database.
  D. The database is not recoverable in this situation with image copies.
  E. Manually copy the datafile image copy to the correct location and then manually restore the database from SQL*Plus.
  C. Use the switch datafile command to instantly switch to the datafile copy, recover the tablespace, and open the database.

• Question 653:

  You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?

  A. Create and populate a SQL Tuning Set from the AWR on every Monday.
  B. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
  C. Create a repeating baseline template.
  D. Insert a finding directive for future ADDM tasks.
  C. Create a repeating baseline template.

• Question 654:

  What is an obsolete backup set?

  A. A backup set that is missing one or more backup set pieces
  B. A backup that has exceeded the retention criteria and is no longer needed
  C. A backup set that does not include archived redo logs
  D. A backup set that can not be recovered due to corruption
  E. A backup set superceded by a datafile copy
  B. A backup that has exceeded the retention criteria and is no longer needed

• Question 655:

  Which command would you use to determine what database backups are currently available for restore?

  A. list database backup;
  B. report database backup;
  C. list backup of database;
  D. list summary backup;
  E. report backup of database;
  C. list backup of database;

• Question 656:

  You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users' passwords?

  A. All passwords automatically become case-sensitive.
  B. All passwords remain non-case-sensitive till they are changed.
  C. All passwords remain non-case-sensitive and cannot be changed.
  D. All passwords remain non-case-sensitive until their password attribute in the profile is altered.
  B. All passwords remain non-case-sensitive till they are changed.

• Question 657:

  View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is the Significance Level threshold type not available in the threshold setting? Exhibit:

  

  A. because AWR baseline is not enabled
  B. because Current Open Cursors Count is not a basic metric
  C. because the STATISTICS_LEVEL parameter is set to BASIC
  D. because the AWR baseline is a system-defined moving window baseline
  B. because Current Open Cursors Count is not a basic metric

• Question 658:

  You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.

  You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import.

  You executed the following commands to achieve this:

  RMAN> CONNECT CATALOG rco11/password@catdb

  RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;

  What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?

  A. The scripts in the RCO11 catalog are overwritten.
  B. RMAN renames the local stored scripts in the RCO11 catalog.
  C. The RMAN session in which the command is executed aborts.
  D. RMAN renames the global scripts that are imported from the RCAT10 catalog.
  D. RMAN renames the global scripts that are imported from the RCAT10 catalog.

• Question 659:

  To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do?

  A. TRUNCATE the archive table.
  B. DROP the Flashback Data Archive.
  C. Nothing; expired rows are automatically removed.
  D. Nothing; expired rows are moved to an archive table.
  E. Delete entries from the archive where the metadata date retained is greater than the retention period.
  C. Nothing; expired rows are automatically removed.

• Question 660:

  You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view, materialized log, indexes, referential integrity constraint, and triggers with the PRECEDES clause existing on it.

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

  A. The dependent materialized view should have a complete refresh performed after the online table redefinition process.
  B. Triggers with the PRECEDES clause should be disabled before the online table redefinition process.
  C. Referential integrity constraints must be manually enabled after the online table redefinition process.
  D. The materialized log should be dropped before the online table redefinition process.
  A. The dependent materialized view should have a complete refresh performed after the online table redefinition process.