单项选择题
Consider the following configuration：
/devices/D1is a member of disk group dgroupA.
/devices/D2is a member of disk group dgroupA.
/devices/D3is a member of disk group dgroupA.
You plan to add a new disk， /devices/D4，to the disk group dgroupA.
You execute the following command：
SQL> ALTER DISKGROUP dgroupA ADD DISK ’/devices/D*’；
Which task would be accomplished by the command？（）
A. The command adds the new disk， D4， to the disk group.
B. The command would result in an error because the is no disk by the name "’/devices/D*’"
C. The command will be ignored because disks starting with "D" are already members of the disk group.
D. The command would result in an error because no wildcard characters can be used in the disk name.
E. The command first detaches all the member disks starting with "D"， and the reattaches them including the new disk.
相关考题
-
单项选择题
You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）
A. It would return information regarding only the last committed transaction.
B. It would return only the active transactions in all the undo segments in the database.
C. It would return only the committed transactions in all the undo segments in the database.
D. It would return both active and committed transactions in all the undo segments in the database.
E. It would return information regarding the transactions that began and were committed in the last 30 minutes. -
多项选择题
YouareworkingonanOracleDatabase10gdatabase.YouenabledtheFlashbackDatabasefeature.Whichtwostatementsregardingflashbacklogsaretrue？（）
A. Flashback logs are not archived.
B. Flashback logs are maintained in redo log files.
C. Flashback logs are maintained in the Flash Recovery Area.
D. Flashback logs are used to maintain Flashback Database related errors.
E. Flashback logs need to be cleared manually after you disable Flashback Database. -
单项选择题
You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file and all the archived logs are accessible. Which option would you choose？（）
A. flash back the corrupted blocks
B. use the DBMS_REPAIR package
C. use the RMAN TSPITR command
D. use the RMAN BLOCKRECOVER command
E. use the RESTORE DATABASE and RECOVER DATABASE commands
F. investigate the time at which the corruption occurred and perform a point-in-time recovery
