网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
BookStore数据库中有客户表Customer(CustomerCode,Name,Sex,Hometown,Email,Telephone,LoginDate,Password)查询Customer表中所有客户的信息,SQL语句:SELECT()FROMCustomer
A

*

B

CustomerCode,Name,Hometown,Sex,Email,Telephone,LoginTime,PassWord

C

CustomerCode,Hometown,Telephone,Name,Sex,Email,LoginTime,PassWord

D

CustomerCode~PassWord


参考答案

参考解析
解析: 暂无解析
更多 “多选题BookStore数据库中有客户表Customer(CustomerCode,Name,Sex,Hometown,Email,Telephone,LoginDate,Password)查询Customer表中所有客户的信息,SQL语句:SELECT()FROMCustomerA*BCustomerCode,Name,Hometown,Sex,Email,Telephone,LoginTime,PassWordCCustomerCode,Hometown,Telephone,Name,Sex,Email,LoginTime,PassWordDCustomerCode~PassWord” 相关考题
考题 假设需要给某个客户表Customer添加注释信息:客户表,可以使用如下()方式 A.COMMENTONTABLECUSTOMERIS'客户表'B.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAMEIS'客户表'C.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAME'客户表'D.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAME'客户表'

考题 假设需要给某个客户表Customer的Customer_name列添加注释信息:客户姓名,可以使用如下()方式 A.COMMENTONTABLECUSTOMERIS'客户姓名'B.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAMEIS'客户姓名'C.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAME'客户姓名'D.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAME'客户姓名'

考题 学生表(id,name,sex,age,depart_id,depart_name),存在的函数依赖是id→{name,sex,age,depart_id};dept_id→dept_name,其满足()、 A、1NFB、2NFC、3NFD、4NF

考题 学生表(id,name,sex,age,depart_id,depart_name),存在函数依赖是id→name,sex,age,depart_id;dept_id→dept_name,其满足()。 A、1NFB、2NFC、3NFD、BCNF

考题 某数据库表中有一个Name字段,查找Name不为空的记录的准则可以设置为( )。A.NotNullB.IsNotNullC.Betweenoand64D.Null

考题 某数据库表中有一个Name字段,查找Name不为空的记录的准则可以设置为( )。A.Not NullB.Is Not NullC.Between 0 and 64D.Null

考题 BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime查询作者名长度大于等于8的图书信息,显示书名(BookName)及作者(Author)。SQL语句:SELECTBookName,AuthorFROMBookWHERELenth(Author)=8

考题 下面的XML片断中结构完整的是()。A、<customer name=”<xml>.con”><address>123 MainStreet></address></customer>B、<customer><name>Joe’s XML Works</name><address>New York</costomer>C、< customer type=extemal><name>Partners Unlimited</name></customer>D、<customer name=”John Doe”><address>123 Main Street</address> <zip code=”01837”/></customer>

考题 BookStore数据库中有客户表Customer(CustomerCode,Name,Sex,Hometown,Email,Telephone,LoginDate,Password)查询Customer表中所有客户的信息,要求显示CustomerCode、Name、Hometown和Telephone字段信息。SQL语句:SELECT()FROM CustomerA、*B、ALLC、CustomerCode、Name、Hometown、TelephoneD、CustomerCode,Name,Hometown,Telephone

考题 BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime,PublishTime是datetime类型。查询Book表中的图书类别(BookSort),要求每个类别只显示一次。SQL语句:SELECT()BookSort FROM BookA、DISTINCTB、ONLYC、ONED、PERCENT

考题 BookStore数据库中有客户表Customer(CustomerCode,Name,Sex,Hometown,Email,Telephone,LoginDate,Password)删除Customer表中姓“刘”和姓“杨”的记录。SQL语句:DELETE FROMCustomer WHERE()A、LEFT(Name,1)=‘刘’ORLEFT(Name,1)=‘杨’B、NameLIKE‘刘%‘ORNameLIKE杨%‘C、NameLIKE‘[刘,杨]%‘D、NameLIKE‘[^刘,^杨]%

考题 BookStore数据库中有客户表Customer(CustomerCode,Name,Sex,Hometown,Email,Telephone,LoginDate,Password)查询Customer表中所有客户的信息,SQL语句:SELECT()FROMCustomerA、*B、CustomerCode,Name,Hometown,Sex,Email,Telephone,LoginTime,PassWordC、CustomerCode,Hometown,Telephone,Name,Sex,Email,LoginTime,PassWordD、CustomerCode~PassWord

