Free Oracle 1Z1-050 Exam Dumps Questions & Answers

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?

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

You issued the following RMAN command to back up the database: RMAN> RUN{ ALLOCATE CHANNEL c1 DEVICE TYPE Sbt BACKUP DATABASE TAG quarterly KEEP FOREVER RESTORE POINT FY06Q4;}
Which two statements are true regarding the backup performed? (Choose two.)

• A.The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.
• B.Archived log files are backed up along with data files, and the archived log files are deleted.
• C.Only data files are backed up and a restore point named FY06Q4 is created.
• D.Archived redo log files are backed up along with data files

View the Exhibit to examine the error during the database startup.

You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of the command?

• A.The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).
• B.The command only displays the advice and the RMAN script required for repair.
• C.The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command
• D.The command performs the recovery and closes the failures.

Which two statements about workload capture and replay operations are true? (Choose two.)

• A.The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
• B.Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
• C.The clients must be created manually on the test machines to perform more realistic testing.
• D.Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.

You executed the following commands:
SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;
SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS('SHI, 'CUSTOMERS', 'PUBLISH'.'false');
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');
Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

• A.The statistics are stored in the pending statistics table in the data dictionary.
• B.The statistics are treated as the current statistics by the optimizer for all sessions.
• C.The statistics are temporary and used by the optimizer for all sessions until this session terminates.
• D.The statistics are treated as the current statistics by the optimizer for the current sessions only.