摘要：
If a backup is expired, which of the following is true?A. It can never be used for a restore/recover operation.B. Oracle will remove the backup set pi 阅读全文
posted @ 2017-11-10 18:31
巴啦啦大魔王
阅读(104)
评论(0)
推荐(0)
摘要：
What information does the report schema command not provide? (Choose all that apply.)A. Size of the datafiles B. Size of the tempfilesC. Date of last 阅读全文
posted @ 2017-11-10 18:26
巴啦啦大魔王
阅读(57)
评论(0)
推荐(0)
摘要：
Why would you execute the report obsolete command?A. To list all backups that were no longer available for restore operationsB. To list all backups th 阅读全文
posted @ 2017-11-10 18:22
巴啦啦大魔王
阅读(88)
评论(0)
推荐(0)
摘要：
What is the result of this command? RMAN> Report need backup days 3;A. Lists all datafiles created in the last three days that are not backed up.B. Li 阅读全文
posted @ 2017-11-10 18:19
巴啦啦大魔王
阅读(72)
评论(0)
推荐(0)
摘要：
What does the minimize load database parameter mean when backing up a database?A. RMAN will attempt to make the backup run as fast as possible without 阅读全文
posted @ 2017-11-10 18:15
巴啦啦大魔王
阅读(94)
评论(0)
推荐(0)
摘要：
What does the output on this report indicate? RMAN> report need backup;RMAN retention policy will be applied to the commandRMAN retention policy is se 阅读全文
posted @ 2017-11-10 18:09
巴啦啦大魔王
阅读(72)
评论(0)
推荐(0)
摘要：
What is the impact of the results of the output of the following command?RMAN> report unrecoverable database;Report of files that need backup due to u 阅读全文
posted @ 2017-11-10 18:05
巴啦啦大魔王
阅读(91)
评论(0)
推荐(0)
摘要：
What view might you use to try to determine how long a particular backup will take?A. V$SESSION_EVENTB. V$SESSIONC. V$WAITSD. V$WAITSTATE. V$SESSION_L 阅读全文
posted @ 2017-11-10 17:59
巴啦啦大魔王
阅读(75)
评论(0)
推荐(0)
摘要：
In what view are you likely to see the following output?SID SERIAL# EVENT SECONDS_IN_WAIT121 269 RMAN backup & recovery I/O 2129 415 SQL*Net message f 阅读全文
posted @ 2017-11-10 17:57
巴啦啦大魔王
阅读(74)
评论(0)
推荐(0)
摘要：
What is the impact of the following backup if it exceeds the duration allowance? (Choose all thatapply.)Backup as compressed backupset duration 2:00 p 阅读全文
posted @ 2017-11-10 17:55
巴啦啦大魔王
阅读(98)
评论(0)
推荐(0)
摘要：
How long will this backup be allowed to run?Backup as compressed backupset duration 2:00 minimize load database ;A. 2 minutesB. 2 hoursC. 2 daysD. The 阅读全文
posted @ 2017-11-10 17:48
巴啦啦大魔王
阅读(92)
评论(0)
推荐(0)
摘要：
If a backup set is expired, what can you do to correct the problem?A. Change the retention criteria.B. Make the lost backup set pieces available to RM 阅读全文
posted @ 2017-11-10 17:46
巴啦啦大魔王
阅读(65)
评论(0)
推荐(0)
摘要：
What does it mean if a backup is expired?A. The backup set has exceeded the retention criteria set in RMAN and is eligible for removal.B. The backup s 阅读全文
posted @ 2017-11-10 17:43
巴啦啦大魔王
阅读(185)
评论(0)
推荐(0)
摘要：
Why would you run the delete obsolete command? (Choose all that apply.)A. To remove missing backup set pieces physically from diskB. To remove metadat 阅读全文
posted @ 2017-11-10 17:40
巴啦啦大魔王
阅读(98)
评论(0)
推荐(0)
摘要：
You run the following commands:RMAN> list expired backup; RMAN> delete expired backup;What will happen to the backup set pieces associated with the ba 阅读全文
posted @ 2017-11-10 17:35
巴啦啦大魔王
阅读(82)
评论(0)
推荐(0)
摘要：
You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have anautomated cross-check script that also does a delete ex 阅读全文
posted @ 2017-11-10 16:54
巴啦啦大魔王
阅读(107)
评论(0)
推荐(0)
摘要：
You want to make sure that your database backup does not exceed 10 hours in length. Whatcommand would you issue that would meet this condition?A. back 阅读全文
posted @ 2017-11-10 16:50
巴啦啦大魔王
阅读(140)
评论(0)
推荐(0)
摘要：
You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to 阅读全文
posted @ 2017-11-10 16:48
巴啦啦大魔王
阅读(107)
评论(0)
推荐(0)
摘要：
What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media?A. crosscheckB. 阅读全文
posted @ 2017-11-10 16:41
巴啦啦大魔王
阅读(153)
评论(0)
推荐(0)
摘要：
Which command would you use to determine what database backups are currently available forrestore?A. list database backup;B. report database backup;C. 阅读全文
posted @ 2017-11-10 16:37
巴啦啦大魔王
阅读(143)
评论(0)
推荐(0)
摘要：
David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the contr 阅读全文
posted @ 2017-11-10 16:34
巴啦啦大魔王
阅读(111)
评论(0)
推荐(0)
摘要：
Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?A. shutd 阅读全文
posted @ 2017-11-10 16:25
巴啦啦大魔王
阅读(112)
评论(0)
推荐(0)
摘要：
What will be the end result of this set of RMAN commands?shutdown abortstartup mountrestore datafile 4 until time ,,09/30/2008:15:00:00; recover dataf 阅读全文
posted @ 2017-11-10 16:23
巴啦啦大魔王
阅读(182)
评论(0)
推荐(0)
摘要：
If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status ofMEDIA_CORRUPT, what RMAN command would you run to correct the problem?A. re 阅读全文
posted @ 2017-11-10 16:12
巴啦啦大魔王
阅读(108)
评论(0)
推荐(0)
摘要：
You have backed up your database using image copies. You have lost the SYSTEM tablespace and need to restart your database as quickly as possible. Wha 阅读全文
posted @ 2017-11-10 16:08
巴啦啦大魔王
阅读(123)
评论(0)
推荐(0)
摘要：
You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP.You want to"roll back" the data in the USERS tablespace to the w 阅读全文
posted @ 2017-11-10 16:03
巴啦啦大魔王
阅读(142)
评论(0)
推荐(0)
摘要：
Which of the following does the recover command not do? A. Restore archived redo logs.B. Apply archived redo logs.C. Restore incremental backups.D. Ap 阅读全文
posted @ 2017-11-10 15:54
巴啦啦大魔王
阅读(102)
评论(0)
推荐(0)
摘要：
Which of the following are valid until command options when attempting point-in-time recovery inRMAN? (Choose all that apply.)A. until timeB. until ch 阅读全文
posted @ 2017-11-10 15:36
巴啦啦大魔王
阅读(91)
评论(0)
推荐(0)
摘要：
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:RESTORE CONTR 阅读全文
posted @ 2017-11-10 15:27
巴啦啦大魔王
阅读(138)
评论(0)
推荐(0)
摘要：
What is the correct order of the following commands if you wanted to restore datafile 4, which wasaccidentally removed from the file system?A. sql 'al 阅读全文
posted @ 2017-11-10 15:21
巴啦啦大魔王
阅读(89)
评论(0)
推荐(0)
摘要：
You need to restore your database back to 9/30/2008 at 18:00. In what order would you run thefollowing commands to compete this task?A. restore contro 阅读全文
posted @ 2017-11-10 15:07
巴啦啦大魔王
阅读(115)
评论(0)
推荐(0)
摘要：
True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.A. TrueB. False There is no equivalent RMAN co 阅读全文
posted @ 2017-11-10 15:02
巴啦啦大魔王
阅读(116)
评论(0)
推荐(0)
摘要：
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-fileautobackups. Which files are not backed up during the RMAN ba 阅读全文
posted @ 2017-11-10 14:53
巴啦啦大魔王
阅读(128)
评论(0)
推荐(0)
摘要：
What is the end result of these commands if they are successful?RMAN> show retention policy;RMAN configuration parameters for database with db_unique_ 阅读全文
posted @ 2017-11-10 14:47
巴啦啦大魔王
阅读(122)
评论(0)
推荐(0)
摘要：
Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours?A. restore datafiles until time '09/28/2008:21:03:11';B. restore databas 阅读全文
posted @ 2017-11-10 14:39
巴啦啦大魔王
阅读(91)
评论(0)
推荐(0)
摘要：
If you lost your entire database, including the database spfile, control files, online redo logs, anddatabase datafiles, what kind of recovery would b 阅读全文
posted @ 2017-11-10 14:36
巴啦啦大魔王
阅读(104)
评论(0)
推荐(0)
摘要：
Given a complete loss of your database, in what order would you need to perform the followingRMAN operations to restore it?A. restore controlfileB. re 阅读全文
posted @ 2017-11-10 14:23
巴啦啦大魔王
阅读(110)
评论(0)
推荐(0)
摘要：
Which commands are used for RMAN database recovery? (Choose all that apply.)A. restoreB. repairC. copyD. recoverE. replace The restore command is used 阅读全文
posted @ 2017-11-10 14:07
巴啦啦大魔王
阅读(140)
评论(0)
推荐(0)
摘要：
Given the following RMAN commands, choose the option that reflects the order required to restoreyour currently operational ARCHIVELOG-mode database.A. 阅读全文
posted @ 2017-11-10 14:03
巴啦啦大魔王
阅读(190)
评论(0)
推荐(0)
摘要：
What command would you issue to enable automated backups of control files?A. alter database controlfile autobackup onB. alter system controlfile autob 阅读全文
posted @ 2017-11-10 13:39
巴啦啦大魔王
阅读(96)
评论(0)
推荐(0)
摘要：
Which is the correct way to connect to both the target database and the recovery catalogfrom the RMAN command line? Assume that the target database is 阅读全文
posted @ 2017-11-10 13:34
巴啦啦大魔王
阅读(123)
评论(0)
推荐(0)
摘要：
Given the scriptcreate script db_backup_datafile_script{backup datafile and 1, and2 plus archivelog delete input;}What is the result of running this c 阅读全文
posted @ 2017-11-10 13:29
巴啦啦大魔王
阅读(428)
评论(0)
推荐(0)
摘要：
The RVPC user can do which of the following? (Choose all that apply.)A. Register databases if granted the register database privilegeB. See all databa 阅读全文
posted @ 2017-11-10 12:39
巴啦啦大魔王
阅读(122)
评论(0)
推荐(0)
摘要：
How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?A. Issue the grant command from the SYS 阅读全文
posted @ 2017-11-10 12:36
巴啦啦大魔王
阅读(142)
评论(0)
推荐(0)
摘要：
In what order would you execute the following steps to create a recovery catalog?A. Issue the create catalog command.B. Create the recovery-catalog da 阅读全文
posted @ 2017-11-10 12:28
巴啦啦大魔王
阅读(103)
评论(0)
推荐(0)
摘要：
You have created a script in the recovery catalog called backup_database. Which of the followingcommands would successfully execute that script?A. run 阅读全文
posted @ 2017-11-10 12:25
巴啦啦大魔王
阅读(80)
评论(0)
推荐(0)
摘要：
If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated? (Choose all that 阅读全文
posted @ 2017-11-10 12:19
巴啦啦大魔王
阅读(84)
评论(0)
推荐(0)
摘要：
用Informatica跑ETL时，出现ora-26002错误。使用BULK时会报这个错误，因为是大批量insert插入所以很多normal insert时该完成的任务没完成，例如表上有索引时。而且BULK不支持update。 总结出现这个错误可以把load type改成normal 阅读全文
posted @ 2017-11-10 11:40
巴啦啦大魔王
阅读(507)
评论(0)
推荐(0)
摘要：
Which command do you use to create a recovery-catalog schema?A. create recovery catalogB. create catalogC. build catalogD. catalog createE. mount cata 阅读全文
posted @ 2017-11-10 10:16
巴啦啦大魔王
阅读(108)
评论(0)
推荐(0)
浙公网安备 33010602011771号