问题 单项选择题

用户对 SQL 数据库的访问权限中,如果只允许删除基本表的元组,应授予______权 限。

A.DROP

B.DELETE

C.ALTER

D.UPDATE 下面第(34)至(36)题。基于“学生—选课—课程”数据库中的三个关系: S(S#,SNAME,SEX,DEPARTMENT),主码是 S# C(C#,CNAME,TEACHER),主码是 C# SC(S#,C#,GRADE),主码是(S#,C#)

答案

参考答案:B

解析:DELETE指从表中删除满足条件的记录,DELETE语句删除的是表中的数据,而不是表的定义。当某 个基本表不再需要时,可以使用DROP语句进行删除。

填空题

语法填空

阅读下面短文, 按照句子结构的语法性和上下文连贯的要求, 在空格处填入一个适当的

词或使用括号中词语的正确形式填空.

     He has a typical flattop haircut and speaks with a slight Beijing accent.He says he is an ordinary

teacher, just one __1__ 2,500 other history teachers in the city.The history teacher has gone from a

nobody in a Beijing high school to a headliner(新闻人物)in newspapers and on the Internet across the

country with __2__(believe)speed.He is now known as "the greatest history teacher in history".

     It didn't happen overnight.Last summer, videos of his lectures __3__(upload) to the Internet and

viewed over 10 million times __4__ three months.A little while later. his lectures for CCTV's famous

"Lecture Room"(《百家讲坛》)won __5__ recordhigh audiences.Yuan's sense of humor is a very

__6__(appeal)feature of his style.

     Young people also admire him for his nonmainstream(非主流的)points of view on many issues.

For instance. unlike many teachers. he is satisfied __7__ a student scores only 60 percent on a history

test.

     "History is something like literature to enjoy in your leisure time.You don't need to know about Qin

Shihuang if you're a programming major.But it's never too late to become interested in history.Even

__8__ 70yearold can start. "Yuan said.

     Yuan argues that he is __9__ different from other history teachers.He also spends most of his time

preparing his students for tests.Yet the talented teacher has the rare ability to bring the history in dull

textbooks to life in __10__ he calls "plain Chinese".

问答题