首页 > 计算机类 > 等级考试 > 计算机四级 > 数据库工程师 > 把对表 STUDENT 进行查找和插入的操作权限授予用户User1 ，并允许他将此权限再授予其他用户。下列哪一个 SQL语句正确表达了这一授权?

把对表 STUDENT 进行查找和插入的操作权限授予用户User1 ，并允许他将此权限再授予其他用户。下列哪一个 SQL语句正确表达了这一授权?

A.GRANT SELECT, INSERT ON TABLE STUDENT TO User1;
B.GRANT ALL PRIVILEGES ON TABLE STUDENT TO User1;
C.GRANT SELECT, INSERT ON TABLE STUDENT TO User1 WITH GRANT OPTION;
D.GRANT ALL PRIVII ,EGES ON TABLE STUDENT TO User1 WITH GRANT OPTION;

查看答案

正确答案： C
答案分析：无

包含此试题的试卷：

计算机四级数据库工程师模拟试题

相关的试题

CENTUMCS3000系统中,对控制回路进行操作时,如果操作方式为串级(CAS)模式,则给定值(SV)允许改变。

A.GRANT SELECT, INSERT ON TABLE STUDENT TO User1;
B.GRANT ALL PRIVILEGES ON TABLE STUDENT TO User1;
C.GRANT SELECT, INSERT ON TABLE STUDENT TO User1 WITH GRANT OPTION;
D.GRANT ALL PRIVII ,EGES ON TABLE STUDENT TO User1 WITH GRANT OPTION;

CENTUMCS3000系统中,对控制回路进行操作时,如果操作方式为自动模,则给定值(SV)允许改变。

A.GRANT SELECT, INSERT ON TABLE STUDENT TO User1;
B.GRANT ALL PRIVILEGES ON TABLE STUDENT TO User1;
C.GRANT SELECT, INSERT ON TABLE STUDENT TO User1 WITH GRANT OPTION;
D.GRANT ALL PRIVII ,EGES ON TABLE STUDENT TO User1 WITH GRANT OPTION;

POWERPOINT中插入幻灯片的操作可以在()下进行。

A.GRANT SELECT, INSERT ON TABLE STUDENT TO User1;
B.GRANT ALL PRIVILEGES ON TABLE STUDENT TO User1;
C.GRANT SELECT, INSERT ON TABLE STUDENT TO User1 WITH GRANT OPTION;
D.GRANT ALL PRIVII ,EGES ON TABLE STUDENT TO User1 WITH GRANT OPTION;

教育行政机关依照法定权限执行教育法规，对教育行政管理对象的违反教育法规行为进行改正、约束、制裁的行政活动叫作

A.GRANT SELECT, INSERT ON TABLE STUDENT TO User1;
B.GRANT ALL PRIVILEGES ON TABLE STUDENT TO User1;
C.GRANT SELECT, INSERT ON TABLE STUDENT TO User1 WITH GRANT OPTION;
D.GRANT ALL PRIVII ,EGES ON TABLE STUDENT TO User1 WITH GRANT OPTION;

在交换机中用户权限分为几个级别( )

A.GRANT SELECT, INSERT ON TABLE STUDENT TO User1;
B.GRANT ALL PRIVILEGES ON TABLE STUDENT TO User1;
C.GRANT SELECT, INSERT ON TABLE STUDENT TO User1 WITH GRANT OPTION;
D.GRANT ALL PRIVII ,EGES ON TABLE STUDENT TO User1 WITH GRANT OPTION;

( )是指软件、硬件或策略上的缺陷，这种缺陷导致非法用户未经授权而获得访问系统的权限或提高权限。

A.GRANT SELECT, INSERT ON TABLE STUDENT TO User1;
B.GRANT ALL PRIVILEGES ON TABLE STUDENT TO User1;
C.GRANT SELECT, INSERT ON TABLE STUDENT TO User1 WITH GRANT OPTION;
D.GRANT ALL PRIVII ,EGES ON TABLE STUDENT TO User1 WITH GRANT OPTION;

台式计算机在设定的等待时间内，如果用户没有进行任何操作，将启动( )。

A.GRANT SELECT, INSERT ON TABLE STUDENT TO User1;
B.GRANT ALL PRIVILEGES ON TABLE STUDENT TO User1;
C.GRANT SELECT, INSERT ON TABLE STUDENT TO User1 WITH GRANT OPTION;
D.GRANT ALL PRIVII ,EGES ON TABLE STUDENT TO User1 WITH GRANT OPTION;

基于对网络安全性的需求，网络操作系统一般采用四级安全保密机制，即注册安全，用户信任者权限，对答信任者权限屏蔽与()

A.GRANT SELECT, INSERT ON TABLE STUDENT TO User1;
B.GRANT ALL PRIVILEGES ON TABLE STUDENT TO User1;
C.GRANT SELECT, INSERT ON TABLE STUDENT TO User1 WITH GRANT OPTION;
D.GRANT ALL PRIVII ,EGES ON TABLE STUDENT TO User1 WITH GRANT OPTION;

在 SQL Server 2000 中， Userl 是销售数据库中的用户，并只被授予了销售明细表数据的删除权限，则Userl 用户在该数据库中能够执行的操作是

A.GRANT SELECT, INSERT ON TABLE STUDENT TO User1;
B.GRANT ALL PRIVILEGES ON TABLE STUDENT TO User1;
C.GRANT SELECT, INSERT ON TABLE STUDENT TO User1 WITH GRANT OPTION;
D.GRANT ALL PRIVII ,EGES ON TABLE STUDENT TO User1 WITH GRANT OPTION;

下列关于 SQL中用GRANT 语句进行权限授予的叙述中，哪一条是错误的?

A.GRANT SELECT, INSERT ON TABLE STUDENT TO User1;
B.GRANT ALL PRIVILEGES ON TABLE STUDENT TO User1;
C.GRANT SELECT, INSERT ON TABLE STUDENT TO User1 WITH GRANT OPTION;
D.GRANT ALL PRIVII ,EGES ON TABLE STUDENT TO User1 WITH GRANT OPTION;

网站内容收集于网络，如有侵犯您的权益，请联系：gl@lm158.com，感谢您的支持
神奇助手题库网