Choose three. 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?

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

Comment: *

Name: *

Email: *

Verification: *

You want to transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have the same endian format.
Examine this list of steps:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an RMAN command that includes the DATAPUMP clause.
4. Copy the cross-platform backup sets to the destination system.
5. Copy the Data Pump dump set from the source to the destination system.
6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?

• A.1, 2, 3, 4, 5, 6, 7, 8
• B.2, 3, 4, 5, 6, 7
• C.1, 3, 4, 6, 8
• D.3, 4, 6

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about various Oracle security and auditing capabilities?

• A.Application-common TSDP policies are always container specific.
• B.Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
• C.Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
• D.Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch begin-end block.
• E.Unified auditing can be automatically synchronized to all application PDBs in an application container.

Comment: *

Name: *

Email: *

Verification: *