Aco 15

Front 1

1. Among the failure events, which is the most serious?
A. The loss of an entire redo log file group but no loss in any other group
B. The loss of one member of each redo log file group
C. The failure of the ARC0 background process
D. The failure of the LGWR background process

Back 1

1. A. Losing an entire redo log file group can result in losing committed transactions that may not yet have been written to the database files. Losing all members of a redo log file group except for one does not affect database operation and does not result in lost data. A message is placed in the alert log file. The failure of LGWR or ARC0 causes an instance failure, but you do not lose any committed transaction data.

Front 2

2. To enable the flashback database option, the database must be in which of the following modes?
A. NOARCHIVELOG mode
B. ARCHIVELOG mode
C. FLASHBACK LOG mode
D. BEGIN BACKUP mode

Back 2

2. B. To enable the flashback database option, the database must be in ARCHIVELOG mode. FLASHBACK LOG mode is not a valid mode of database operation. BEGIN BACKUP mode is used to perform hot backups without using RMAN.

Front 3

3. When the database is in ARCHIVELOG mode, database recovery is possible up to which event or time?
A. The last redo log file switch
B. The last checkpoint position
C. The last commit
D. The last incremental backup using RMAN

Back 3

3. C. In ARCHIVELOG mode, recovering the database is possible up to the last COMMIT statement; in other words, no committed transactions are lost in ARCHIVELOG mode.

Front 4

4. From the following, choose the true statement regarding image copies and backup sets.
A. An image copy stores one data file per image copy, and a backup set can store all data files in a single file.
B. An image copy stores one data file per image copy, and a backup set consists of one file per data file backed up.
C. Both image copies and backup sets use a single file to store all objects to be backed up.
D. A backup set stores each data file in its own backup file, but an image copy places all data files into a single output file.

Back 4

4. A. Image copies are duplicate data and log files in OS format. Backup sets are binary compressed files in Oracle proprietary format. In addition to storing multiple data files in a single output file, backup sets do not contain unused blocks.

Front 5

5. The option on the EM Database Control backup-scheduling options screen that allows you to refresh an image copy on disk with an incremental backup is known as which RMAN feature?
A. Incrementally updated backups
B. Incremental level-zero backups
C. Compressed image-copy refresh
D. Compressed incremental backups

Back 5

5. A. Incrementally updated backups save time during a recovery operation because fewer incremental backups need to be applied to the restored image copy.

Front 6

6. When should the DBA make a trace copy of the control file using ALTER DATABASE BACKUP CONTROLFILE TO TRACE?
A. After every backup
B. After multiplexing the control files
C. Whenever restarting the instance
D. Whenever the physical structure of the database changes

Back 6

6. D. In the rare event that all multiplexed copies of the control file are lost, having a trace copy of the control file reduces the possibility of data loss and reduces downtime during a recovery operation. The preferred and recommended way to back up a control file is to enable control file autobackup using RMAN.

Front 7

7. Which of the following is not a step in configuring your database to archive redo log files?
A. Place the database in ARCHIVELOG mode.
B. Multiplex the online redo log files.
C. Specify a destination for archived redo log files.
D. Specify a naming convention for your archived redo log files.

Back 7

7. B. Although it is recommended that you multiplex your online redo log files, it is not required to enable ARCHIVELOG mode of the database.

Front 8

8. Why are online backups known as inconsistent backups?
A. Because not all control files are synchronized to the same SCN until the database is shut down
B. Because both committed and uncommitted transactions are included in a backup when the database is online
C. Because a database failure while an online backup is in progress can leave the database in an inconsistent state
D. Because online backups make copies of data files while they are not consistent with the control files

Back 8

8. D. During an online backup, even if all data files are backed up at the same time, they are rarely, if ever, in sync with the control file.

Front 9

9. Which parameter is used to specify the archive-log destination?
A. ARCHIVE_LOG_DEST_n
B. LOG_ARCHIVE_DEST_n
C. DB_CREATE_FILE_DEST
D. DB_RECOVERY_FILE_DEST_n

Back 9

9. B. LOG_ARCHIVE_DEST_n specifies the archive-log location. You can configure up to 10 archive-log destinations. LOG_ARCHIVE_DEST_10 is reserved for the flash recovery area, which is specified by the parameter DB_RECOVERY_FILE_DEST.

Front 10

10. Which of the following initialization parameters specifies the location where the control file trace backup is sent?
A. DIAGNOSTIC_DEST
B. BACKGROUND_DUMP_DEST
C. LOG_ARCHIVE_DEST
D. CORE_DUMP_DEST

Back 10

10. A. The trace backup is created in a subdirectory under the location specified by the DIAGNOSTIC_DEST parameter —$DIAGNOSTIC_DEST/diag/<dbname>/<instancename>/trace directory.

