Free Oracle 1Z0-045 Exam Dumps Questions & Answers

You created a database (using Database Configuration Assistant [DBCA]) by using one of the default templates. The default permanent tablespace for the non-system users, excluding DBSNMP and OUTLN users, will be set to _____.

• A.  USERS
• B.  SYSAUX
• C.  SYSTEM
• D.  EXAMPLE

Which four statements regarding the block change track file are correct? (Choose four.)

• A.  The Oracle database records block change information in this file by default.
• B.  The location of this file must be different from that of the database files.
• C.  The changed blocks are tracked in this file as redo is generated.
• D.  The maintenance of this file is fully automatic.
• E.  The V$BLOCK_CHANGE_TRACKING view contains the name and location of this file.
• F.  The minimum size of this file is 10 M

Which parameter avoids the overwriting of archived redo log files when you recover the database with the RESETLOGS option?

• A.  LOG_ARCHIVE_LOCAL_FIRST
• B.  LOG_ARCHIVE_TRACE
• C.  LOG_ARCHIVE_DEST_10
• D.  LOG_ARCHIVE_FORMAT
• E.  LOG_ARCHIVE_CONFIG
• F.  LOG_ARCHIVE_DEST

Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically, and to perform a switch to a low priority consumer group before they are initiated? (Choose three.)

• A.  SWITCH_ESTIMATE
• B.  SWITCH_TIME
• C.  SWITCH_GROUP
• D.  MAX_SESS_POOL

How frequently does the Automatic Database Diagnostic Monitor (ADDM) analysis run by default?

• A.  every 15 minutes
• B.  every 45 minutes
• C.  every 60 minutes
• D.  every 30 minutes
• E.  each time astatspack snapshot is taken