Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle container database from an older release. 2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1. A priority list UpgrdList has these entries: 1, pdb2 2, pdb1, pdb3 You execute this command: $ /u01/app/oracle/product/18.1.0/ db_1/rdbms/admin/dbupgrade -L UpgrdList In which order will the upgrade occur?

• A.CDB$ROOT, PDB1, PDB2, PDB3, and PDB4
• B.CDB$ROOT, PDB2, PDB1, and PDB3
• C.CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4
• D.CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3
• E.CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4

Comment: *

Name: *

Email: *

Verification: *

Examine the query and its output executed In an RDBMS Instance: Which three statements are true about the users (other than sys) in the output?

• A.The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
• B.The C # # A_ADMIN user can perform wallet operations.
• C.The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
• D.The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
• E.TheC# # B_ADMIN user can perform all back up and recovery operation susing RMAN only.

Comment: *

Name: *

Email: *

Verification: *

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command: SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement is true?

• A.It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.
• B.It fails because the command does notspecify when the unified audit policy should be enforced.
• C.It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.
• D.It fails because system privileges cannot be granted with roles in the same audit policy.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about using Database Resource Manager in an Oracle multitenant environment?
(Choose three.)

• A.A PDB-level resource plan can limit session PGA memory.
• B.PDB-level resource plans can limit uncommitted UNDO per consumer group.
• C.A CDB-level resource plan can limit session CPU utilization.
• D.A CDB-level resource plan is mandatory when using PDB-level resource plans.
• E.A CDB-level resource plan can limit PDB CPU utilization.
• F.A CDB-level resource plan can limit PDB UNDO use.

Comment: *

Name: *

Email: *

Verification: *

choose one .Examine the RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which statement is true about the DUPLICATE command?

• A.It succeeds and creates multisection backup sets that are used for active database duplication.
• B.It fails because there is no connection to a recovery catalog.
• C.It fails because no parallel channels are allocated for the auxiliary database.
• D.It succeeds only if the target database is in MOUNT state.

Comment: *

Name: *

Email: *

Verification: *