In which three situations must you use a recovery catalog? (Choose three.) A. when you want to store RMAN global scripts that can be used across multiple databases B. when you want to list data files that were in a…
Examine the query and its output executed in an RDBMS instance: Which three statements are true about the users (other than SYS) in the output? (Choose three.) A. The C##D_ADMIN user can perform backup and recovery operations for Automatic Storage…
Examine the output from v$DIAG_INFO: Which statement is true about the Automatic Diagnostic Repository (ADR)? A. The SQL trace file for a session is stored in Diag Trace B. The text alert log is available in Diag Trace C. The…
You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command…
Which three types of backups can be performed for a database running in NOARCHIVELOG mode? (Choose three.) A. backup of only the used blocks in a critical tablespace (SYSTEM or SYSAUX) while the database is open B. backup of noncritical…
You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command. What is the outcome? A. The PDB is closed and left in the…
Examine the RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which statement is true about the DUPLICATE command? A. It…
You are performing regular backups of your production database by using a recovery catalog. You add two new tablespaces to your production database after performing a backup. They must be included in future backups. Which action should you perform? A.…
Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incremental every six hours. After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT state…
Examine this command: SQL>ALTER SYSTEM SET db_securefile = ‘IGNORE’; Which statement is true? A. It forces SecureFiles to be created even if the BASICFILE option is specified B. It forces SecureFiles to be created using default values and ignores any…