Which three are true about Oracle Grid Infrastructure for a Standalone Server?

• A.It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks
• B.It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.
• C.It creates one disk group during installation.
• D.Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner.
• E.It requires Oracle ASMLibto manage Automatic Storage Management (ASM) disks.
• F.It requires the operating system oracle_base environment variable to be predefined before installation.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about PDB archive files?

• A.They contain a PDB manifest file and all the data files in compressed form for a PDB.
• B.They contain all the data files only in compressed form for a PDB.
• C.DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.
• D.They contain a PDB manifest file and all the data files in uncompressed form for a PDB.
• E.They must be created using the DBMS_PDB package.
• F.They contain all the data files only in uncompressed form for a PDB.

Comment: *

Name: *

Email: *

Verification: *

Which three methods can be used for heap table data migration after upgrading a database?
(Choose three.)

• A.using Database Replay
• B.using SQL Developer
• C.using Oracle Data Pump
• D.using operating system file copy utilities
• E.using Database Upgrade Assistant
• F.using the CREATE TABLE AS SELECT SQL statement

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Optimizer Statistics Advisor? (Choose three.)

• A.It can recommend changes to improve the statistics gathering process.
• B.It is part of the DBMS_ADVISOR package.
• C.It runs automatically every night by default.
• D.It always analyzes all schemas in the database.
• E.It is part of the DBMS_STATS package.
• F.It can be run only manually.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about patchsets? (Choose three.)

• A.They are installed via OPatch or OPatchAuto.
• B.They can be applied in a rolling fashion for Clusterware and the databases.
• C.They are only released quarterly.
• D.They can introduce new features.
• E.A base release is not needed to install patchsets.
• F.Installing a patchset is considered an "upgrade".

Comment: *

Name: *

Email: *

Verification: *