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
单选题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()AThe commands execute successfully.BCommand 6 produces an error because of circular role grant.CCommand 5 produces an error because a role cannot be granted to another role.DCommand 3 produces an error because the MGRROLE role already contains system privileges.EThe table created by HR remains and HR still has the CREATE TABLE system privilege.FThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.