Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

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 are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. 

You plan to create the database using SQL statements. 

Which three techniques can you use to achieve this? (Choose three.)

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?

An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. 

A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE 

Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode? (Choose four.)

You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. 

You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report? (Choose three.)

Examine the parameter for your database instance (TABLE-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 (TABLE-2): 

Identify the reason why the optimizer chose different execution plans.

Which three statements are true about adaptive SQL plan management? (Choose three.)