Learn with Oracle : 1Z0-060 training material for 100% pass

Examine the parameters for your database instance:

Which three statements are true about the process of automatic optimization by using cardinality feedback?

• A. The optimizer can re optimize a query only once using cardinality feedback.
• B. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
• C. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
• D. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
• E. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.

Which two statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled in UNIX?

• A. Thread creation must be routed through a dispatcher process.
• B. Each Oracle process runs an SCMN thread.
• C. Each multithreaded Oracle process has an SCMN thread.
• D. The local listener may pass the request to an existing process which in turn will create a thread.

Your multitenant container database (CDB) is running in ARCHIVELOGmode. You connect to the CDB RMAN.
Examine the following command and its output:

You execute the following command:
RMAN > BACKUP DATABASE PLUS ARCHIVELOG;
Which data files will be backed up?

• A. Data files that belong to only the root container and PDB$SEED
• B. Data files that belong to only the root container
• C. Data files that belong to the root container and all the PDBs excluding PDB$SEED
• D. Data files that belong to the root container and all the pluggable databases (PDBs)

You notice that the elapsed time for an important database scheduler job is unacceptably long.
The job belongs to a scheduler job class and runs in a scheduler window.
Which two actions could reduce the job's elapsed time?

• A. Increasing the value of the JOB_QUEUE_PROCESSES parameter
• B. Increasing the priority of the scheduler window to which the job belongs
• C. Moving the job to an existing higher priority scheduler window with the same schedule and duration
• D. Increasing the job's relative priority within the Job class to which it belongs
• E. increasing resource allocation for the consumer group mapped to the job class in the resource manager plan associated with the scheduler window

On your Oracle Database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON or-orders (customer_id,
sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?

• A. Both the indexes are created and used by the optimizer for queries on the ORDERS table.
• B. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
• C. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.
• D. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
• E. Only the ORD_CUSTOMER_IX1 index created.
• F. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.