Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.) A. It can assist the DBA in diagnosing database instance startup failures B. Its findings are accessible only by using Oracle Enterprise Manager C. It provides recommendations…
Which three can be used to schedule automated backups of the database? (Choose three.) A. DBMS_SCHEDULER B. RMAN C. DBMS_BACKUP_RESTORE D. a cron job E. expdp F. Enterprise Manager Database Control
Which two statements are true about tablespaces? (Choose two.) A. A database instance stores undo data in the SYSTEM tablespace if no undo tablespace exists B. A database instance hangs if the SYSAUX tablespace becomes unavailable C. A database with…
Which two are true about data dictionary views? (Choose two.) A. DBA prefixed views are accessible when a database is in mount state B. A user can query the DBA prefixed with DBA or ALL or USER C. All data…
Which is true about the Automatic Diagnostic Repository (ADR)? A. It only contains the alert log and trace files for background processes B. Its location is always set by the ORACLE_BASE variable C. It is used only if the DISGNOSTIC_DEST…
Which action is automatically performed as part of the Incident Packaging Service in Enterprise Manager Support Workbench? A. invoking the Data Recovery Advisor and SQL Repair Advisor B. gathering metadata from the Automatic Diagnostic Repository (ADR) C. Creating a service…
Which two are true about space management in tablespaces? (Choose two.) A. Extent allocation must be specified as automatic for automatic segment space management (ASSM) tablespaces B. Free lists are used for managing free space for segments in locally managed…
Examine these commands and their output: A power failure occurs. The instance is restarted and this query is executed. SQL> SELECT ename FROM emp; What is the outcome? A. No rows are returned B. Only Adam and Alan are displayed…
Which are three of the various resources that must be accessible to keep a database open? (Choose three.) A. SYSTEM tablespace B. spfile C. all members of a redo log group D. SYSAUX tablespace E. control file
Your database is open in ARCHIVELOG mode. LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and it is 100% full when a log switch takes place. What is the outcome? A. The archivelog entries are made in the diagnostic destination…