Oracle 1Z0-053 dumps - 100% Pass Guarantee!

While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced.

Which two statements describe the consequences? (Choose two.)

A. The plan baselines can be evolved over time to produce better performance.

B. The newly generated plans are directly placed into the SQL plan baseline without being verified.

C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.

D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

View the Exhibit to examine the metrics with a threshold.

Which statement is true regarding the Number of Transactions (per second) metric?

Exhibit:

A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.

B. The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.

C. Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.

D. The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.

Which method would you use to undo the changes made by a particular transaction without affecting the made by other transactions?

A. Point-in-time recovery

B. Execute the ROLLBACK command with transaction number

C. Flashback the database to before the transaction was committed

D. Determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions? (Choose four.)

A. ALTER DATABASE FLASHBACK ON;

B. GRANT SELECT ANY TRANSACTION TO scott;

C. GRANT EXECUTE ON dbms_flashback TO scott;

D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;

F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

Which option is best practice for creating a recovery catalog owner in the catalog database?

A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner

B. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user

C. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user

D. Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user