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

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

Comment: *

Name: *

Email: *

Verification: *

Your container database, CDB1, is in local undo mode.
You successfully execute this command while connected to CDB1:
CREATE PLUGGABLE DATABASE pdb1
ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT)
CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1';
Which three are true about PDB1? (Choose three.)

• A.It has no local users.
• B.It is in mount state after creation.
• C.It has the same common users defined as does CDB1.
• D.It has the same number of roles as CDB1.
• E.Service PDB1 is created for remote logins to PDB1.
• F.It has only local roles.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases?

• A.A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
• B.A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
• C.A PDB snapshot can be a full copy of a source PDB.
• D.A PDB snapshot can be a sparse copy of a source PDB.
• E.A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
• F.A PDB snapshot depends on an existing storage snapshot of the source PDB.
• G.A snapshot copy PDB can be a full copy of a source PDB.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about RMAN duplexed backup sets? (Choose two.)

• A.They must be written to media.
• B.They can be written only to disk.
• C.They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.
• D.They can be written to media.
• E.They can be created only by using the COPIES option of a BACKUP command.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

• A.FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
• B.FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
• C.FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
• D.FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
• E.FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
• F.FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

Comment: *

Name: *

Email: *

Verification: *