信息系统与数据库技术2023章节测试答案

A、INSERT INTO Publisher VALUES('群众出版社', '66', '0321-76584391')

B、INSERT INTO Publisher VALUES('群众出版社',66, '0321-76584391')

C、INSERT INTO Publisher VALUES('66', '群众出版社', '0321-76584391')

D、INSERT Publisher VALUES('66', '群众出版社', '0321-76584391')

我的答案：C

2、【单选题】BookStore数据库中有出版社表Publisher(PublisherCode, Publisher, Telephone) 将Publisher表中出版社代号（CustomerCode）为“01”的出版社联系电话（Telephone）修改为“010-79797979”。 SQL语句：________ 。

A、UPDATE Publisher SET Telephone =010-79797979 WHERE PublisherCode =01

B、UPDATE Publisher SET Telephone ='010-79797979' WHERE PublisherCode ='01'

C、UPDATE FROM Publisher SET Telephone ='010-79797979' WHERE PublisherCode ='01'

D、UPDATE Publisher Telephone ='010-79797979' WHERE PublisherCode ='01'

我的答案：B

3、【单选题】BookStore数据库中有出版社表Publisher(PublisherCode, Publisher, Telephone) 从Publisher表删除“群众出版社”。SQL语句：________ 。

A、DELETE Publisher WHERE Publisher='群众出版社'

B、DELETE FROM Publisher WHERE Publisher='群众出版社'

C、DELETE FROM Publisher WHERE Publisher=群众出版社

D、DELETE Publisher WHERE Publisher=群众出版社

我的答案：B

4、【多选题】BookStore数据库中有销售明细表OrderDetail(OrderCode, BookCode, Amount) 在OrderDetail表中添加一条记录：“08110801”、0701、3。SQL语句：________ 。

A、INSERT INTO OrderDetail(OrderCode, Amount, BookCode) VALUES('08110801',3, '0701')

B、INSERT INTO OrderDetail(OrderCode, Amount, BookCode) VALUES('08110801', '0701', 3)

C、INSERT INTO OrderDetail(OrderCode, BookCode, Amount) VALUES('08110801', '0701', 3)

D、INSERT INTO OrderDetail VALUES('08110801', '0701', 3)

我的答案：ACD

5、【多选题】BookStore数据库中有图书表Book(BookCode, BookName, Author, PublisherCode, PublishTime，BookSort, ISBN, BookPicture, ContentInro, Price, Discount)，其中 PublishTime是datetime类型。 将Book表中的所有“外语”类图书的价格降低10%，并将折扣均设为8折。SQL语句： UPDATE Book SET ________ Where BookSort ='外语'。

A、Price=Price*0.9,Discount=0.8

B、Price=Price*(1-10%),Discount=0.8

C、Price=0.9, Discount=0.8

D、Discount=0.8, Price=Price*0.9

我的答案：ABD

6、【多选题】BookStore数据库中有客户表Customer(CustomerCode, Name, Sex, Hometown, Email, Telephone, LoginDate, Password) 删除Customer表中姓“刘”和姓“杨”的记录。SQL语句： DELETE FROM Customer WHERE ________ 。

★《布宫号》提醒您：民俗信仰仅供参考，请勿过度迷信！