网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）

View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）

A. An error is produced.

B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted

C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged

D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

参考答案

更多 “ View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）A. An error is produced.B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjustedC. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchangedD. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process ” 相关考题
考题 Whichtwocodefragments,insertedindependentlyatline3,generatetheoutput4247?() A.Strings=123456789；s=（s-123）.replace（1，3，24）-89；B.StringBuffers=newStringBuffer（123456789）；s.delete（0，3）.replace（1，3，24）.delete（4，6）；C.StringBuffers=newStringBuffer（123456789）；s.substring（3，6）.delete（1，3）.insert（1，24）；D.StringBuilders=newStringBuilder（123456789）；s.substring（3，6）.delete（1，2）.insert（1，24）；E.StringBuilders=newStringBuilder（123456789）；s.delete（0，3）.delete（1，3）.delete（2，5）.insert（1，24）；
查看答案
考题 publicclassTestString3{publicstaticvoidmain(String[]args){／／insertcodehereSystem.out.println(s);}}Whichtwocodefragments,insertedindependentlyatline3,generatetheoutput4247?() A.Strings=“123456789”；s=（s-”123”）.replace（1，3，”24”）-“89”；B.StringBuffers=newStringBuffer（”123456789”）；s.delete（0，3）.replace（1，3，“24”）.delete（4，6）；C.StringBuffers=newStringBuffer（”123456789”）；s.substring（3，6）.delete（1，3）.insert（1，“24”）；D.StringBuilders=newStringBuilder（”123456789”）；s.substring（3，6）.delete（1，2）.insert（1，“24”）；E.StringBuilders=newStringBuilder（”123456789”）；s.delete（0，3）.delete（1，3）.delete（2，5）.insert（1，“24”）；
查看答案
考题 （ 22 ）如果只允许学生查看自己所选课程的信息和分数，则 DBA 应创建相应的A ）视图（ View ）B ）索引（ Index ）C) 游标（ Cursor ）D ）基本表（ Table ）
查看答案
考题 (23 ）为了提高查询速度，则 DBA 应创建相应的A ）视图（ View ）B ）索引（ Index ）C) 游标（ Cursor ）D) 基本表（ Table ）
查看答案
考题 触发器可引用视图或临时表，并产生两个特殊的表是______。（）A．Deleted、InsertedB．Delete、InsertC．View、TableD．Table1
查看答案
考题 5、触发器可引用视图或临时表，并产生两个特殊的表是______。（）A．Deleted、InsertedB．Delete、InsertC．View、TableD．View1、Table1
查看答案
考题 【单选题】对于建立在数据库上的DDL触发器，常用的激活DDL触发器的事件不包括（）A．Create_Table，Alter_Table，Drop_TableB．Create_View，Alter_View，Drop_ViewC．Create_Procedure，Alter_Procedure，Drop_ProcedureD．Rollback
查看答案
考题 触发器可引用视图或临时表，并产生两个特殊的表是_______。A．Deleted、InsertedB．Delete、InsertC．View、TableD．Table1
查看答案
考题 10、将事务对象trans 回滚的语句是________ 。A．trans.RollBack();B．trans.Restore();C．trans.Commit();D．trans.Close();
查看答案
考题 11、触发器可基于表或视图，并能产生两个特殊的表是（）A．Deleted、insertedB．Delete、insertC．View、tableD．View1、table1
查看答案
热门标签
最新试卷