Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 301:

  Your company wants to upgrade the production database to a Real Application Clusters (RAC) environment.

  You set up the best RAC database and want to replay a recorded workload captured from the production database on the test machine.

  The following steps may be used to replay the database workload:

  1) Preprocess the captured workload

  2) Restart the database in RESTRICTED mode.

  3) Set up Replay Clients.

  4) Restore the test database to the point when the capture started.

  5) Remap connections.

  Which is the correct sequence of the required steps?

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

• Question 302:

  You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?

  A. A base catalog exists
  B. The recovery catalog is empty
  C. The base recovery catalog must be dropped
  D. A target database is registered in the recovery catalog
  A. A base catalog exists

• Question 303:

  Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup?

  A. ASM_DISKMOUNT
  B. ASM_DISKGROUP
  C. ASM_DISKSTRING
  D. ASM_MOUNTGROUP
  B. ASM_DISKGROUP

• Question 304:

  Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?

  A. Yes, if the database is in ARCHIVELOG mode.
  B. Yes, if the database is in NOARCHIVELOG mode.
  C. No, the backup is not usable in any way.
  D. Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE.
  C. No, the backup is not usable in any way.

• Question 305:

  You executed the following PL/SQL block successfully:

  

  The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis ____.

  A. with the CPU Usage finding if it is less than 90
  B. without the CPU Usage finding if it is less than 90
  C. with the CPU Usage finding for snapshots below 90
  D. with the CPU Usage finding for snapshots not between 150 and 162
  B. without the CPU Usage finding if it is less than 90

• Question 306:

  Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?

  A. All objects in the database
  B. Tables owned by SYS and SYSTEM
  C. Data dictionary tables
  D. NCHAR columns
  E. CHAR columns
  E. CHAR columns

• Question 307:

  The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed?

  A. The Oracle database will perform block checking for the index blocks only
  B. The Oracle database will not perform block checking for any of the data blocks
  C. The Oracle database will perform block checking for the default permanent tablespace only
  D. The Oracle database will perform block checking for the data blocks in all user tablespaces
  E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
  E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

• Question 308:

  What happens when you run the SQL Tuning Advisor with limited scope?

  A. Access path analysis is not performed for SQL statements.
  B. SQL structure analysis is not performed for SQL statements.
  C. SQL Profile recommendations are not generated for SQL statements.
  D. Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.
  B. SQL structure analysis is not performed for SQL statements.

• Question 309:

  The following command is executed to shut down an Automatic Storage Management (ASM) instance: SQL>SHUTDOWN ABORT; Which two statements describe the consequences of the above command? (Choose two.)

  A. The disk groups are orderly dismounted.
  B. The ASM instance requires recovery when it is started.
  C. The database instance that are currently clients of the ASM instance are aborted.
  D. The CSS daemon stops and has to be restarted before the ASM instance is restarted.
  B. The ASM instance requires recovery when it is started.
  C. The database instance that are currently clients of the ASM instance are aborted.

• Question 310:

  To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)

  A. LOG_HISTORY
  B. JOB_LOG_RETENTION
  C. WINDOW_LOG_RETENTION
  D. WHICH_LOG
  E. LOG_NAME
  A. LOG_HISTORY
  D. WHICH_LOG