摘要: What privileges must be granted to allow an account to create the recovery catalog? (Choose all thatapply.)A. RECOVERY_CATALOG_OWNERB. DBAC. RESOURCED 阅读全文
posted @ 2017-11-09 18:28 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0)
摘要: What is the purpose of the RMAN recovery catalog? (Choose all that apply.)A. It must be used because all RMAN-related backup and recovery metadata inf 阅读全文
posted @ 2017-11-09 18:24 巴啦啦大魔王 阅读(87) 评论(0) 推荐(0)
摘要: You issue the following command:RMAN>CONFIGURE BACKUP OPTIMIZATION ON;What is the result of this command on your backups?A. An incremental backup stra 阅读全文
posted @ 2017-11-09 18:16 巴啦啦大魔王 阅读(105) 评论(0) 推荐(0)
摘要: Which command is used to configure RMAN to perform a compressed backup for every backupexecuted?A. BACKUP AS COMPRESSED BACKUPSET DATABASEB. BACKUP AS 阅读全文
posted @ 2017-11-09 18:12 巴啦啦大魔王 阅读(95) 评论(0) 推荐(0)
摘要: Which of the following statements are true about the BACKUP command? (Choose all that apply.)A. The BACKUP command can not be used to make image copie 阅读全文
posted @ 2017-11-09 18:06 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
摘要: Given the following steps, which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file autobackups 阅读全文
posted @ 2017-11-09 18:04 巴啦啦大魔王 阅读(92) 评论(0) 推荐(0)
摘要: The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value?(Choose all that apply.)A. The initialization parameter should 阅读全文
posted @ 2017-11-09 17:59 巴啦啦大魔王 阅读(117) 评论(0) 推荐(0)
摘要: What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?A. CONFIGURE DEFAULT DEVICE TYPE TO TA 阅读全文
posted @ 2017-11-09 17:55 巴啦啦大魔王 阅读(90) 评论(0) 推荐(0)
摘要: What feature comes into play to help ensure the completion of the backup should one of threebackup devices fail during a backup that is using three di 阅读全文
posted @ 2017-11-09 17:49 巴啦啦大魔王 阅读(171) 评论(0) 推荐(0)
摘要: Which dynamic view displays the status of block-change tracking?A. V$BLOCK_CHANGEB. V$BLOCK_CHANGE_TRACKINGC. V$BLOCKCHANGED. V$BLOCK_TRACKING The V$B 阅读全文
posted @ 2017-11-09 17:45 巴啦啦大魔王 阅读(152) 评论(0) 推荐(0)
摘要: Which of the following most closely represents an image copy?A. Unix cp command of a fileB. Bit-by-bit copy of a fileC. Windows COPY command of a file 阅读全文
posted @ 2017-11-09 17:42 巴啦啦大魔王 阅读(69) 评论(0) 推荐(0)
摘要: Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?A. shutdown immediate from R 阅读全文
posted @ 2017-11-09 17:40 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)
摘要: Which backup option defines a user-defined name for a backup?A. FORMATB. NAMEC. TAGD. FORMAT U% The TAG is used to name a backup with a user-defined c 阅读全文
posted @ 2017-11-09 17:19 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
摘要: Which type of backup must be performed first with an incremental backup?A. Level 1B. Level 0C. Level 2D. Level 3 A level-0 backup copies all the used 阅读全文
posted @ 2017-11-09 17:13 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0)
摘要: Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?A. Differential incremental backupB. D 阅读全文
posted @ 2017-11-09 17:11 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0)
摘要: Which of the following best describes a full backup?A. All datafiles of a databaseB. All datafiles, archive logs, and control filesC. All datafiles an 阅读全文
posted @ 2017-11-09 17:10 巴啦啦大魔王 阅读(94) 评论(0) 推荐(0)
摘要: Which is the correct command to back up the database, back up the archived redo logs, and thenremove the backed-up archived redo logs?A. backup databa 阅读全文
posted @ 2017-11-09 17:05 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
摘要: Which command creates an image copy?A. backup as copyB. backup copyC. copy as backupD. copy back The backup as copy command is used to create an image 阅读全文
posted @ 2017-11-09 17:01 巴啦啦大魔王 阅读(77) 评论(0) 推荐(0)
摘要: Compressed backups work with which of the following commands?A. copy as backupB. backup as copyC. backupD. copy Compressed backups work only wtih back 阅读全文
posted @ 2017-11-09 16:58 巴啦啦大魔王 阅读(142) 评论(0) 推荐(0)
摘要: Consider the following command:Backup database plus archivelog delete input;How many backup sets would be created by this command if the following wer 阅读全文
posted @ 2017-11-09 16:53 巴啦啦大魔王 阅读(133) 评论(0) 推荐(0)
摘要: What type of backup is stored in a proprietary RMAN format?A. Backup setB. Image copyC. Backup sectionD. Backup group The backup set is stored in a pr 阅读全文
posted @ 2017-11-09 16:46 巴啦啦大魔王 阅读(109) 评论(0) 推荐(0)
摘要: How is block-change tracking enabled?A. With alter database enable block change trackingB. With alter system enable block change trackingC. With an in 阅读全文
posted @ 2017-11-09 16:38 巴啦啦大魔王 阅读(105) 评论(0) 推荐(0)
摘要: During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you 阅读全文
posted @ 2017-11-09 16:31 巴啦啦大魔王 阅读(133) 评论(0) 推荐(0)
摘要: You are trying to recover your database. During the recovery process, you receive the following error:ORA-00279: change 5033391 generated at 08/17/200 阅读全文
posted @ 2017-11-09 16:27 巴啦啦大魔王 阅读(143) 评论(0) 推荐(0)
摘要: You have lost datafile 4 from your database.Which is typically the fastest way to restore your database?A. Restore and recover the datafile. B. Restor 阅读全文
posted @ 2017-11-09 16:21 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0)
摘要: What does the SCN represent?A. The system change number, which is a point in time relative to transactions within a given database.B. A number that re 阅读全文
posted @ 2017-11-09 16:18 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)
摘要: You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart the database and clear the online redo log 阅读全文
posted @ 2017-11-09 16:14 巴啦啦大魔王 阅读(190) 评论(0) 推荐(0)
摘要: Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to theSYSTEM tablespace and two are assigned to the USERS tables 阅读全文
posted @ 2017-11-09 16:05 巴啦啦大魔王 阅读(137) 评论(0) 推荐(0)
摘要: What methods are available to recover lost control files? (Choose all that apply.)A. Backup control file.B. Emergency control file.C. The create contr 阅读全文
posted @ 2017-11-09 16:03 巴啦啦大魔王 阅读(127) 评论(0) 推荐(0)
摘要: Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is 阅读全文
posted @ 2017-11-09 15:59 巴啦啦大魔王 阅读(159) 评论(0) 推荐(0)
摘要: You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace com 阅读全文
posted @ 2017-11-09 15:55 巴啦啦大魔王 阅读(115) 评论(0) 推荐(0)
摘要: A user sends you an email with the following error message: create table idtable(id number) *ERROR at line 1: ORA- 01110: data file 4: ,,/oracle01/ora 阅读全文
posted @ 2017-11-09 09:13 巴啦啦大魔王 阅读(111) 评论(0) 推荐(0)