摘要：
You notice that a long-running transaction is suspended due to a space constraint, and there is no AFTER SUSPEND triggered event addressing the issue. 阅读全文
posted @ 2017-11-06 23:37
巴啦啦大魔王
阅读(122)
评论(0)
推荐(0)
摘要：
The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are 阅读全文
posted @ 2017-11-06 23:32
巴啦啦大魔王
阅读(140)
评论(0)
推荐(0)
摘要：
Which of the following are true concerning block media recovery? (Choose all that apply.)A. Any gap in archive logs ends the recovery.B. If a gap in a 阅读全文
posted @ 2017-11-06 23:29
巴啦啦大魔王
阅读(128)
评论(0)
推荐(0)
摘要：
In a Database Replay workload capture, what client request information is gathered? (Choose all thatapply.)A. SQL textB. Shared server requests (Oracl 阅读全文
posted @ 2017-11-06 23:08
巴啦啦大魔王
阅读(98)
评论(0)
推荐(0)
摘要：
A developer calls and reports that he accidentally dropped an important lookup table from aproduction database. He needs the table to be recovered. Wh 阅读全文
posted @ 2017-11-06 18:28
巴啦啦大魔王
阅读(143)
评论(0)
推荐(0)
摘要：
A user performs an update on a table. Shortly after committing the transaction, they realize that theyhad an error in their WHERE clause causing the w 阅读全文
posted @ 2017-11-06 18:19
巴啦啦大魔王
阅读(78)
评论(0)
推荐(0)
摘要：
What RMAN command is used to execute a tablespace point-in-time recovery?A. recoverB. duplicateC. restoreD. copyE. None of the above You use the recov 阅读全文
posted @ 2017-11-06 18:10
巴啦啦大魔王
阅读(129)
评论(0)
推荐(0)
摘要：
Which operation requires that you create an auxiliary instance manually before executing theoperation? (Choose all that apply.)A. Backup-based databas 阅读全文
posted @ 2017-11-06 18:07
巴啦啦大魔王
阅读(150)
评论(0)
推荐(0)
摘要：
When youre performing a tablespace point-in-time recovery, which tablespaces will always berestored to the auxiliary instance? (Choose all that apply. 阅读全文
posted @ 2017-11-06 18:04
巴啦啦大魔王
阅读(112)
评论(0)
推荐(0)
摘要：
What are the two different types of database duplication? (Choose two.)A. ActiveB. PassiveC. OnlineD. Backup-basedE. Failure driven Active database du 阅读全文
posted @ 2017-11-06 18:01
巴啦啦大魔王
阅读(100)
评论(0)
推荐(0)
摘要：
Which of the following commands will fail?A. report schema;B. report need backup;C. report need backup days 3;D. report user; E. report obsolete; Ther 阅读全文
posted @ 2017-11-06 17:57
巴啦啦大魔王
阅读(95)
评论(0)
推荐(0)
摘要：
What is the purpose of the catalog command?A. To review RMAN control file and recovery catalog metadata and ensure that its correctB. To delete RMAN b 阅读全文
posted @ 2017-11-06 17:53
巴啦啦大魔王
阅读(196)
评论(0)
推荐(0)
摘要：
What is the purpose of the list expired backup command?A. Lists all backups impacted by a resetlogs commandB. Lists all backups that are subject to re 阅读全文
posted @ 2017-11-06 17:47
巴啦啦大魔王
阅读(175)
评论(0)
推荐(0)
摘要：
What is an obsolete backup set?A. A backup set that is missing one or more backup set piecesB. A backup that has exceeded the retention criteria and i 阅读全文
posted @ 2017-11-06 17:42
巴啦啦大魔王
阅读(119)
评论(0)
推荐(0)
摘要：
What is the purpose of the recover command? (Choose all that apply.)A. Recover database datafiles from physical disk backup sets.B. Recover required i 阅读全文
posted @ 2017-11-06 17:36
巴啦啦大魔王
阅读(145)
评论(0)
推荐(0)
摘要：
What is the purpose of the until change option of the restore command?A. It allows you to select the SCN that you want to restore to. B. It allows you 阅读全文
posted @ 2017-11-06 17:25
巴啦啦大魔王
阅读(117)
评论(0)
推荐(0)
摘要：
While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount ofcorrupted data into the database. Pablo has discovered thi 阅读全文
posted @ 2017-11-06 17:20
巴啦啦大魔王
阅读(139)
评论(0)
推荐(0)
摘要：
You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:SQL> startup ORA-01078: 阅读全文
posted @ 2017-11-06 17:06
巴啦啦大魔王
阅读(116)
评论(0)
推荐(0)
摘要：
What RMAN command must you use before you can back up a database using the recovery catalog?A. create catalogB. install databaseC. catalog databaseD. 阅读全文
posted @ 2017-11-06 17:02
巴啦啦大魔王
阅读(107)
评论(0)
推荐(0)
摘要：
You can back up the RMAN recovery catalog with RMAN.A. TrueB. False You can back up any database without connecting to the recovery catalog,includingt 阅读全文
posted @ 2017-11-06 16:59
巴啦啦大魔王
阅读(116)
评论(0)
推荐(0)
摘要：
RMAN provides more granular catalog security through which feature?A. Virtual private databaseB. Virtual private catalogC. RMAN virtual databaseD. RMA 阅读全文
posted @ 2017-11-06 16:54
巴啦啦大魔王
阅读(187)
评论(0)
推荐(0)
摘要：
What is the purpose of the RMAN recovery catalog? (Choose all that apply.)A. Make backups fasterB. Store RMAN metadataC. Store RMAN scriptsD. Provide 阅读全文
posted @ 2017-11-06 16:50
巴啦啦大魔王
阅读(124)
评论(0)
推荐(0)
摘要：
A shoot-out has erupted between your MS development teams using .NET and your Linuxdevelopment teams using Java. Knowing that your database is in dang 阅读全文
posted @ 2017-11-06 16:45
巴啦啦大魔王
阅读(140)
评论(0)
推荐(0)
摘要：
Which RMAN backup command is used to create the block-change tracking file?A. alter database create block change tracking fileB. alter database enable 阅读全文
posted @ 2017-11-06 16:28
巴啦啦大魔王
阅读(132)
评论(0)
推荐(0)
摘要：
Which of the following RMAN structures can data from a datafile span? A. RMAN backup-set pieces spanning backup setsB. RMAN backup-set pieces within a 阅读全文
posted @ 2017-11-06 16:25
巴啦啦大魔王
阅读(149)
评论(0)
推荐(0)
摘要：
Which of the following files cannot be backed up by RMAN? (Choose all that apply.)A. Database datafilesB. Control filesC. Online redo logsD. Database 阅读全文
posted @ 2017-11-06 16:23
巴啦啦大魔王
阅读(146)
评论(0)
推荐(0)
摘要：
Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours.This is the only backup you have. You have lost all the ar 阅读全文
posted @ 2017-11-06 16:17
巴啦啦大魔王
阅读(105)
评论(0)
推荐(0)
摘要：
Which command is used to open the database after an incomplete recovery?A. alter database openB. alter database open repairlogC. alter database open r 阅读全文
posted @ 2017-11-06 16:11
巴啦啦大魔王
阅读(102)
评论(0)
推荐(0)
摘要：
--先上结论 prior id=fid时，下一行列fid的值起始行列id的值--可以用树形结构来标识，当 prior父节点id=子节点fid时，父节点在最上--当prior子节点fid=父节点id，父节点在最下 select id,fid from tab1 start with id=100078 connect by id=prior fid 1 100078 100971 2... 阅读全文
posted @ 2017-11-06 14:19
巴啦啦大魔王
阅读(484)
评论(0)
推荐(0)
摘要：
You have lost datafiles 1 and 3 from your database, and the database has crashed. In what ordershould you perform the following steps to recover your 阅读全文
posted @ 2017-11-06 13:38
巴啦啦大魔王
阅读(111)
评论(0)
推荐(0)
摘要：
If a log file becomes corrupted, it may cause the database to stall. How would you correct such asituation?A. Recover the online redo log from backup. 阅读全文
posted @ 2017-11-06 13:26
巴啦啦大魔王
阅读(132)
评论(0)
推荐(0)
摘要：
When you create a backup control file, where is the resulting file written to?A. The database user dump destination directoryB. The database diagnosti 阅读全文
posted @ 2017-11-06 13:21
巴啦啦大魔王
阅读(108)
评论(0)
推荐(0)
摘要：
Which of the following statements is true when the database is in ARCHIVELOG mode andtablespaces are in hot backup mode?A. Archive log generation is s 阅读全文
posted @ 2017-11-06 13:18
巴啦啦大魔王
阅读(134)
评论(0)
推荐(0)
摘要：
You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, asshown here:1.Put the tablespaces in backup mode.2.Back up the d 阅读全文
posted @ 2017-11-06 13:12
巴啦啦大魔王
阅读(95)
评论(0)
推荐(0)
摘要：
What Oracle process runs when the database is in ARCHIVELOG mode but not when it is inNOARCHIVELOG mode?A. MMONB. LGWRC. ARCHD. ARWRE. COPY 感觉没啥好分析的，应 阅读全文
posted @ 2017-11-06 13:04
巴啦啦大魔王
阅读(132)
评论(0)
推荐(0)
摘要：
Which of the following is not a configurable attribute for an individual disk group?A. AU_SIZEB. COMPATIBLE.RDBMSC. COMPATIBLE.ASMD. DISK_REPAIR_TIMEE 阅读全文
posted @ 2017-11-06 12:59
巴啦啦大魔王
阅读(136)
评论(0)
推荐(0)
摘要：
What is the net effect of the following command?alter diskgroup dgroup1 drop disk abc;A. The disk ABC will be dropped from the disk group. Since you d 阅读全文
posted @ 2017-11-06 12:53
巴啦啦大魔王
阅读(103)
评论(0)
推荐(0)
摘要：
After executing the command alter diskgroup disk group2 drop disk dg2a; you issue the followingcommand from the ASM instance:Select group_number, coun 阅读全文
posted @ 2017-11-06 12:47
巴啦啦大魔王
阅读(226)
评论(0)
推荐(0)
摘要：
ASM supports all but which of the following file types? (Choose all that apply.) A. Database files B. Spfiles C. Redo-log files D. Archived log files 阅读全文
posted @ 2017-11-06 12:36
巴啦啦大魔王
阅读(208)
评论(0)
推荐(0)
浙公网安备 33010602011771号