网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
5、SQL的CREATE操作属于_____。
A.数据定义语言
B.数据操纵语言
C.数据操作语言
D.数据修改语言
参考答案和解析
正确
更多 “5、SQL的CREATE操作属于_____。A.数据定义语言B.数据操纵语言C.数据操作语言D.数据修改语言” 相关考题
考题
在下列的SQL语句中,属于数据操作语句的是( )。Ⅰ.CREATEⅡ.SELECTⅢ.UPDATEⅣ.GRANTⅤ.DROPⅥ.DELETEⅦ.ALTERⅧ.INSERTⅨ.REVOKEA.Ⅰ、Ⅴ、Ⅵ、ⅦB.Ⅳ、ⅨC.Ⅲ、Ⅵ、ⅧD.Ⅰ、Ⅴ、Ⅶ
考题
下列SQL命令全部属于数据定义语句的是()A、CREATE,DROP,ALTERB、CREATE,DROP,SELECTC、CREATE,DROP,GRANTD、CREATE,DROP,UPDATE
考题
SQL Server2005中,使用()可以创建一个触发器。A、create procedureB、create tableC、create triggerD、create index
考题
单选题Examine the commands executed in the following sequence: 1:SQL CREATE ROLE mgrrole; 2:SQL GRANT create user,select any table,connect,resource TO mgrrole; 3:SQL GRANT select,update ON sh.sales TO mgrrole; 4:SQL CREATE ROLE ceo IDENTIFIED BY boss; 5:SQL GRANT mgrrole,drop any table,create any directory TO ceo; 6:SQL GRANT ceo TO mgrrole; Which statement is true about the above commands()A
The commands execute successfully.B
Command 6 produces an error because of circular role grant.C
Command 5 produces an error because a role cannot be granted to another role.D
Command 3 produces an error because the MGRROLE role already contains system privileges.E
The table created by HR remains and HR still has the CREATE TABLE system privilege.F
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
热门标签
最新试卷