Front 11

11. Which of the following pieces of information is not available in the control file?
A. Instance name
B. Database name
C. Tablespace names
D. Log sequence number

Back 11

11. A. The instance name is not in the control file. The control file has information about the physical database structure.

Front 12

12. Which data dictionary view shows that the database is in ARCHIVELOG mode?
A. V$INSTANCE
B. V$LOG
C. V$DATABASE
D. V$THREAD

Back 12

12. C. The V$DATABASE view in the column LOG_MODE shows whether the database is in ARCHIVELOG mode or in NOARCHIVELOG mode.

Front 13

13. Which file records all changes made to the database and is used only when recovering an instance?
A. Archive-log file
B. Redo log file
C. Control file
D. Alert log file

Back 13

13. B. The redo log file records all changes made to the database. The LGWR process writes the redo log buffer entries to the redo log files. These entries are used to roll forward, or to update, the data files during an instance recovery. Archive log files are used for media recovery.

Front 14

14. Which initialization parameter contains the value used as the default for archived log file destination 10? A. LOG_ARCHIVE_DEST
B. STANDBY_ARCHIVE_DEST
C. LOG_ARCHIVE_DUPLEX_DEST
D. DB_RECOVERY_FILE_DEST
E. USE_DB_RECOVERY_FILE_DEST

Back 14

14. D. DB_RECOVERY_FILE_DEST points to the flash recovery area, and this is the default for archived log-file destination number 10.

Front 15

15. Which of the following commands is a key step in multiplexing control files using an spfile?
A.ALTER SYSTEM SET CONTROL_FILES= '/u01/oradata/PRD/cntrl01.ctl', '/u01/oradata/PRD/cntrl02.ctl' SCOPE=SPFILE;
B.ALTER SYSTEM SET CONTROL_FILES= '/u01/oradata/PRD/cntrl01.ctl', '/u01/oradata/PRD/cntrl02.ctl' SCOPE=MEMORY;
C.ALTER SYSTEM SET CONTROL_FILES= '/u01/oradata/PRD/cntrl01.ctl', '/u01/oradata/PRD/cntrl02.ctl' SCOPE=BOTH;
D. The number of control files is fixed when the database is created.

Back 15

15. A. The location of the new control files is not valid until an operating-system copy is made of the current control file to the new location(s) and the instance is restarted. The SCOPE=SPFILE option specifies that the parameter change will not take place until a restart. Specifying either MEMORY or BOTH causes an error, because CONTROL_FILES is not a dynamic parameter.

Front 16

16. Which statement adds a member /logs/redo22.log to redo log file group 2?
A.ALTER DATABASE ADD LOGFILE '/logs/redo22.log' TO GROUP 2;
B.ALTER DATABASE ADD LOGFILE MEMBER '/logs/redo22.log' TO GROUP 2;
C.ALTER DATABASE ADD MEMBER '/logs/redo22.log' TO GROUP 2;
D.ALTER DATABASE ADD LOGFILE '/logs/redo22.log';

Back 16

16. B. When adding log-file members, specify the group number, or specify all the existing group members.


Front 17

17. What is the biggest advantage of having the control files on different disks?
A. Database performance.
B. Guards against failure.
C. Faster archiving.
D. Writes are concurrent, so having control files on different disks speeds up control file writes.

Back 17

17. B. Having the control files on different disks ensures that even if you lose one disk, you lose only one control file. If you lose one of the control
files, you can shut down the database and copy a control file, or you can change the CONTROL_FILES parameter and restart the database.

Front 18

18. To place the database into ARCHIVELOG mode, in which state must you start the database?
A. MOUNT
B. NOMOUNT
C. OPEN
D. SHUTDOWN
E. Any of the above

Back 18

18. A. To put the database into ARCHIVELOG mode, the database must be in the MOUNT state; the control files and all data files that are not offline must be available to change the database to ARCHIVELOG mode.

Front 19

19. Which of the following commands places the database in ARCHIVELOG mode?
A.ALTER SYSTEM ARCHIVELOG;
B.ALTER DATABASE ARCHIVELOG;
C.ALTER SYSTEM SET ARCHIVELOG=TRUE;
D.ALTER DATABASE ENABLE ARCHIVELOG MODE;
E.ALTER DATABASE ARCHIVELOG MODE;

Back 19

19. B. You use the ALTER DATABASE ARCHIVELOG command while the database is in the MOUNT state to enable archiving of online redo log files.

Front 20

20. Which of the following substitution-variable formats are always required for specifying the names of the archived redo log files? (Choose all that apply.)
A.%d
B. %s
C. %r
D. %t

Back 20

20. B, C, D. The substitution variable %d, which represents the database ID, is required only if multiple databases share the same archive-log destination