胃食管返流病的常见并发症有

补充语句，把对Student表和Course表的全部操作权限授予用户U1和U2：

GRANT______

ON TABLE Student，Course

TO U1，U2

A.把查询Student表权限授给用户U1GRANT SELECTON TABLE StudentTO U1

B.把对表SC的查询权限授予所有用户GRANT SELECT ON TABLE SCTO PUBLIC

C.把对Student表和Course表的全部权限授予用户U2和U3GRANT ALL PRIVILIGESON TABLE Student, Course TO U2,U3

D.把查询Student表和修改学生学号的权限授给用户U4GRANT UPDATE, SELECTON TABLE StudentTO U4

“把查询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

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;

（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

A、GRANT INSERT on Orders

B、GRANT INSERT to user1

C、GRANT INSERT to Orders on user1

D、GRANT INSERT on Orders to user1

A．GRANTSELECT，INSERTONTABLESTUDENTTOUser1WITHGRANTOPTION

B．GRANTSELECT，INSERTONTABLESTUDENTTOUser1

C．GRANTALLPRIVILEGESONTABLESTUDENTTOUser1

D．GRANTALLPRIVILEGESONTABLESTUDENTTOUser1WITHGRANTOPTION

“把查询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

B、SELECT*FROMtbl_studentORDERBYstu_idDESC;

C、SELECT*FROMtbl_studentstu_idORDERBYASC;

D、SELECT*FROMtbl_studentstu_idORDERBYDESC;

B、INSERT…SELECT语句

C、INSERT…WHERE语句

D、INSERT…SET语句