下列哪个语句将赋予用户John向表tab1中插入数据的权限?()
第1题:
●将Students表的插入权限赋予用户UserA,并允许其将该权限授予他人,应使用的SQL语句为:
GRANT(51) TABLE Students TO UserA (52) ;
(51)
A.UPDATE
B.UPDATEON
C.INSERT
D.INSERT ON
(52)
A.FORALL
B.PUBLIC
C. WITH CHECK OPTION
D.WITH GRANT OPTION
第2题:
●将表employee中name列的修改权限赋予用户Liu,并允许其将该权限授予他人,应使用的SQL语句为:
GRANT (52) ON TABLE employee TO Liu (53) ;
(52)
A.UPDATE(name)
B.DELETE
C.SELECT
D.INSERT
(53)
A.FORALL
B.CASCADE
C. WITH GRANT OPTION
D.WITH CHECK OPTION
第3题:
( 35 ) “ 把查询 sc 表和更新 sc 表的 grade 列的权限授予用户 user1 ” 的正确 SQL 语句是
A ) GRANT SELECT , UPDATE ( grade ) ON TABLE sc TO user1
B ) GRANT SELECT sc , UPDATE sc . grade TO user1
C ) GRANT SELECT , UPDATE ON TABLE sc . grade TO user1
D ) GRANT SELECT ON TABLE sc , UPDATE ON TABLE sc(grade) TO user1
第4题:
A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp
B.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1
C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp
D.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
第5题:
把查询SC表的权限授予用户U1,并允许该用户再将此权限授予其他用户。实现此功能的正确SQL语句是______。
A.GRANT SELECT TO TABLE SC ON U1 WITH PUBLIC
B.GRANT SELECT ON TABLE SC TO U1 WITH PUBLIC
C.GRANT SELECT TO TABLE SC ON U1 WITH GRANT OPTION
D.GRANT SELECT ON TABLE SC TO U1 WITH GRANT OPTION
第6题:
“把查询sc表和更新sc表的grade列的权限授予用户user1”的正确SQL语句是( )。
A.GRANT SELECT,UPDATE(grade)ON TABLE sc TO user1
B.GRANT SELECT sc,UPDATE sc.grade TO user1
C.GRANT SELECT,UPDATE ON TABLE sc.grade TO used
D.GRANT SELECT ON TABLE sc,UPDATE ON TABLE sc(grade) TO user1
第7题:
● 将Students表的插入权限赋予用户UserA,并允许其将该权限授予他人,应使用的SQL语句为:
GRANT (15)TABLE Students TO UserA (16) ;
(15)
A.UPDATE
B.UPDATE ON
C.INSERT
D.INSERT ON
(16)
A.FOR ALL
B.PUBLIC
C.WITH CHECK OPTION
D.WITH GRANT OPTION
第8题:
“把查询SC表和更新SC表的9rade列的权限受予用户userl”的正确SQL语句是( )。
A) GRANT SELECT, UPDATE (grade) ON TABLE sc TO userl
B) GRANT SELECT so,UPDATE sc,grade TO userl
C) GRANT SELECT, UPDATE ON TABLE sc.grade TO userl
D) GRANT SELECT ON TABLE sc, UPDATE ON TABLE sc (grade)TO userl
第9题:
将查询SC表的权限授予用户U1,并允许该用户再将此权限授予其他用户。实现此功能的正确SQL语句是______。
A.GRANT SELECT TO TABLE SC ON U1 WITH PUBLIC
B.GRANT SELECT ON TABLE SC TO U1 WITH PUBLIC
C.GRANT SELECT TO TABLE SC ON U1 WITH GRANT OPTION
D.GRANT SELECT ON TABLE SC TO U1 WITH GRANT OPTION
第10题:
Given the following statements:CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3);What is the result of the following query? SELECT count(*) FROM tab2;()
A.3
B.2
C.1
D.0