Examine the following ALTER command: SQL> ALTER DISKGROUP dg

第1题：

Which two commands never trigger an implicit rebalancing within the disk group?（） (Choose two.)

• A、ALTER DISKGROUP misc MOUNT;
• B、ALTER DISKGROUP misc DROP DISK misc2;
• C、ALTER DISKGROUP misc CHECK ALL NOREPAIR;
• D、ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
• E、ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';

第2题：

Which two commands never trigger an implicit rebalancing within the disk group?（）

• A、ALTER DISKGROUP misc MOUNT;
• B、ALTER DISKGROUP misc DROP DISK misc2;
• C、ALTER DISKGROUP misc CHECK ALL NOREPAIR;
• D、ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
• E、 ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';

第3题：

第4题：

Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

• A、The constraint remains valid.
• B、The index on the constraint is dropped.
• C、It allows the loading of data into the table using SQL*Loader.
• D、New data conforms to the constraint， but existing data is not checked
• E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

第5题：

You want to perform the following operations for the DATA ASM disk group： -Verify the consistency of the disk.  -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly.  -Check that ASM metadata directories do not have unreachable allocated blocks.   Which command accomplishes these tasks（）？

• A、 ALTER DISKGROUP data CHECK
• B、 ALTER DISKGROUP data CHECK DISK
• C、 ALTER DISKGROUP data CHECK FILE
• D、 ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1

第6题：

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

• A、Immediately following statement execution 
• B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued 
• C、After the ALTER TABLE SET UNUSED COLUMN command is issued 
• D、After the ALTER TABLE MODIFY command is issued

第7题：

Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）

• A、The table is moved to the SYSAUX tablespace.
• B、The table is moved to the SYSTEM tablespace.
• C、The table is removed from the database permanently.
• D、The table is renamed and remains in the TBSFD tablespace.

第8题：

第9题：

How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed？（）  

• A、 Issue the ALTER DISKGROUP ... ADD DISK command.
• B、 Issue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command.
• C、 Issue the ALTER DISKGROU
• D、 Retrieve the disk from the Recycle Bin after the operation completes.

第10题：

Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）

• A、It cancels all pending disk drops within the disk group
• B、It restores disks that are being dropped as the result of a DROP DISKGROUP operation
• C、It mounts disks in the disk group for which the drop-disk operation has already been completed
• D、It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
• E、It adds previously dropped disks back into the disk group