116、

116.Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)
A. It can be used to back up all data on ASM disks.
B. It can be used to recover the damaged ASM disk group along with the data.
C. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.
D. It can be used to re-create the ASM disk group with its attributes.
Answer: CD
View Code

 

117、

117.Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.)
A. multiplexing of the control file
B. adding the redo log member to the database
C. database and operating system upgrades
D. changing the database storage to ASM-managed storage
Answer: CD 
View Code

 

118、

118.Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
A. SQL statements that are part of the AWR baseline only
B. SQL statements based on the AWR top SQL identification
C. SQL statements that are part of the available SQL Tuning Set (STS) only
D. SQL statements that are available in the cursor cache and executed by a user other than SYS
Answer: B
View Code

 

119、

119.While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. 
You have multiple destinations for archived redo log files. 
What implications does it have on the backup of the flash recovery area?
A. The backup fails because one of the archived redo log files is missing.
B. The backup succeeds but it would be without the missing archived log.
C. During backup, you are prompted for the alternative destination for the missing archived redo log file.
D. The backup succeeds because it fails over to one of the alternative archived redo log destinations.
Answer: D
View Code

 

120、

120.You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. 
Which statement regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)
A. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.
C. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
D. ASM compatibility controls which features for the ASM will be enabled.
Answer: ABD 
View Code

 

posted on 2016-04-16 08:59  充实自己  阅读(316)  评论(0编辑  收藏  举报