问题 填空题

对于图书管理数据库,将图书表中“人民邮电出版社”的图书的单价涨价5%。请对下面的SQL语句填空:
UPDATE 图书______WHERE出版单位=“人民邮电出版社”

答案

参考答案:SET 单价=单价*1.05

解析: 更新表中元组的值,使用UPDATE命令,一次可以更新表中的一个或多个属性值。UPDATE短语之后指定更新数据所属的表,将新的属性值或表达式赋值给对应的属性名(SET单价=单价*1.05) ,并置于SET短语之后。要求对人民邮电出版社的图幅涨5%,需要用WHERE短语对元组进行限制,即对符合条件的元组进行更新。

阅读理解

阅读理解。

     The Wizarding World of Harry Potter theme park will open in Florida in 2009, and will provide attractions

and rides based on places from the Harry Potter books.

     The novels' author JK Rowling has already given her blessing to the project. She said, "The plans I've seen

look unbelievably exciting, and I don't think fans of the books or films will be disappointed."

     Stuart Craig, the man in charge of the design of the park, is an Oscar-winning production designer who

worked on the Harry Potter films so it should be faithful (忠实的) to JK Rowling's vision.

     Stuart Craig said, "Our primary goal is to make sure this expenence is an authentic extension (原著的延伸)

of Harry Potter's world as it is portrayed in the books and films."

     Visitors to the park will be able to explore some of their favourite places from the book such as the village

of Hogsmeade, the Forbidden Forest and, of course, Hogwarts Castle, where Harry goes to school.

     Although fans can look forward to a holiday in the Harry Potter theme park,many will be saddened by the

fact that the best-selling series is now drawing to a close.

     The final instalment (分期连载的一部分)in the series, Harry Potter and the Deathly Hallows, will be

published on 21 July, and to mark the event JK Rowling is to read extracts (摘录) from the book to a select

audience at midnight on the day of publication.

     Rawling has announced that two characters die in the final book, but has not revealed (透露) if Harry is

one of them so fans will have to wait to find out the fate of their magical hero.

1. What's the passage mainly about?

A. A new book about Harry Potter.

B. A theme park about Harry Potter.

C. What people will see in the theme park.

D. Something about Harry Potter.

2. What will people see in the theme park?

A. Some of the places in the book.

B. Harry Potter and most of the characters.

C. How film Harry Potter was made.

D. The ending part of the magical story.

3. What's meaning of the underlined word "portrayed" mean in the fourth paragraph?

A. Explore.

B. Sadden.

C. Describe.

D. Open.

4. What's the novel's author JK Rowling's attitude to the theme park? 

A. Not as good as the book.

B. It will be well received.

C. Not satisfied with the places shown in the park.

D. Saddened.

单项选择题