Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to ‘/u01/oracle/db01’. The parameters, DB_CREATE_ONLINE_LOG_DEST_n and DB_RECOVERY_FILE_DEST, are not specified. Which four are stored in the location specified by DB-CREATE_FILE_DEST? (Choose four.) A. RMAN backups B. data files C.…
Which four are true about the tools used to administer Oracle databases? (Choose four.) A. SQL *Plus can be used to create databases B. DBCA can be used to upgrade databases C. RMAN can be used to start up Oracle…
Examine these components: 1.Execution plan for a non-embedded SQL statement 2.Local, global, and package variables for a session 3.Execution plan for a SQL statement contained in a PL/SQL program unit 4.Results of executed queries and query fragments 5.PL/SQL function result…
Which three are true about the Automatic Workload Repository (AWR)? (Choose three.) A. AWR data is stored in the SYSTEM tablespace B. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter C. It is the foundation…
You have decided to implement the principle of least privilege and separation of duties. Which two actions must you take? (Choose two.) A. Assign different O/S groups to the OSOPER and OSDBA credentials B. Grant SYSOPER to application schema owners…
Which two are true about the Fast Recovery Area (FRA)? (Choose two.) A. Space management in the FRA is controlled by the database backup retention policy B. It must reside on the same file system as the database data files…
Which two affect the time taken for instance recovery? (Choose two.) A. size of archivelogs B. size of existing RMAN backupsets C. UNDO_RETENTION value D. size of UNDO tablespace E. FAST_START_MTTR_TARGET value F. size of redo logs
Where is backup metadata stored for use by Recovery Manager (RMAN)? A. in the SYSTEM tablespace B. in the control file C. in the SPFILE D. in the SYSAUX tablespace E. in the diagnostic destination files
Table EMP resides in the USERS tablespace. Examine this command: SQL> DROP TABLE emp PURGE; Which two methods would you use to recover EMP? (Choose two.) A. Flashback Transaction Backout B. re-creating the table and reinserting the rows C. Flashback…
You want to use the ALTER SYSTEM statement with SCOPE=MEMORY to change an initialization parameter value. Which is true? A. The change occurs immediately in memory for dynamic parameters but it is not persistent after instance restart B. It can…