Consider&ensp;the&ensp;following&ensp;...

单项选择题 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*’；

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题You are maintaining the SALES database on Oracle 10g. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter will you specify to control the speed of the rebalancing activity？（）

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

点击查看答案

2.单项选择题Which statement will NOT create a tablespace？（）

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’；

点击查看答案

3.单项选择题You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）

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.

点击查看答案

4.单项选择题You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）

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.

点击查看答案

5.单项选择题While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）

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

点击查看答案

6.单项选择题Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）

A.ADDM
B.AWR
C.Cursor Cache
D.SQL Tuning Sets
E.Flash Recovery Area

点击查看答案

7.单项选择题You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（）

A.DBMS_SERVER_ALERT
B.DBMS_ADVISOR
C.DBMS_RESOURCE_MANAGER
D.DBMS_REPAIR

点击查看答案

8.单项选择题You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）

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

点击查看答案

9.单项选择题You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）

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

点击查看答案

10.单项选择题 You accepted the recommended SQL Profile by executing the following code：
DECLARE
sqlprofile_name varchar2（30）；
BEGIN
sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（ task_name => ’my_task’，
profile_name => ’my_profile’）；
END；
Which advisor will analyze this profile？（）

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

点击查看答案