You create a new pluggable database, HR_PDB, from the seed database. 

Which three tablespaces are created by default in HR_PDB? (Choose three.)

Which two statements are true about variable extent size support for large ASM files? (Choose two.)

You executed a DROP USER 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?

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?

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE” statement?

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. 

You have set the DB_SMART_FLASH_FILE parameter: 

DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’ 

How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

Examine the following parameters for a database instance: 

MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 

SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m

Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

Examine the contents of SQL loader control file: 

Which three statements are true regarding the SQL* Loader operation performed using the control file? (Choose three.)