Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx- preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)

• A.creating the oracle OS user
• B.creating the OSDBA (dba) group
• C.configuring the OS for Oracle Automatic Storage Management shared storage access
• D.creating thte oraInventory (oinstall) group
• E.creating the grid OS user
• F.performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met

Comment: *

Name: *

Email: *

Verification: *

A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The local_undo_enabled database property is set to false in the CDB.
Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the backup database command while connected to CDB$ROOT.
Which three are true?

• A.Data file 24 can be restored and recovered while connected to CDB$ROOT.
• B.Data file 24 can be recovered while connected to CDB$ROOT.
• C.Data file 24 can be restored only while connected to CDB$ROOT.
• D.Data file 24 can be recovered while connected to PDB2.
• E.Data file 24 can be restored only while connected to PDB2.
• F.Data file 24 can be recovered only while connected to PDB2.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about server-generated alerts? (Choose two.)

• A.Stateful alerts must be created by a DBA after resolving the problem.
• B.Stateless alerts can be purged manually from the alert history.
• C.Stateless alerts can be cleared manually.
• D.Stateful alerts are purged automatically from the alert history.
• E.Stateless alerts are automatically cleared.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three actions will add a resource to an Oracle Restart configuration?

• A.creating a database service using Oracle Database Configuration Assistant (DBCA)
• B.creating a database service using DBMS_SERVICE.CREATE_SERVICE
• C.creating an Oracle Database service by modifying the SERVICE_NAMES parameter
• D.creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)
• E.creating a disk group using the CREATE DISKGROUP SQL statement
• F.creating a database using the CREATE DATABASE SQL statement

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:

While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted.
To recover from this critical failure, you execute these commands:

What will be the outcome?

• A.It will fail because there is no autobackup of the controlfiles.
• B.It will create '$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'
• C.It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.
• D.It will create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.
• E.It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'

Comment: *

Name: *

Email: *

Verification: *