网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
BookStore数据库中有出版社表从Publisher表删除“群众出版社”。SQL语句：（）
- A、DELET Epublisher WHERE Publisher=‘群众出版社’
- B、DELETE FROM Publisher WHERE Publisher=‘群众出版社’
- C、DELETE FROM Publisher WHERE Publisher=群众出版社
- D、DELETE Publisher WHERE Publisher=群众出版社
参考答案
更多 “BookStore数据库中有出版社表从Publisher表删除“群众出版社”。SQL语句：（）A、DELET Epublisher WHERE Publisher=‘群众出版社’B、DELETE FROM Publisher WHERE Publisher=‘群众出版社’C、DELETE FROM Publisher WHERE Publisher=群众出版社D、DELETE Publisher WHERE Publisher=群众出版社” 相关考题
考题
从订单表中删除客户号为"1001”的订单记录，正确的SQL语句是A）DROP FROM订单WHERE客户号="1001"B）DROP FROM订单FOR客户号="1001"C）DELETE FROM订单WHERE客户号="1001"D）DELETE FROM订单FOR客户号="1001"
考题
The only thing I have is this bill()the publisher’s name and addressA、 with…onB、 by…inC、 in…on
考题
查询2011年被借过图书的书名、出版社和借书日期，正确的SQL语句是( )。A.SELECT书名，出版社，借书日期FROM图书，借书记录 WHERE借书日期=2011 AND图书．索书号=借书记录．索书号B.SELECT书名，出版社，借书日期FROM图书，借书记录 WHERE借书日期=YEAR(2011)AND图书．索书号=借书记录．索书号C.SELECT书名，出版社，借书日期FROM图书，借书记录 WHERE图书．索书号=借书记录．索书号AND YEAR(借书日期)=2011D.SELECT书名，出版社，借书日期FROM图书，借书记录 图书．索书号=借书记录．索书号AND WHERE YEAR(借书日期)=YEAR(2011)
考题
对于图书管理数据库，检索藏书中比高等教育出版社的所有图书的书价更高的书，下面SQL语句正确的是______。 SELECT*FROM 图书 WHERE 单价＞ALL；A．SELECT 书名 FROM 图书 WHERE 出版单位="高等教育出版社"B．(SELECT 单价 FROM 图书 WHERE 出版单位="高等教育出版社")C．SELECT 单价 FROM 图书 WHERE 读者.借书证号=借阅.借书证号D．(SELECT 书名 FROM 图书 WHERE 读者.借书证号=借阅.借书证号)
考题
设有学生表：STUD(学号，姓名，性别，年龄，专业)，将学号为“20030019”的学生从该表中删除掉的语句是______。A．DELETE STUD WHERE学号="20030019"B．DELETE FROM STUD WHERE学号="20030019"C．DELETE TABLE STUD WHERE学号="20030019"D．DELETE FROM WHERE 学号="20030019"
考题
You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will serve as Publisher and Distributor for a minimum of 40 Subscribers.Currently, you want to publish 3GB of data, but the data is expected to grow over time. Subscribers will receive a new snapshot each month.You want to minimize the workload on the Publisher/Distributor. Which two actions should you take to configure snapshot replication? (Each correct answer presents part of the solution. Choose two)A．Store the snapshot in the default folder on the Publisher/Distributor.B．Store the snapshot in an alternative folder on the Publisher/Distributor.C．Store the snapshot in a shared folder on a file server.D．Create pull subscriptions.E．Create push subscriptions.
考题
设有学生表：STUD(学号，姓名，性别，年龄，专业)，把学号为“20030019”的学生从该表中删除掉的语句是______。A．DELETE STUD WHERE 学号＝“20030019”B．DELETE FROM STUDWHERE学号＝“20030019”C．DELETE TABLE STUD WHERE学号＝“20030019”D．DELETE FROM WHERE 学号＝“20030019”
考题
BookStore数据库中有出版社表在Publisher表中添加一条记录：“66”、“群众出版社”、“0321-76584391”。SQL语句：（）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’）
考题
BookStore数据库中有出版社表将Publisher表中出版社代号（CustomerCode）为“01”的出版社联系电话（Telephone）修改为“010-79797979”。SQL语句：（）A、UPDATE PublisherSET Telephone=010-79797979 WHERE PublisherCode=01B、UPDATE PublisherSET Telephone=‘010-79797979’ WHERE PublisherCode=‘01’C、UPDATE FROMPublisher SET Telephone=‘010-79797979’ WHERE PublisherCode=‘01’D、UPDATE Publisher Telephone=‘010-79797979’ WHERE PublisherCode=‘01
考题
在Access中，从"订单"数据表中删除订单ID为"A10257"的记录，应运行的SQL命令是（）A、delete*from订单where订单ID="A10257"B、delete*from订单where订单ID=A10257C、delete*from订单ID where订单="A10257"D、delete*from订单ID where订单=A10257
考题
删除“职工”表中没有写入工资的记录，应该使用的命令是（）。A、DELETE FROM职工WHERE工资=NULLB、DELETE FROM职工WHERE工资=!NULLC、DELETE FROM职工WHERE工资IS NOT NULL
考题
Where do you enable the CRS engine?（）A、Publisher Activation page B、Component Activation page C、Cluster Setup page D、Server Setup page
考题
What two things happen when the CRS Publisher Database on an HRDB expansion server fails?（）A、All call processing immediately begins using the CRS Subscriber Database. B、Calls in queue are dropped. C、Agent calls are dropped. D、Agents are automatically logged out. E、CRS configuration changes are blocked until the CRS Publisher Database is restored and synchronized with the CRS Subscriber Database. F、Configuration changes are buffered until the CRS Publisher Database is restored.
考题
The JTAPI provider is the IP address of the（）.A、publisher B、CTI Manager C、CallManager D、CRS Server
考题
已知图书管理系统包含一张图书表，其模式为：图书表（书号，书名，出版社，作者，馆藏册数）。要查找借阅书号为“B001”的书名、作者和出版社，可用SQL语句：SELECT 书名，作者，出版社 FROM（）WHERE 书号="B001"。
考题
已知图书管理系统包含1张图书关系表，其模式为：图书表（书号，书名，出版社，作者，馆藏册数）。要查找书号为“B002”的图书的书名、出版社、作者和馆藏册数，可用SQL语句：SELECT书名，出版社，作者，馆藏册数FROM图书表WHERE（）
考题
An on-premise .NET application uses an on-premise Microsoft SQL Server 2008 database. The existing compute infrastructure is insufficient to support peak loads. You plan to move only the compute-intensive component of the application into Windows Azure. The component requires access to the on-premise database. The on-premise database cannot be accessed from outside the network boundary. You need to recommend a database topology. What should you recommend？（）A、 Use SQL Azure for the on-premise components and the compute-intensive component.B、 Configure merge replication with the on-premise database as publisher and the SQL Azure database as subscriber.C、 Configure snapshot replication with the on-premise database as publisher and the SQL Azure database assubscriber.D、 Configure snapshot replication with the SQL Azuredatabase as publisher and the on-premise database as subscriber.
考题
单选题The author is required to _____ his book and send it to the publisher as soon as possible.A
ventureB
abstractC
verifyD
index
考题
单选题查询所有借阅过“中国出版社”图书的读者的姓名和所在单位的SQL语句是（ ）。A
SELECT姓名，所在单位FROM借书证，图书，借书记录WHERE图书.索书号=借书记录.索书号AND借书证.借书证号=借书记录．借书证号AND出版社=中国出版社B
SELECT姓名，所在单位FROM图书，借书证WHERE图书.索书号=借书证.借书证号AND出版社=中国出版社C
SELECT姓名，所在单位FROM图书，借书记录WHERE图书.索书号=借书记录.索书号AND出版社=中国出版社D
SELECT姓名，所在单位FROM借书证，借书记录WHERE借书证.借书证号=借书记录.借书证号AND出版社=中国出版社
考题
单选题BookStore数据库中有出版社表在Publisher表中添加一条记录：“66”、“群众出版社”、“0321-76584391”。SQL语句：（）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’）
考题
多选题What two things happen when the CRS Publisher Database on an HRDB expansion server fails?（）AAll call processing immediately begins using the CRS Subscriber Database.BCalls in queue are dropped.CAgent calls are dropped.DAgents are automatically logged out.ECRS configuration changes are blocked until the CRS Publisher Database is restored and synchronized with the CRS Subscriber Database.FConfiguration changes are buffered until the CRS Publisher Database is restored.
考题
填空题已知图书管理系统包含1张图书关系表，其模式为：图书表（书号，书名，出版社，作者，馆藏册数）。要查找书号为“B002”的图书的书名、出版社、作者和馆藏册数，可用SQL语句：SELECT书名，出版社，作者，馆藏册数FROM图书表WHERE（）
考题
单选题BookStore数据库中有出版社表将Publisher表中出版社代号（CustomerCode）为“01”的出版社联系电话（Telephone）修改为“010-79797979”。SQL语句：（）A
UPDATE PublisherSET Telephone=010-79797979 WHERE PublisherCode=01B
UPDATE PublisherSET Telephone=‘010-79797979’ WHERE PublisherCode=‘01’C
UPDATE FROMPublisher SET Telephone=‘010-79797979’ WHERE PublisherCode=‘01’D
UPDATE Publisher Telephone=‘010-79797979’ WHERE PublisherCode=‘01
考题
单选题查询第一作者为“张三”的所有书名及出版社，正确的SQL语句是（ ）。A
SELECT书名，出版社FROM图书WHERE第一作者=张三B
SELECT书名，出版社FROM图书WHERE第一作者=张三C
SELECT书名，出版社FROM图书WHERE第一作者=张三D
SELECT书名，出版社FROM图书WHERE第一作者=张三
考题
单选题查询主编为“章平”的所有图书的书名和出版社，正确的SQL语句是（ ）。A
SELECT书名，出版社FROM图书WHERE主编=“章平”B
SELECT书名，出版社FROM图书WHERE主编=章平C
SELECT书名，出版社FROM图书WHERE“主编”=“章平”D
SELECT书名，出版社FROM图书WHERE“主编”=章平
考题
单选题BookStore数据库中有出版社表从Publisher表删除“群众出版社”。SQL语句：（）A
DELET Epublisher WHERE Publisher=‘群众出版社’B
DELETE FROM Publisher WHERE Publisher=‘群众出版社’C
DELETE FROM Publisher WHERE Publisher=群众出版社D
DELETE Publisher WHERE Publisher=群众出版社
考题
填空题已知图书管理系统包含一张图书表，其模式为：图书表（书号，书名，出版社，作者，馆藏册数）。要查找借阅书号为“B001”的书名、作者和出版社，可用SQL语句：SELECT 书名，作者，出版社 FROM（）WHERE 书号="B001"。
热门标签
最新试卷
