网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
【多选题】BookStore数据库中有客户表Customer(CustomerCode, Name, Sex, Hometown, Email, Telephone, LoginDate, Password) 查询Customer表中所有客户的信息,SQL语句: SELECT ________ FROM Customer
A.*#B.CustomerCode, Name, Hometown, Sex, Email, Telephone, LoginTime, PassWord#C.CustomerCode, Hometown, Telephone, Name, Sex, Email, LoginTime, PassWord#D.CustomerCode ~ PassWord参考答案和解析
INSERT INTO Publisher VALUES(‘66’,’群众出版社‘,’0321-76584391’)
更多 “【多选题】BookStore数据库中有客户表Customer(CustomerCode, Name, Sex, Hometown, Email, Telephone, LoginDate, Password) 查询Customer表中所有客户的信息,SQL语句: SELECT ________ FROM CustomerA.*#B.CustomerCode, Name, Hometown, Sex, Email, Telephone, LoginTime, PassWord#C.CustomerCode, Hometown, Telephone, Name, Sex, Email, LoginTime, PassWord#D.CustomerCode ~ PassWord” 相关考题
考题
将order_list1表中的记录追加到order_list表中,用SQL SELECT语句完成查询,按总金额降序列出所有客户的客户号、客户名及其订单号和总金额,结果存到results表中(客户号、客户名取自customer表,订单号、总金额来自order_list表)。
考题
以下SQL语句用于查询没有订购产品代码为“1K10”的产品的所有客户名。请填补其中的空缺。SELECT CustomerName FROM Customer (1)WHERE (2)(SELECT * FROM OrderDetml B,Order CWHERE B.ProductNo=C.ProductNoAND B.ProductNo='1KIO'AND C.CustomerNo=A.CustomerNo)
考题
在考生文件夹里有表Customer和Order,用SQL SELECT语句查询所有客户的订单信息,要求在结果中包括公司名称、订单编号、金额和送货方式,按公司名称升序排序,再按订单号升序排序,查询结果放在results.dbf中,并要求完整的SQL SELECT语句保存在sql.prg文件中。
考题
假设需要给某个客户表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'客户姓名'
考题
假设需要从CUSTOMER客户表中检索数据,可以使用如下()语句。
A.SELECT*FROM CUSTOMERB.SELECT*CUSTOMERC.MODIFY*FROM CUSTOMERD.UPDATE*FROM 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
考题
数据库中有一张表名称为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
考题
假设需要从CUSTOMER客户表中检索数据,可以使用如下()语句。A、SELECT*FROM CUSTOMERB、SELECT*CUSTOMERC、MODIFY*FROM CUSTOMERD、UPDATE*FROM CUSTOMER
考题
The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) Which statement finds the rows in the CUSTOMERS table that do not have a postal code?()A、SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;B、SELECT customer_id, customer_name FROM customers WHER postal_code = ' ___________';C、SELECT customer_id, customer_name FROM customers WHERE postal _ code IS NULL;D、SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;E、SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL;
考题
查询student表中的所有非空email信息,以下语句正确的是()。A、Select email from student where email !=nullB、Select email from student where email not is nullC、Select email from student where email nullD、Select email from student where email is not null
考题
数据库中有一张表名称为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。统计学生总人数,下列哪个SQL语句是正确的()A、Select Count(1)From StudentB、Select Sum(*)From StudentC、Selec tAvg(*)From StudentD、Select Count(*)From Student
考题
数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求写SQL语句查询出表中年龄介于20和30岁之间的数据,下列哪个SQL语句是正确的?()A、Select* From Student Where Age=20 ANDAge=30B、Select* From Student Where Age=20 ANDAge=30C、Select* From Student Where Age BET WENN 20AND30D、Select* From Student Where Age=20Age=30"
考题
数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求查询所有男同学信息,下列哪个SQL语句是正确的?()A、Select*FromStudentWhereSex=’男’B、Select*FromStudentWhereSex’女’C、Select*FromStudentWhereSexLike’男’D、Select*FromStudentWhereSexIn’男’
考题
查询student表中的所有非空email信息,以下语句正确的是()A、Select email from student where email!=nullB、Select email from student where emailnotisnullC、Select email from student where emailnullD、Select email from student where emailisnotnull
考题
The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) The CUSTOMER_ID column is the primary key for the table. Which two statements find the number of customers? () A、SELECT TOTAL(*) FROM customer;B、SELECT COUNT(*) FROM customer;C、SELECT TOTAL(customer_id) FROM customer;D、SELECT COUNT(customer_id) FROM customer;E、SELECT COUNT(customers) FROM customer;F、SELECT TOTAL(customer_name) FROM customer;
考题
单选题假设需要从CUSTOMER客户表中检索数据,可以使用如下()语句。A
SELECT*FROM CUSTOMERB
SELECT*CUSTOMERC
MODIFY*FROM CUSTOMERD
UPDATE*FROM CUSTOMER
考题
多选题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
考题
单选题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()ALEFT(Name,1)=‘刘’ORLEFT(Name,1)=‘杨’BNameLIKE‘刘%‘ORNameLIKE杨%‘CNameLIKE‘[刘,杨]%‘DNameLIKE‘[^刘,^杨]%
考题
单选题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
考题
多选题数据库中有一张表名称为Student,有列Number,Name,Age,IDCard,Sex。主键为Number。要求查询所有男同学信息,下列哪个SQL语句是正确的?()ASelect* From Student Where Sex=’男’BSelect* From Student Where Number NotIn(Select Number From Student Where Sex=’男’)CSelect* From Student Where NumberIn(Select Numbe rFrom Student Where Sex=’男’)DSelect* From Student Where Sex’男’
考题
多选题数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求写SQL语句查询出表中所有的数据,下列哪个SQL语句是正确的()ASelect* From StudentBSelect Name From StudentCSelect Name,Age,IDCard From StudentDSelect Name,Age,IDCard,Sex From Student
热门标签
最新试卷