网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
授予删除任何表的系统权限（DROP ANY TABLE）给user1，并使其能继续授该权限给其他用户，以下正确的SQL语句是（）
- A、Grant drop any table to user1
- B、Grant drop any table to user1 with admin option
- C、Grant drop table to user1
- D、Grant drop any table to user1 with check potion
参考答案
更多 “授予删除任何表的系统权限（DROP ANY TABLE）给user1，并使其能继续授该权限给其他用户，以下正确的SQL语句是（）A、Grant drop any table to user1B、Grant drop any table to user1 with admin optionC、Grant drop table to user1D、Grant drop any table to user1 with check potion” 相关考题
考题
（ 35 ） “ 把查询 sc 表和更新 sc 表的 grade 列的权限授予用户 user1 ” 的正确 SQL 语句是A ） GRANT SELECT ， UPDATE （ grade ） ON TABLE sc TO user1B ） GRANT SELECT sc ， UPDATE sc . grade TO user1C ） GRANT SELECT ， UPDATE ON TABLE sc . grade TO user1D ） GRANT SELECT ON TABLE sc ， UPDATE ON TABLE sc(grade) TO user1
考题
将Students表的查询权限授予用户U1和U2，并允许该用户将此权限授予其他用户。实现此功能的SQL语句如下（ ）。A.GRANT SELECT TO TABLE Students ON U1，U2 WITH PUBLIC B.GRANT SELECT ON TABLE Students TO U1，U2 WITH PUBLIC C.GRANT SELECT TO TABLE Students ON U1，U2 WITH GRANT OPTION D.GRANT SELECT ON TABLE Students TO U1，U2 WITH GRANT OPTION
考题
“把查询SC表和更新SC表的9rade列的权限受予用户userl”的正确SQL语句是（ ）。A) GRANT SELECT, UPDATE (grade) ON TABLE sc TO userlB) GRANT SELECT so,UPDATE sc,grade TO userlC) GRANT SELECT, UPDATE ON TABLE sc.grade TO userlD) GRANT SELECT ON TABLE sc, UPDATE ON TABLE sc (grade)TO userl
考题
把表中"单价"字段的有效性规则取消,使用SQL语句A．ALTER TABLE ORDER ALTER 单价 DROP CHECKB．ALTER TABLE ORDER DELETE 单价 DROP CHECKC．ALTER TABLE ORDER DELETE CHECK 单价D．ALTER TABLE ORDER DROP CHECK 单价
考题
找出正确的叙述()A DROP TABLE表示删除表的定义B DELETE FROM TABLE表示删除表的定义C DROP TABLE 等于DELETE FROM TABLED DROP TABLE属于数据操纵语言
考题
根据SQL标准，删除表student中对字段sno的唯一性约束，应该使用下面哪条语句? ()A drop sno from table studentB alter table student drop snoC alter table student drop unique(sno)D alter table student drop sno unique
考题
把表中“学历”字段的有效性规则取消，正确的SQL语句是（ ）。A.ALTER TABLE学生ALTER学历DROP CHECKB.ALTER TABLE学生DELETE学历DROP CHECKC.ALTER TABLE学生DELETE CHECK学历D.ALTER TABLE学生DROP CHECK学历
考题
“把查询sc表和更新sc表的grade列的权限受予用户user1”的正确SQL语句是______。A．GRANT SELECT, UPDATE(grade)ON TABLE sc TO user1B．GRANT SELECT sc, UPDATE sc, grade TO user1C．GRANT SELECT, UPDATE ON TABLE sC.grade TO user1D．GRANT SELECT ON TABLE sc, UPDATE ON TABLE sc(grade) TO user1
考题
“把查询sc表和更新sc表的grade列的权限授予用户user1”的正确SQL语句是（ ）。A．GRANT SELECT，UPDATE（grade）ON TABLE sc TO user1B．GRANT SELECT sc，UPDATE sc．grade TO user1C．GRANT SELECT，UPDATE ON TABLE sc．grade TO usedD．GRANT SELECT ON TABLE sc，UPDATE ON TABLE sc(grade) TO user1
考题
把查询SC表的权限授予用户U1，并允许该用户再将此权限授予其他用户。实现此功能的正确SQL语句是______。A．GRANT SELECT TO TABLE SC ON U1 WITH PUBLICB．GRANT SELECT ON TABLE SC TO U1 WITH PUBLICC．GRANT SELECT TO TABLE SC ON U1 WITH GRANT OPTIOND．GRANT SELECT ON TABLE SC TO U1 WITH GRANT OPTION
考题
假设在数据库中创建了用户test,需要为其授予CREATE ANY TABLE系统权限,可以使用如下()语句。
A.GRANT CREATE ANY TABLE testB.GRANT CREATE ANY TABLE TO testC.TAKE CREATE ANY TABLE TO testD.ALTER CREATE ANY TABLE TO test
考题
“把查询sc表和更新sc表的grade列的权限授予用户user”的正确SQL语句是（ ）。A）GRANT SELECT sc，UP DATE sc．Grade TO userB）GRANT SELECT,UP DATE (grade) ON TABLE sc TO userC）GRANT SELECT,UP DATE ON TABLE sc．Grade TO userD）GRANT SELECT ON TABLE sc，UP DATE ON TABLE sc(grade) TO user
考题
若将Workers表的插入权限赋予用户User1，并允许其将该权限授予他人，那么对应的SQL语句为“GRANT（ ）TABLE Workers TO User1（请作答此空）；”。A.FOR ALL
B.PUBLIC
C.WITH CHECK OPTION
D.WITH GRANT OPTION
考题
若将Workers表的插入权限赋予用户User1，并允许其将该权限授予他人，那么对应的SQL语句为“GRANT（请作答此空）TABLE Workers TO User1（ ）；”。A.INSERT
B.INSERT ON
C.UPDATE
D.UPDATE ON
考题
将Students表的查询权限授予用户U1和U2，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是：（ ）。A.GRANT SELECT TO TABLE Students ON U1,U2 WITH PUBLIC;
B.GRANT SELECT ON TABLE Students TO U1,U2 WITH PUBLIC;
C.GRANT SELECT TO TABLE Students ON U1,U2 WITH GRANT OPTION;
D.GRANT SELECT ON TABLE Students TO U1,U2 WITH GRANT OPTION;
考题
“把查询sc表和更新sc表的grade列的权限受予用户user1”的正确SQL语句是（）。A、GRANT SELECT，UPDATE（grade）ON TABLE sc TOuser1B、GRANT SELECT sc，UPDATE sc，grade TO user1C、GRANT SELECT，UPDATE ON TABLE sc.grade TO user1D、GRANT SELECT ON TABLE sc，UPDATE ON TABLE sc（grade）TO user1
考题
下面哪些SQL命令向名为ACCTSUPER的用户授予系统权限（）A、GRANT INSERT ON emp TO acctsuperB、GRANT CREATE TABLE TO acctsuperC、GRANT SELECT ON emp TO acctsuperD、GRANT UPDATE ANY TABLE TO acctsuperE、GRANT CREATE SESSION TO acctsuper
考题
You execute the following command to audit database activities： SQL AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A、One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.E、One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT
考题
假设在数据库中创建了用户test，需要为其授予CREATE ANY TABLE系统权限，可以使用如下（）语句。A、GRANT CREATE ANY TABLE testB、GRANT CREATE ANY TABLE TO testC、TAKE CREATE ANY TABLE TO testD、ALTER CREATE ANY TABLE TO test
考题
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.
考题
You execute the following command toauditdatabase activities： SQLAUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A、Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.B、Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.C、One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.E、One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
考题
假设需要删除Customer表中的LogoutTime列，可以使用如下（）方式。A、ALTER TABLE CUSTOMER DROP column LOGOUTTIMEB、UPDATE TABLE DROP column LOGOUTTIMEC、ALTER TABLE CUSTOMER DROP LOGOUTTIMED、UPDATE TABLE DROP LOGOUTTIME
考题
单选题执行下列 SQL 语句之后： GRANT ALL PRIVILEGES ON TABLE student TO USER user1 假设用户USER1没有其他权限，下列哪一项操作是USER1可以执行的？（）A
将表STUDENT的所有权限赋予其他用户B
删除关联到表STUDENT的视图C
删除表STUDENTD
以上都不是
热门标签
最新试卷