Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 91:

  You issue the following RMAN command to set a retention policy on a database:

  RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

  What will be the outcome of issuing this command?

  A. After two days, a backup will be marked obsolete
  B. After two days, a backup will be deleted from the media
  C. If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.
  D. If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.
  D. If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.

• Question 92:

  You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache contains the ideal workload for analysis. You want to analyze only a few most resource-intensive statements. What must you do to receive recommendations on efficient use of indexes and materialized views to improve query performance?

  A. Run the SQL Access Advisor.
  B. Run the SQ; Tuning Advisor (STA).
  C. Run the Automatic Workload Repository (AWR) report.
  D. Run the Automatic Database Diagnostic Monitor (ADDM).
  A. Run the SQL Access Advisor.

• Question 93:

  You have a very large table that your users access frequently.

  Which of the following advisors will recommend any indexes to improve the performance of queries against this table?

  A. The Automatic Memory Manager (AMM)
  B. The SQL Tuning Advisor
  C. The Segment Advisor
  D. The SQL Access Advisor
  D. The SQL Access Advisor

• Question 94:

  On the development database rac0, there are six raw devices: /dev/raw/raw1 through /dev/raw/raw6. /dev/raw/raw1 and /dev/raw/raw2 are 8GB each, and the rest are 6GB each. An existing disk group +DATA1, of NORMAL REDUNDANCY, uses /dev/raw/raw1 and /dev/raw/raw2.

  Which series of the following commands will drop one of the failure groups for +DATA1, create a new disk group +DATA2 using two of the remaining four raw devices, and then cancel the drop operation from +DATA1?

  

  A. B. C. D.
  A. B. C. D.

• Question 95:

  Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause. Which components are backed up when this option is specified?

  A. only the control file, the current SPFILE, and data files
  B. only the current SPFILE and data files if autobackup is disabled
  C. only the data files and the archived redo logs
  D. the control file, current SPFILE file, data files, and archived redo logs
  D. the control file, current SPFILE file, data files, and archived redo logs

• Question 96:

  Evaluate the following SQL statement used to create the PRODUCTS table:

  CREATE TABLE products (

  product_id NUMBER(3) PRIMARY KEY,

  product_desc VARCHAR2(25),

  qty NUMBER(8,2),

  rate NUMBER(10,2),

  total_value AS ( qty * rate))

  PARTITION BY RANGE (total_value) (

  PARTITION p1 VALUES LESS THAN (100000),

  PARTITION p2 VALUES LESS THAN (150000),

  PARTITION p3 VALUES LESS THAN (MAXVALUE))

  COMPRESS FOR ALL OPERATIONS;

  Which statement is true regarding this command?

  A. It executes successfully but partition pruning cannot happen for this partition key.
  B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
  C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
  D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
  D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

• Question 97:

  Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.)

  A. Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository (ADR).
  B. The problem key is the same as the incident number.
  C. The database sends an incident alert to the Oracle Enterprise Manager Database Home page.
  D. Every problem has a problem key, which is a text string that describes the problem.
  E. The database makes an entry into the alert log file when problems and incidents occur.
  C. The database sends an incident alert to the Oracle Enterprise Manager Database Home page.
  D. Every problem has a problem key, which is a text string that describes the problem.
  E. The database makes an entry into the alert log file when problems and incidents occur.

• Question 98:

  What is the proper procedure to recover a lost tempfile?

  A. Restore the backup copy of the tempfile from the backup media.
  B. Re-create the tempfile with the create tempfile command.
  C. Copy an existing tempfile from another database.
  D. Re-create the tempfile with the create tablespace command.
  E. Re-create the tempfile with the alter tablespace command.
  E. Re-create the tempfile with the alter tablespace command.

• Question 99:

  Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)

  A. A single ADR can support multiple ADR homes for different database instances.
  B. The alert files are stored in XML file format in the TRACE directory of each ADR home.
  C. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to $ORACLE_BASE.
  D. The BACKGROUND_DUMP_DEST initialization parameter overrides the DIAGNOSTIC_DEST initialization parameter for the location of the alert log file.
  A. A single ADR can support multiple ADR homes for different database instances.
  C. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to $ORACLE_BASE.

• Question 100:

  Which two statements about the SQL Management Base (SMB) are true? (Choose two.)

  A. It contains only SQL profiles generated by SQL Tuning Advisor.
  B. It stores plans generated by the optimizer using a stored outline.
  C. It is part of the data dictionary and stored in the SYSAUX tablespace.
  D. It is part of the data dictionary and stored in the SYSTEM tablespace.
  E. It contains the statement log, the plan history, plan baselines, and SQL profiles.
  C. It is part of the data dictionary and stored in the SYSAUX tablespace.
  E. It contains the statement log, the plan history, plan baselines, and SQL profiles.