You are administering a database stored in Automatic Storage Management (ASM).
You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data?

• A. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
• B. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
• C. Use the MKDG command to restore the disk group with the same configuration as the backed- up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
• D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
• E. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
• F. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.

You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns?

• A. The index remains invisible.
• B. The index is updated by the DML on the table.
• C. The index automatically becomes visible in order to have it updated by DML on the table.
• D. The index is not updated by the DML statements on the indexed table.
• E. The index becomes unusable but the table is updated by the DML.

You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?

• A. The operating system group that is specified must have permission to write to the inventory directory.
• B. The installation is being performed by the root user.
• C. The operating system group that is specified should have the root user as its member.
• D. The ORACLE_BASE base parameter is not set.

Which two statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled in UNIX?

• A. Each Oracle process runs an SCMN thread.
• B. Each multithreaded Oracle process has an SCMN thread.
• C. Thread creation must be routed through a dispatcher process.
• D. The local listener may pass the request to an existing process which in turn will create a thread.

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1failure group becomes unavailable due to error or for maintenance?

• A. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
• B. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
• C. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
• D. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
• E. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.