The university welcomes _____（） from overseas students.

在学生表STUD中查询所有姓张的学生的信息，使用的SQL语句是______。

A．SELECT * FROM STUD WHERE 姓名LIKE“张％”

B．SELECT * FROM STUD WHERE 姓名IN(“张％”)

C．SELECT * FROM STUD WHERE 姓名LIKE“张$”

D．SELECT * FROM STUD WHERE 姓名IN(“张$)”

在学生表STUD中查询所有姓张的学生的信息，使用的SQL语句是______。

A．SELECT*FROM STUD WHERE 姓名 LIKE"张%”

B．SELECT*FROM STUD WHERE 姓名 IN("张%")

C．SELECT*FROM STUD WHERE 姓名 LIKE"张$"

D．SELECT*FROM STUD WHERE 姓名 IN"张$)"

A．A.SELECT * FROM stud ORDER BY birthday DESC LIMIT 8;

B．B.SELECT * FROM stud ORDER BY birthday ASC LIMIT 8;

C．C.SELECT * FROM stud ORDER BY birthday ASC LIMIT 7;

D．D.SELECT * FROM stud ORDER BY birthday DESC LIMIT 7;

This college welcomes students from all over the world.

A．receives

B．accepts

C．holds

D．chooses

实现“取消用户USER4对学生表STUD中学号(XH)的修改权限”这一功能的SQL语句是()。

A．REVOKE UPDATE (XH) ON TABLE FROM USER4;

B．REVOKE UPDATE (XH) ON TABLE STUD FROM PUBLIC ;

C．REVOKE UPDATE (XH) ON TABLE STUD FROM USER4;

D．REVOKE ALL PRIVILEGES ON TABLE STUD FROM USER4;