Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 351:

  View the Exhibit and examine the output.

  You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:

  ALTER TABLE exchange_rate FLASHBACK ARCHIVE;

  What is the outcome of this command?

  Exhibit:

  

  A. The Flashback Archive is created on the same tablespace where the tables are stored.

  B. The Flashback Archive is created on the SYSAUX tablespace.

  C. The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive.

  D. The table uses the default Flashback Archive.

  Correct Answer: C

• Question 352:

  Which two statements regarding the Flashback Table feature are correct? (Choose two.)

  A. Flashback Table can be performed on system tables.

  B. Flashback Table operation does not shrink the segments.

  C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.

  D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.

  Correct Answer: BD

  Semantics During an Oracle Flashback Table operation, Oracle Database acquires exclusive DML locks on all the tables specified in the Flashback list. These locks prevent any operations on the tables while they are revertingto their earlier state. Restrictions on Flashing Back Tables

  This statement is subject to the following restrictions:

  Flashback Table operations are not valid for the following type objects: tables that are part of a cluster, materialized views, Advanced Queuing (AQ) tables, static data dictionary tables, system tables, remote tables, object tables, nested tables, or individual table partitions or subpartitions.

  The following DDL operations change the structure of a table, so that you cannot subsequently use the TO SCN or TO TIMESTAMP clause to flash the table back to a time preceding the operation: upgrading, moving, or truncating a table; adding a constraint to a table, adding a table to a cluster; modifying or dropping a column; changing a column encryption key; adding, dropping, merging, splitting, coalescing, or truncating a partition or subpartition (with the exception of adding a range partition).

• Question 353:

  View the Exhibit to examine the output for the V$DIAG_INFO view.

  Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)

  Exhibit:

  

  A. The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/ rdbms/orclbi/orclbi/trace.

  B. The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

  C. The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.

  D. The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

  Correct Answer: ACD

• Question 354:

  Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

  A. failures because a data file is renamed by error

  B. failures when no standby database is configured

  C. failures that require no archive logs to be applied for recovery

  D. failures due to loss of connectivity-for example, an unplugged disk cable

  Correct Answer: AD

• Question 355:

  Which two statements are true regarding the starting of the database instance using the following command? (Choose two.)

  SQL>STARTUP UPGRADE

  A. It enables all system triggers.

  B. It allows only SYSDBA connections.

  C. It ensures that all job queues remain active during the upgrade process.

  D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

  Correct Answer: BD

• Question 356:

  Which two statements are true regarding the SQL Repair Advisor? (Choose two.)

  A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.

  B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.

  C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.

  D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

  Correct Answer: BD

  You can run SQL Repair Advisor through the EM Support Workbench when an incident raised. Or You run the SQL Repair Advisor by creating and executing a diagnostic task using the DBMS_SQLDIAG. CREATE_DIAGNOSIS_TASK and DBMS_SQLDIAG. respectively. The SQL Repair Advisor first reproduces the critical error and then tries to produce a workaround in the form of SQL patch.

• Question 357:

  Which setting enables the baselines by default in Oracle Database 11g?

  A. setting the STATISTICS_LEVEL parameter to TYPICAL

  B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)

  C. enabling Automated Maintenance Task using Oracle Enterprise Manager

  D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

  Correct Answer: A

• Question 358:

  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.

  Correct Answer: CD

• Question 359:

  Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?

  A. The database must be running in ARCHIVELOG mode.

  B. No special setup is required, and the feature is enabled by default.

  C. The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.

  D. The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.

  E. Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.

  Correct Answer: E

• Question 360:

  Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

  A. The ADR base keeps all diagnostic information in binary format

  B. SQL*Plus provides the ADRI script, which can be used to work with ADR

  C. The ADR can be used for problem diagnosis only when the database is open

  D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

  E. The ADR can be used for problem diagnosis even when the database instance is down

  F. The ADR base is shared across multiple instances

  Correct Answer: EF