Free Oracle 1Z0-050 Exam Dumps Questions & Answers

Which three statements correctly describe the features of the I/O calibration process? (Choose three.)

• A.  Only one I/O calibration process can run at a time
• B.  It automates the resource allocation for the Automated Maintenance Tasks.
• C.  It can be used to estimate the maximum number of l/Os and maximum latency time for the system.
• D.  The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRU
• E.  It improves the performance of the performance-critical sessions while running.

In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file.
You issued the following command:
SQL>SELECT /*+ RESULT_CACHE 7 sale_categoiy, sum(sale_amt)
FROM sales
GROUP BY sale_categoiy;
Where would the result of this query be stored?

• A.  shared pool
• B.  PGA
• C.  large pool
• D.  database buffer cache

Evaluate the following code:
SQL>VARIABLE task_name VARCHAR2(255);
SQL>VARIABLE sql_stmt VARCHAR2(4000);
SQL>BEGIN
:sql_stmt := 'SELECT COUNTO FROM customers
WHERE cust_state_province ="CA"; :task_name := 'MY_QUICKTUNE_TASK';
DBMS_ADVISOR .QUICK_TUNE(DBMS_ADVISOR .SQLACCESS_ADVISOR,
:task_name, :sql_stmt);
END;
What is the outcome of this block of code?

• A.  It creates a task and workload but does not execute the task.
• B.  It produces an error because a template has not been created.
• C.  It produces an error because the SQL Tuning Set has not been created.
• D.  It creates a task and workload, and executes the task.

Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)

• A.  initialization parameter settings
• B.  all the optimizer statistics
• C.  PL/SQL functions, procedures, and packages
• D.  ADR diagnostic files
• E.  the table and index definitions and actual data

You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of l/Os. Which statement describes a solution to the above?

• A.  Set a threshold for the default system-defined moving window baseline.
• B.  Add directives to the Automatic Database Diagnostic Monitor (ADDM).
• C.  Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
• D.  Modify the profile for the targeted users for which control needs to be imposed.