Which two are true about the SQL Tuning Advisor?

• A.It can recommend semantic changes to SQL statements.
• B.It prevents performance regressions for SQL statements when changes are made.
• C.It only recommends syntactic changes to SQL statements.
• D.It checks each query being analyzed for missing or stale statistics.
• E.It considers all SQL statements being analyzed by the advisor task as a group.

Comment: *

Name: *

Email: *

Verification: *

Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1.
How do you achieve this?

• A.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.
• B.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.
• C.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.
• D.This cannot be done due to the lack of a clean restore point.
• E.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.

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

Comment: *

Name: *

Email: *

Verification: *

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

• A.Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIV
• B.Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
• 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 last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
• 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 beginning of the CURRENT redo log group.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?

• A.automatically dropping the database link to the remote database if it already exists
• B.creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
• C.opening the cloned PDB
• D.creating a new empty PDB in the local database from PDB$SEED
• E.creating a database link from CDB$ROOT in the remote database to the PDB in the local database
• F.creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database
• G.creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned

Comment: *

Name: *

Email: *

Verification: *