Question 41
One of your databases is in ARRCHIVELOG mode.
You back up the database by using RMAN with a recovery catalog.
One data file and all the control files are corrupt due to corruption in the storage array.
Examine this list of possible actions to recover the database:
1. Restore the control files by using the RESTORE CONTROLFILE command.
2. Mount the database.
3. Restore the data files by using the RESTORE DATABASE command.
4. Open the database with the RESETLOGS option.
5. Recover the data files by using the RECOVER USING BACKUP CONTROLFILE command.
6. Start the target database instance in NOMOUNT state.
7. Connect to the target database and the recovery catalog database instance.
8. Restore the SPFILE by using the RESTORE SPFILE command
9. Restore the corrupt data file.
10. Recover the restored data file.
Identify the minimum required steps in the correct order.
You back up the database by using RMAN with a recovery catalog.
One data file and all the control files are corrupt due to corruption in the storage array.
Examine this list of possible actions to recover the database:
1. Restore the control files by using the RESTORE CONTROLFILE command.
2. Mount the database.
3. Restore the data files by using the RESTORE DATABASE command.
4. Open the database with the RESETLOGS option.
5. Recover the data files by using the RECOVER USING BACKUP CONTROLFILE command.
6. Start the target database instance in NOMOUNT state.
7. Connect to the target database and the recovery catalog database instance.
8. Restore the SPFILE by using the RESTORE SPFILE command
9. Restore the corrupt data file.
10. Recover the restored data file.
Identify the minimum required steps in the correct order.
Question 42
Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):

Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?

Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?
Question 43
Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.
What must you do to make the database operational in OUSERVER1?
What must you do to make the database operational in OUSERVER1?
Question 44
The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to
/u01/app/oracle/product/12.1.0/db 1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR).
Examine the initialization parameters set in your database.
NAME TYPE VALUE
---------------- ------------------- -------------------
audit_file_dest string /u01/app/oracle/admin/eml2rep/adump
background_dump_dest string
core_dump_dest string
db_create_file_dest string
db_recovery_file_dest string /u01/app/oracle/fast_recovery_area
diagnostic_dest string
What is the location of the ADR base?
/u01/app/oracle/product/12.1.0/db 1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR).
Examine the initialization parameters set in your database.
NAME TYPE VALUE
---------------- ------------------- -------------------
audit_file_dest string /u01/app/oracle/admin/eml2rep/adump
background_dump_dest string
core_dump_dest string
db_create_file_dest string
db_recovery_file_dest string /u01/app/oracle/fast_recovery_area
diagnostic_dest string
What is the location of the ADR base?
Question 45
In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?