A database is configured in ARCHIVELOG mode.
A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred.
In which two scenarios is incomplete recovery required? (Choose two.)

• A.after losing an UNDO tablespace that is in use
• B.after losing all copies of the control file
• C.after losing all members of an INACTIVE online redo log group
• D.after losing a SYSAUX tablespace data file
• E.after losing all members of the CURRENT online redo log group

Comment: *

Name: *

Email: *

Verification: *

You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server.
Examine this command and its outcome:

Which two are true? (Choose two.)

• A.The user account, oracle, and group, oinstall, can be used for all Oracle software installations.
• B.oracle must be the owner of every Oracle Database installation.
• C.oracle will be granted the SYSASM privilege when installing the Oracle Database software.
• D.oracle will be an owner of the Oracle Inventory.
• E.oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.

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: *

Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c?
(Choose two.)

• A.It can be used to provision middleware.
• B.It is an Oracle Database service
• C.It cannot be used to upgrade Oracle Database homes.
• D.It can be used to provision applications.
• E.It can be used to patch Grid Infrastructure homes containing Oracle Restart.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about an application seed pluggable database (PDB)?

• A.A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
• B.It is automatically synchronized with its application root PDB when an application is installed.
• C.It cannot be dropped from its application container.
• D.A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.
• E.It cannot be added to an application container after the application container has already been created.
• F.It is not required in an application container.
• G.It Is automatically synchronized with its application root PDB when an application is upgraded.

Comment: *

Name: *

Email: *

Verification: *