Which two partitioning methods are suitable for a parent table when using reference partitioning in Oracle Database 12c? (Choose two.) A. interval partitioning B. list partitioning C. system partitioning D. hash partitioning E. range partitioning

Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.) A. The unplugged PDB can be plugged into the same multitenant container database (CDB). B. The unplugged PDB can be plugged into another CDB. C. The PDB…

Your multitenant container database (CDB) contains several pluggable databases (PDBs). A common user C##A_ADMIN, is created with connect privileges. You execute this command from the root container: SQL> GRANT create tablespace to C##A_ADMIN; Which statement is true? A. The command…

You execute this piece of code with appropriate privileges: User SCOTT has been granted the CREATE SESSION privilege and the MGR role. Which two statements are true when a session logged in as SCOTT queries the SAL columns in the…

While investigating a possible security breach, you realized that some audit records were not retrieved when the UNIFIED_AUDIT_TRAIL view was queried. How can you ensure that all available audit records are returned when the audit trail is queried? A. Query…

Which two statements are true regarding SQL*Loader Express Mode in an Oracle 12c database? (Choose two.) A. You cannot have multiple SQL*Loader data files. B. The DEGREE_OF_PARALLELISM parameter is set to AUTO. C. If no data file is specified, it…

Your multitenant container database (CDB) contains several pluggable databases (PDBs). Users C##A_ADMIN and B_ADMIN have only connect privileges. You create a common role C##_ROLE1 with common privileges CREATE TABLE and SELECT ANY TABLE. You then execute these commands to grant…

Your multitenant container database (CDB) contains two pluggable databases (PDBs). Which three tools can be used to add a new PDB to the CDB? (Choose three.) A. Enterprise Manager Cloud Control B. SQL Developer C. Database Upgrade Assistant (DBUA) D.…

DBS_IND_PARTITIONS.ORPHANED_ENTRIES contains YES for several index partitions. This is due to the use of deferred index maintenance. Which three methods will remove the orphaned keys? (Choose three.) A. using ALTER INDEX REBUILD PARTITION once for each affected local index partition…

Which three statements are true about the use of the query result cache? (Choose three.) A. Results obtained from a query rewrite to a materialized view may be stored in the query result cache. B. Stale results may still be…