Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)

• A.It utilizes the OS file system cache.
• B.A traditional NFS mount is not required when using Direct NFS.
• C.Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
• D.Direct NFS is available only in UNIX platforms.
• E.Direct NFS can load-balance I/O traffic across multiple network adapters.

Comment: *

Name: *

Email: *

Verification: *

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?

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

Comment: *

Name: *

Email: *

Verification: *

Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?

• A.shutting down the database instance that is being upgraded
• B.executing the catctl.pl script to run the upgrade processes in parallel
• C.running the Pre-Upgrade Information Tool
• D.copying the listener.ora file to the new ORACLE_HOME

Comment: *

Name: *

Email: *

Verification: *

Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?

• A.Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
• B.Run the Automatic Workload Repository Monitor (ADDM).
• C.Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
• D.Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

Comment: *

Name: *

Email: *

Verification: *

You install "Oracle Grid Infrastructure for a standalone server" on a host on which the
ORCL1 and ORCL2 databases both have their instances running.
Which two statements are true?

• A.BothORCL1andORCL2are automatically added to the Oracle Restart configuration.
• B.All database listeners running from thedatabase home are automatically added to the
  Oracle Restart configuration.
• C.Thecrsctl start hascommand must be used to start software services for Oracle
  Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server"installation is complete.
• D.Thesrvctl add databasecommand must be used to addORCL1andORCL2to the
  ORACLE Restart configuration.
• E.All databases subsequently created by using the Database Configuration Assistant
  (DBCA) are automatically added to the Oracle Restart configuration.

Comment: *

Name: *

Email: *

Verification: *