What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?

• A.Effectively implements role separation
• B.Enables you to take advantage of Oracle Managed Files.
• C.Automatically registers the database with Oracle Restart.
• D.Helps you to easily upgrade the database from a prior release.
• E.Enables the Installation of Grid Infrastructure files on block or raw devices.

Comment: *

Name: *

Email: *

Verification: *

What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated
Maintenance Task?

• A.SQL profile recommendations
• B.statistics recommendations
• C.creation of materialized views to improve query performance
• D.SQL statement restructure recommendations

Comment: *

Name: *

Email: *

Verification: *

The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that:

HRthen opens a second session.
Which two operations wait when executed in HR's second session?

• A.SELECT job FROM employees WHERE job='CLERK' FOR UPDATE OF empno;
• B.SELECT empno,ename FROM employees WHERE job='CLERK';
• C.INSERT INTO employees(empno,ename,job) VALUES (2001,'Harry','CLERK);
• D.INSERT INTO employees(empno,ename) VALUES (1289, 'Dick');
• E.LOCK TABLE employees IN EXCLUSIVE MODE;

Comment: *

Name: *

Email: *

Verification: *

Identify three valid methods of opening, pluggable databases (PDBs).

• A.ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root
• B.ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB
• C.ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed
• D.ALTER DATABASE PDB OPEN issued from the root
• E.ALTER DATABASE OPEN issued from that PDB
• F.ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB
• G.ALTER PLUGGABLE DATABASE OPEN issued from that PDB

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true concerning dropping a pluggable database (PDB)? (Choose two.)

• A.The PDB must be open in read-only mode.
• B.The PDB must be in mount state.
• C.The PDB must be unplugged.
• D.The PDB data files are always removed from disk.
• E.A dropped PDB can never be plugged back into a multitenant container database (CDB).

Comment: *

Name: *

Email: *

Verification: *