SQL语句DROP TABLE实现以下的哪类功能()
A . 数据查询
B . 数据操作
C . 数据定义
D . 数据控制
时间:2022-11-01 18:47:55
所属题库:关系数据库题库
相似题目
-
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.
-
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.
-
SQL语言集数据查询、数据操作、数据定义和数据控制功能于一体,语句INSERT、DELETE、UPDATA实现下列哪类功能()。
A . 数据查询
B . 数据操纵
C . 数据定义
D . 数据控制
-
在SQL的查询语句中,()选项实现分组统计功能,()选项实现对结果表的排序功能。
-
语句drop table可以()。
A . 删除一张表
B . 删除一个视图
C . 删除一个索引
D . 删除一个游标
-
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
-
从当前数据库中删除Test表及其数据和索引的语句为:DROP TABLE 教务管理.dbo.Test
-
SQL语言中,实现数据存取控制功能的语句是( )
-
SQL语言中,实现数据检索功能的是 语句。
-
CREATE TABLE是______功能的SQL语句。CREATE TABLE是______功能的SQL语句
-
在数据库应用中,一般一个SQL语句可产生或处理一组记录,而数据库主语言语句一般一次只能处理一个记录,其协调可通过使用如下所列的哪种技术来实现?()
A.指针(POINTER)
B.游标(CURSOR)
C.数组(DIMENSION)
D.栈(STACK)
-
SQL中的DROP,INDEX语句的作用是
A. 删除索引
B.建立索引
C.更新索引
D.修改索引
-
SQL语言集数据查询、数据操作、数据定义和数据控制功能于一体,语句INSERT、 DELETE、UPDATE实现哪类功能?
A.数据查询
B.数据操纵
C.数据定义
D.数据控制
-
SQL语言集数据查询、数据操作、数据定义和数据控制功能于一体,语句INSERT, DELETE,UPDATE实现哪类功能?
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语言集数据查询、数据操纵、数据定义和数据控制功能于一体,语句CREATE、 DROP、ALTER实现哪类功能?______。
A.数据查询
B.数据操纵
C.数据定义
D.数据控制
-
SQL语句,在删除数据的速度上,一般来说,drop>delete>truncate()
是
否
-
当DROP TABLE语句删除表时,为了快速恢复被删除的表,下列()SQL语句最合适
A.LASHBACK
B.GETBACK
C.OMEBACK
D.以上都不是
-
4、以下SQL语句实现的功能是__ _。 Update 课程表 Set 学分=学分+1 Where 学分>2
A.查找课程表中学分增加1分后还小于2学分的课程
B.修改课程表中的学分字段,将其字段名称改为“学分+1”
C.将学分不大于2分的所有课程的学分上调1分
D.以上都不对
-
SQL中用于删除基本表的语句是()。 A.DROP B.UPDATE C.ZAP D.DELETE
A.A
B.B
C.C
D.D
-
在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)