To enable the Database Smart Flash Cache, you configure the following parameters:

DB_FLASH_CACHE_FILE = `/dev/flash_device_1' , `/dev/flash_device_2' DB_FLASH_CACHE_SIZE=64G

What is the result when you start up the database instance?

A. It results in an error because these parameter settings are invalid.

B. One 64G flash cache file will be used.

C. Two 64G flash cache files will be used.

D. Two 32G flash cache files will be used.

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 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.

B. It generates an error when creating the table because the wallet is closed.

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 generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

Examine the commands executed to monitor database operations:

$> conn sys oracle/oracle@prod as sysdba

SQL > VAR eid NUMBER

SQL > EXEC: eid:= DBMS_SQL_MONITOR.BEGIN_OPERATION ('batch_job', FORCED_TRACKING =>

'Y');

Which two statements are true? (Choose two.)

A. Database operations will be monitored only when they consume a significant amount of resources.

B. Database operations for all sessions will be monitored.

C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set to DIAGNISTIC + TUNING.

D. Only DML and DDL statements will be monitored for the session.

E. All subsequent statements in the session will be treated as one database operation and will be monitored.

Which two statements are true about Oracle Direct Network File System (NFS)?

A. Direct NFS can use only the oranfstab configuration file located in $ORACLE_HOME/dbs/.

B. It utilizes the operating system file system cache.

C. Oracle Database requires mount points to be mounted by the kernel NFS system even when served through the Direct NFS client.

D. The Oracle database files available on the NFS server that are served by the Direct NFS Client cannot be accessed through the operating system kernel NFS.

E. Direct NFS performs load balancing across all specified paths. If a specified path fails, Direct NFS reissues I/O commands over any remaining paths.

The current system change number (SCN) for a live database is 663571.

You decide to use the FLASHBACK TABLE statement to flash back the CUSTOMERS table to SCN 662116.

After flashing back the CUSTOMERS table, you query it and decide to undo the effects of the FLASHBACK TABLE command.

Which is the fastest way to do this?

A. Execute the RMAN RECOVER BLOCK command by specifying the table name and SCN 663571 because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.

B. Execute another FLASHBACK TABLE statement to restore the CUSTOMERS table to SCN 663571.

C. Perform table point-in-time recovery because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.

D. Perform tablespace point-in-time recovery because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.