Which three factors influence the optimizer's choice of an execution plan? (Choose three.)

• A.operating system (OS) statistics
• B.cardinality estimates
• C.the optimizer_mode initialization parameter
• D.object statistics in the data dictionary
• E.fixed baselines

Comment: *

Name: *

Email: *

Verification: *

You are managing an Oracle Database 12c database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.
Which three statements are true about these backups? (Choose three.)

• A.The backups would be consistent.
• B.The backups would be possible only if the database is running in ARCHIVELOGmode.
• C.The backups need to be restored and the database has to be recovered in case of a media failure.
• D.The backups would be inconsistent.
• E.The backups by default consist of all the data blocks within the chosen files or the full database.

Comment: *

Name: *

Email: *

Verification: *

The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and
executes commands as follows:
SQL> INSERT INTO cust VALUES(101, 'JACK');
1 row created.
SQL> INSERT INTO cust VALUES(102, 'SMITH');
1 row created.
As a DBA, you execute the following command from another session:
ALTER TABLESPACE sales READ ONLY;
Which statement is true regarding the effect of this command on the transaction in Scott's session?

• A.The command fails as a transaction is still pending.
• B.The transaction in Scott's session is rolled back and the tablespace becomes readonly.
• C.The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of
  the current transaction.
• D.The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the
  tablespace is placed in readonly mode.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)

• A.The PDB must be open in read only mode.
• B.The PDB must be dosed.
• C.The unplugged PDB becomes a non-CDB.
• D.The unplugged PDB can be plugged into the same multitenant container database (CDB)
• E.The unplugged PDB can be plugged into another CDB.
• F.The PDB data files are automatically removed from disk.

Comment: *

Name: *

Email: *

Verification: *

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

• A.SMON
• B.MMNL
• C.MMAN
• D.MMON
• E.PMON

Comment: *

Name: *

Email: *

Verification: *