[单选]

You issued the following command：  
ALTER TABLE SCOTT.EMP SHRINK SPACE；  
The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties：  
DATA1 is a read/write tablespace.  
DATA1 is not autoextensible to an unlimited size.  DATA1 is online.  
Segment space management for the DATA1 tablespace is manual.  
You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error：  
ORA-10635： Invalid segment or tablespace type  
 What could be the reason for the failure of the command？（）

User A executes the following command to drop a large table in your database： SQL> DROP TABLE trans；  While the drop table operation is in progress， user B executes the following command on the same table： SQL> DELETE FROM trans WHERE tr_type=’SL’；  Which statement is true regarding the DELETE command（） It fails with a "Resource Busy" error.。 It deletes the rows successfully because the table is locked in SHARE mode.。 It fails to delete the records because the table is locked in EXCLUSIVE mode.。 It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.。 可用于细菌鉴定和分型的是（）。 The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task， SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index？（） An update in a leaf row takes place.。 The index becomes invalid after the update.。 The leaf block containing the row to be updated is marked as invalid.。 A row in the leaf block of the index for the key value is deleted and inserted.。 无需单独编制专项施工方案的混凝土模板支撑工程是（）。 搭设跨度10m的模板支撑工程。 搭设高度5m的模板支撑工程。 施工总荷载10kN/m²的模板支撑工程。 集中线荷载10kN/m²的模板支撑工程。 Which command should an administrator use to view files and volume group backup information from a mksysb called server1.mksysb that is found in /backups？（）   lsmksysb -l /backups/server1.mksysb。 showmksysb -f /backups/server1.mksysb。 listvgbackup -f /backups/server1.mksysb。 showvgbackup -l /backups/server1.mksy。

You issued the following command：  
ALTER TABLE SCOTT.EMP SHRINK SPACE；  
The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties：  
DATA1 is a read/write tablespace.  
DATA1 is not autoextensible to an unlimited size.  DATA1 is online.  
Segment space management for the DATA1 tablespace is manual.  
You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error：  
ORA-10635： Invalid segment or tablespace type  
 What could be the reason for the failure of the command？（）