单选题
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?

单选题
Examine the parameter for your database instance:
NAME TYPE VALUE
-------------------------------------------------------------------------------------------- ---------------- ---------
Optimizer_adaptive _ reporting _ only boolean FALSE
Optimizer_capture_sql_plan_baselines boolean FALSE
Optimizer_dynamic_sampling integer 2
Optimizer _ features _ enable string 12.1.0.1
You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:
SQL> SELECT product_name
FROM order_items o, product_infornation p
WHERE o.unit price = 15
AND quantity > 1
AND p.product_id = o.product_1d; 30 rows selected.
Identify the reason why the optimizer chose different execution plans.

单选题 Examine the following query output:
SQL> SELECT name, force_logging FROM vSdatabase;
NAME FORCE_LOGGING
------------ ---------------------------
PROD NO
You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

单选题
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?

单选题
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several1pl7uggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

单选题
You executed a DRO1P7USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?

单选题
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
–Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
–Character set: AL32UTF8
–National character set: AL16UTF16
–O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
–Version: Oracle Database 12c Release 1 64-bit
–Character Set: AL32UTF8
–National character set: AL16UTF16
–O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

单选题
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?