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

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

Comment: *

Name: *

Email: *

Verification: *

A database is configured in ARCHIVELOG mode.
Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred.
In which two scenarios is complete recovery possible? (Choose two.)

• A.after losing an archived log from after the most recent backup
• B.after losing the SYSTEM tablespace
• C.after losing all copies of the control file
• D.when any archived log from, before, or after the most recent backup is corrupt.
• E.after losing an archived log from before the most recent backup

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2. ORCL uses disk group +FRA for the Fast Recovery Area.
3. LISTENER is the listener for ORCL.
4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5. All components are currently shut down.
You execute this command:

What is the outcome?

• A.Only the ORCL database and the ASM instances are started.
• B.Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
• C.Only the ORCL database instance is started.
• D.The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.
• E.Only the ORCL database instance and the +DATA and +FRA disk groups are started.

Comment: *

Name: *

Email: *

Verification: *

Which four are true about RMAN backup sets?

• A.Blocks from multiple data files can be contained in one backup piece.
• B.A data file can be split into multiple sections stored in different backup pieces in the same backup set.
• C.A data file can be split into multiple sections stored in different backup sets.
• D.A backup piece can belong to only one backup set.
• E.A backup set can contain only one backup piece.
• F.Blocks from multiple data files can be contained in one backup set.
• G.A backup set must be written to disk.
• H.A backup set must be written to media.

Comment: *

Name: *

Email: *

Verification: *

Choose three. You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB. Which three methods can you use?

• A.cloning the non-CDB as a PDB
• B.Data Pump full database export and import
• C.Data Pump full transportable database
• D.replication using GoldenGate
• E.Data Pump transportable tablespaces
• F.the DBMS_PDB package

Comment: *

Name: *

Email: *

Verification: *