单项选择题

Consider the following configuration：
/devices/diskP1 is a member of disk group grp1.
/devices/diskP2 is a member of disk group grp1.
/devices/diskP3 is a member of disk group grp1.
/devices/diskP4 is a candidate disk.
/devices/diskQ1 is a member of disk group grp2.
/devices/diskQ2 is a member of disk group grp2.
/devices/diskQ3 is a member of disk group grp2.
/devices/diskQ4 is a candidate disk.
Which command will add the disk /devices/diskP4 to the disk group， grp1？（）

A. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskP1’， ADD DISK ’/devices/diskP4’；
B. ALTER DISKGROUP grp1 ADD DISK ’/devices/disk*4’；
C. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskP*’；
D. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskQ*’， ADD DISK ’/devices/diskP*’；

<上一题目录下一题>

热门试题

单项选择题YouaremaintainingtheSALESdatabaseonOracle10g.Youhaveaddedanewdisktoadiskgroup.AutomaticStorageManagementperformstherebalancingactivity.Youwanttospeeduptherebalancingactivity.Whichparameterwillyouspecifytocontrolthespeedoftherebalancingactivity？（）

A. ASM_POWER_LIMIT
B. ASM_DISKSTRING
C. ASM_DISKGROUPS
D. LARGE_POOL_SIZE

单项选择题WhichstatementwillNOTcreateatablespace？（）

A. CREATE TABLESPACE DATA1 DATAFILE ’+grp1/abc（datafile）’；
B. CREATE TABLESPACE DATA1 DATAFILE ’+grp1’；
C. CREATE TABLESPACE DATA1 DATAFILE ’+data1（tempfile）’；
D. CREATE TABLESPACE DATA1 DATAFILE ’+grp1.256.34359’；

单项选择题YouaremaintainingyourdatabaseinOracle10g.YousetthevalueoftheUNDO_RETENTIONinitializationparametertozerointheinitializationparameterfile.Whatwillbetheimpactofspecifyingthissetting？（）

A. The database will not start.
B. The database will start but will not retain the undo data in the undo segment.
C. The database will start， and the undo segment will contain the undo data for at least one hour.
D. The database will start， and the undo segment will retain the undo data for at least 15 minutes.

单项选择题YouusetheMemoryAdvisortotunethememorystructuresofyourdatabase.WhatistheprerequisitetousetheMemoryAdvisor？（）

A. The database must be in the ARCHIVELOG mode.
B. The automatic memory tuning must be enabled.
C. The change tracking feature must be enabled.
D. The automatic memory tuning must be disabled.

单项选择题Whilerunninglongrunningqueries，youreceivetheSnapshottooolderror.WhichadvisorcanhelpyoutoavoidtheSnapshottooolderror？（）

A. Memory Advisor
B. Segment Advisor
C. Undo Advisor
D. SQL Tuning Advisor