Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

• A.By default, AWR snapshots are taken every 60 minutes.
• B.Its collection level is determined by the value of the STATISTICS_LEVELdatabase parameter.
• C.By default, AWR snapshots are retained for 7 days.
• D.The taking of AWR snapshots can be disabled.
• E.AWR data is stored in the SYSTEMtablespace.

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

Comment: *

Name: *

Email: *

Verification: *

Examine these queries and their output:

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true? (Choose two.)

• A.Data file 24 can be recovered while PDB2 is opened.
• B.Data file 24 must be recovered while the CDB is opened.
• C.Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
• D.Data file 24 cannot be recovered while the CDB is opened.
• E.Data file 24 must be recovered while PDB2 is closed.

Comment: *

Name: *

Email: *

Verification: *

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

• A.Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
• B.Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
• C.Re-createthepasswordfileintheOracleDatabase12cformat. Correct
• D.Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
• E.Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle instance recovery? (Choose two.)

• A.Recovery begins from the beginning of the CURRENT redo log group.
• B.Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
• C.Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
• D.Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.
• E.Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
• F.Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

Comment: *

Name: *

Email: *

Verification: *