-
使用DROP语句撤消基本表时，使用以下哪个子句，可以将下属的视图和约束引用全部撤消？（）
A . NULL
B . RESTRICT
C . CASCADE
D . DISTINCT
-
Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）
A . A syntax error will result as you cannot specify more than one partition in the same statement
B . All data in p1 and p3 partitions are removed and the table definition is changed
C . All data in p1 and p3 partitions are removed, but the table definition remains unchanged
D . Only the first partition (p1) will be dropped as only one can be dropped at any time
-
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）
A . You cannot roll back this statement.
B . All pending transactions are committed.
C . All views based on the DEPT table are deleted.
D . All indexes based on the DEPT table are dropped.
E . All data in the table is deleted, and the table structure is also deleted.
F . All data in the table is deleted, but the structure of the table is retained.
G . All synonyms based on the DEPT table are deleted.
-
Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）
A . SRW.BREAK
B . SRW.SET_ALTER
C . SRW.REFERENCE
D . SRW.DO_SQL
E . SRW.RUN_REPORT
F . SRW.SET_FIELD
-
You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable： SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about the effect of the command（）
A . No flashback is possible to bring back the ITEM table.
B . The ORDER table is dropped along with the ITEM table.
C . The dependent referential integrity constraints in the ORDER table are disabled.
D . The dependent referential integrity constraints in the ORDER table are removed.
E . The table definition of the ITEM table and associated indexes are placed in the recycle bin.
-
使用Alter table语句可以（）。
A、同时修改字段数据类型和长度
B、修改计算列
C、产量 float
D、同时删除字段和字段约束
-
A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）
A . Initiate an incomplete recovery operation using RMAN.
B . Copy the table from a development database.
C . Advise the user to rekey the data.
D . Perform a Flashback Drop operation.
E . Perform a Flashback Recovery operation.
-
使用DROP TABLE删除表时，表中存储的数据也将同时被删除。
A . 正确
B . 错误
-
假设在数据库中创建了用户test，需要为其授予CREATE ANY TABLE系统权限，可以使用如下（）语句。
A . GRANT CREATE ANY TABLE test
B . GRANT CREATE ANY TABLE TO test
C . TAKE CREATE ANY TABLE TO test
D . ALTER CREATE ANY TABLE TO test
-
You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about theeffect of the command（）
A . No flashback is possible to bring back the ITEM table.
B . The ORDERS table is dropped along with the ITEM table.
C . The dependent referential integrity constraints in the ORDERS table are disabled.
D . The dependent referential integrity constraints in the ORDERS table are removed.
E . The table definition of the ITEM table and associated indexes are placed in the recycle bi
-
You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）
A . All data along with the table structure is deleted
B . The pending transaction in the session is committed
C . All indexes on the table will remain but they are invalidated
D . All views and synonyms will remain but they are invalidated
E . All data in the table are deleted but the table structure will remai
-
SQL语句DROP TABLE实现以下的哪类功能（）
A . 数据查询
B . 数据操作
C . 数据定义
D . 数据控制
-
从当前数据库中删除Test表及其数据和索引的语句为：DROP TABLE 教务管理.dbo.Test
-
删除数据表的列的命令是drop table。
-
SQL中的DROP，INDEX语句的作用是
A． 删除索引
B．建立索引
C．更新索引
D．修改索引
-
在SQL语句中，删除视图语句的是（)。A．ZAP VIEWB．ALDER VIEWC．DELETE VIEWD．DROP VIEW
在SQL语句中，删除视图语句的是()。
A．ZAP VIEW
B．ALDER VIEW
C．DELETE VIEW
D．DROP VIEW
-
SQL语句，在删除数据的速度上，一般来说，drop＞delete＞truncate（）
是
否
-
在Visual FoxPro中，下列关于SQL表定义语句（CREATE TABLE)的说法错误的是（）。A.可以定义一个新的
在Visual FoxPro中，下列关于SQL表定义语句(CREATE TABLE)的说法错误的是（）。
A.可以定义一个新的基本表结构
B.可以定义数据库表中的主关键字
C.可以定义表的域完整性、字段有效性规则等
D.对自由表，同样可以实现其完整性、有效性规则等信息的设置
-
当DROP TABLE语句删除表时，为了快速恢复被删除的表，下列（）SQL语句最合适
A．LASHBACK
B．GETBACK
C．OMEBACK
D．以上都不是
-
alter table语句可以用于在已有的表中添加、删除或修改列。（)
是
否
-
可以使用DROP TABLE来删除数据库表
是
否
-
在SQL中,drop index语句的作用是（）
A．建立索引
B．删除目录
C．删除索引
D．修改索引
-
在SQL中， DROP INDEX语句的作用是（)。
A．建立索引
B．删除索引
C．修改索引
D．更新索引
-
13、如果学生表st是使用以下SQL语句创建的：CREATE TABLE st （sno CHAR（4) not null,sn CHAR（8),sex CHAR（2),age INT)；下面的SQL语句中可以正确执行的是（)
A．INSERT INTO st(sno,sex,age) VALUES (″s9″,″男″,17)
B．INSERT INTO st(sn,sex,age) VALUES(″李安齐″,″男″,20)
C．INSERT INTO st(sex,age)VALUES(″男″,20)
D．INSERT INTO st(sno,sn)VALUES(″s9″,″安齐″,16)
