DBSkool Header Image Background

Category: DBA_MCQPage 1 of 4

Export and Import Utilities

1. What is true regarding direct-load insert? A. A direct-load insert can be invoked by suing the APPEND hint. B. Inserting using the NOLOGGING option is the default…

RMAN Maintenance

1. Which RMAN command do you use to verify that the RMAN repository information is synchronized with the actual files that exist on disk? A. LIST B. CHANGE…

RMAN Incomplete Recovery

1. When performing incomplete recovery using UNTIL SEQUENCE with RMAN, which two pieces of information are required? (Choose two) A. Thread number. B. Log Sequence number. C. Control…

User-Managed Incomplete Recovery

1. When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform? A. Until SCN B. Until time…

RMAN Complete Recovery

1. Your database is running in NOARCHIVELOG mode. Every night there is a backup taken using RMAN. During your startup this morning you received en error regarding DISK…

User-Managed Complete Recovery

1. You discover that a disk failure occurred on DISK3 where the data file belonging to the USER_DATA tablespace is stored. The database is currently open and you…

RMAN Backup

1. Which phrase best describes RMAN multiplexed backup sets? A. Stripes a single backup set across multiple channels. B. Identical copies of backup pieces within a backup set….

User-Managed Backup

1. You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup? (Choose three) A. ABORT…

Oracle Recovery Manager Overview and Configuration

1. Consider this RMAN command: RMAN> CONFIGURE RETENTION POLICY CLEAR; What is the effect of this command? A. Backups will never expire. B. It removes any retention policy….

Configuring the Database Archiving Mode

1. Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three) A. SYNC or ASYNC to identify…