Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

• A.The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
• B.Existing Oracle Database instances must be shut down before starting the upgrade.
• C.Only the grid user can perform the upgrade.
• D.An existing Oracle base can be used.
• E.A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
• F.The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.

Comment: *

Name: *

Email: *

Verification: *

Which three are true in Oracle 19c and later releases? (Choose three.)

• A.If the password file location changes, then the new location is used automatically by the Oracle Server.
• B.Schema Only accounts can be granted administrator privileges.
• C.All the Oracle-supplied accounts are Schema Only accounts.
• D.Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
• E.Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
• F.Unified Auditing can be configured to audit only events that are issued directly by an audited user.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about patchsets?

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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about gathering optimizer statistics? (Choose two.)

• A.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
• B.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
• C.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
• D.System statistics can be gathered only while connected to CDB$ROOT.
• E.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about Oracle Grid Infrastructure for a Standalone Server?

• A.The CSS daemon runs from the Grid Infrastructure home.
• B.It can manage database resources on the server where it is installed or on a different server.
• C.It requires Oracle Automatic Storage Management (ASM) components to be installed separately.
• D.It must be installed before the Oracle database software is installed.
• E.It supports volume management, file system, and automatic restart capabilities.

Comment: *

Name: *

Email: *

Verification: *