Examine the command to perform a data pump export operation on a source database:
$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept On the target database, you execute the data pump import command:
$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept Which three statements are true? (Choose three.)

• A. All rows from the dependent objects, along with the metadata required to create the EMP_DEPT view, are exported.
• B. The expdp operation exports data that satisfies the condition of the defining query used to create the EMP_DEPT view.
• C. The impdp operation creates EMP_DEPT as table and populates it with the data from the export dump file.
• D. The impdp operation creates the view and dependent objects.
• E. Objects dependent on the EMP_DEPT view are exported.

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

• A. Transportable database
• B. Data Pump full export / import
• C. Transportable tablespace
• D. The DBMS_PDB package
• E. RMAN

A PFILE exists for your database. You want to increase the value of the PROCESSES parameter from 300 to
400 and make it persistent for your database instance.
You plan to use the ALTER SYSTEM command.
Which two methods can be used? (Choose two.)

• A. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=DEFERRED command.
• B. Edit PFILE manually, re-create the SPFILE from the edited PFILE, and restart the database instance by using the SPFILE.
• C. Use the PFILE to STARTUP MOUNT the database instance, and then execute the ALTER SYSTEM SET PROCESSES=400 command.
• D. Create an SPFILE, STARTUP MOUNT the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 command.
• E. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=SPFILE command.
• F. Start the database instance by using the PFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=BOTH command.

You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?

• A. It generates an error when creating the table because the wallet is closed.
• B. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
• C. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
• D. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.