What is the correct syntax to put a DATA1 disk offline for a failure group FG1, and drop it after five
minutes?
A.
ALTER DISKGROUP data OFFLINE DISK DATA1IN FAILGROUP FG2 DROP AFTER 5m;
B.
It is not possible to drop it after five minutes.
C.
It is not possible to specify a disk In a FAILGROUP.
D.
ALTER DISKGROUP data OFFLINE DISKS IN FAILGROUP FG2 DROP AFTER 5m;
E.
ALTER DISKGROUPdata OFFLINE DISK DATAI IN FAILGROUP FG2 DROP AFTER 5 minutes;
Explanation:
D
Correct syntax =
https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_1006.htm#SQLRF01113
OFFLINE DISKS IN FAILGROUP FAILGROUPNAME
DROP AFTER 5m;
https://docs.oracle.com/cd/B28359_01/server.111/b31107/asmdiskgrps.htm#OSTMG10048
DROP AFTER clause specifying 0h or 0m.