考题 BookStore数据库中有客户评价表CustomerEvaluation(CustomerCode,VIPClass,Author,EvaluateDate),其中PublishTime是datetime类型。查询用户等级(VIPClass)为“A”的客户编号(CustomerCode)和评价时间(EvaluateDate),要求显示标题分别为“客户编号”和“评价时间”。SQL语句:SELECT Customer CodeAs客户编号,Evaluate DateAs评价时间FROM Customer Evaluation WHERE()A、VIPClass=‘A’B、VIPClass=”A”C、VIPClass=AD、VIPClass==A

考题 BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime查询图书名称(BookName)含有“程序”的图书信息。SQL语句:SELECTBookCode,BookName,Author,Price,DiscountFROMBookWHEREName=“%程序%”

考题 BookStore数据库中有订单表Order(OrderCode,CustomerCode,TotalPrice,Address,OrderTime,OrderStatus)SELECTTOP3OrderCode,OrderTime,OrderStatusFROM[Order]语句中TOP3的含义是()A、前3个字段B、前3条属性C、前3个记录D、前3个别名

考题 数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求写SQL语句查询出表中所有的数据,下列哪个SQL语句是正确的()A、Select* From StudentB、Select Name From StudentC、Select Name,Age,IDCard From StudentD、Select Name,Age,IDCard,Sex From Student

考题 数据库中有一张表名称为Student,有列Number,Name,Age,IDCard,Sex。主键为Number。要求查询所有男同学信息,下列哪个SQL语句是正确的?()A、Select* From Student Where Sex=’男’B、Select* From Student Where Number NotIn(Select Number From Student Where Sex=’男’)C、Select* From Student Where NumberIn(Select Numbe rFrom Student Where Sex=’男’)D、Select* From Student Where Sex’男’

考题 数据库中有一张表名称为Student,有列Number,Name,Age,IDCard,Sex。主键是Number,数据类型为Varchar(20)。要求写删除学号为“20140001”的学生,下列哪个SQL语句是正确的()A、Delete Student‘20140001’B、Delete Student“20140001”C、Delete Student Where Number=‘20140001’"D、Delete From Student Where Number=”20140001”"

考题 数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求查询所有男同学信息,下列哪个SQL语句是正确的?()A、Select*FromStudentWhereSex=’男’B、Select*FromStudentWhereSex’女’C、Select*FromStudentWhereSexLike’男’D、Select*FromStudentWhereSexIn’男’

考题 在表单中包含性别选项,且默认状态为“男”被选中,下列正确的是()。A、input type=radio name=sex checked男B、input type=radio name=sex enabled男C、input type=checkbox name=sex checked男D、input type=checkbo xname=sex enabled男

考题 单选题BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime,PublishTime是datetime类型。查询Book表中的图书类别(BookSort),要求每个类别只显示一次。SQL语句:SELECT()BookSort FROM BookA DISTINCTB ONLYC ONED PERCENT

考题 多选题BookStore数据库中有订单表Order(OrderCode,CustomerCode,TotalPrice,Address,OrderTime,OrderStatus)查询订单总价(TotalPrice)在100到200元之间的订单信息。SQL语句:SELECTOrderCode,TotalPrice,OrderTime,OrderStatus FROM[Order]WHERE()ATotalPriceBETWEEN 100 AND 200BTotalPriceNOT BETWEEN 100 AND 200C100=TotalPrice=200DTotalPrice=100AndTotalPrice=200

考题 单选题BookStore数据库中有客户表Customer(CustomerCode,Name,Sex,Hometown,Email,Telephone,LoginDate,Password)查询Customer表中所有客户的信息,要求显示CustomerCode、Name、Hometown和Telephone字段信息。SQL语句:SELECT()FROM CustomerA *B ALLC CustomerCode、Name、Hometown、TelephoneD CustomerCode,Name,Hometown,Telephone

考题 判断题BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime查询图书名称(BookName)含有“程序”的图书信息。SQL语句:SELECTBookCode,BookName,Author,Price,DiscountFROMBookWHEREName=“%程序%”A 对B 错

考题 多选题数据库中有一张表名称为Student,有列Number,Name,Age,IDCard,Sex。主键为Number。统计学生总人数,下列哪个SQL语句是正确的()ASelect Count(1)From StudentBSelect Sum(*)From StudentCSelec tAvg(*)From StudentDSelect Count(*)From Student

考题 单选题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

考题 单选题BookStore数据库中有订单表Order(OrderCode,CustomerCode,TotalPrice,Address,OrderTime,OrderStatus)SELECTTOP3OrderCode,OrderTime,OrderStatusFROM[Order]语句中TOP3的含义是()A 前3个字段B 前3条属性C 前3个记录D 前3个别名