Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
3. PDB1 and PDB2 are open in read write mode.
You execute these commands successfully:

Which two are true?

• A.CDB1 is shut down.
• B.Uncommitted transactions in CDB1 and pdbi have been rolled back.
• C.PDB1 is closed.
• D.CDB1 is in mount state
• E.Uncommitted transactions in PDB1 have been rolled back.

Comment: *

Name: *

Email: *

Verification: *

Which three methods can be used for heap table data migration after upgrading a database?

• A.using the create table AS select SQL statement
• B.using Database Upgrade Assistant
• C.using operating system file copy utilities
• D.using Database Replay
• E.using Oracle Data Pump
• F.using SQL Developer

Comment: *

Name: *

Email: *

Verification: *

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

• A.A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
• B.The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
• C.An existing Oracle base can be used.
• D.The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
• E.Existing Oracle Database instances must be shut down before starting the upgrade.
• F.Only the griduser can perform the upgrade.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
3. PDB1 and PDB2 are OPEN in READ WRITE mode.
You execute these commands successfully: Which two are true? (Choose two.)

• A.Uncommitted transactions in PDB1 have been rolled back.
• B.CDB1 is in MOUNT state
• C.CDB1 is shut down.
• D.Uncommitted transactions in CDB1 and PDB1 have been rolled back.
• E.PDB1 is closed.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

• A.By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
• B.The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
• C.The Oracle Grid Infrastructure installation must be owned by the grid user.
• D.The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
• E.The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
• F.The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.

Comment: *

Name: *

Email: *

Verification: *