网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Select emp_id，emp_name，sex，title，wage from employee order by emp_name句子得到的结果集是按（）排序。
- A、emp_id
- B、emp_name
- C、sex
- D、wage
参考答案
更多 “Select emp_id，emp_name，sex，title，wage from employee order by emp_name句子得到的结果集是按（）排序。A、emp_idB、emp_nameC、sexD、wage” 相关考题
考题
检索所有比“王华”年龄大的学生的姓名、年龄和性别，正确的SELECT语句是______。A．SELECT SN,AGE,SEX FROM S SHERE AGE＞(SELECT AGE FROM S WHERE SN='王华')B．SELECT SN,AGE,SEX FROM S WHERE SN='王华'C．SELECT SN,ACE,SEX FROM S WHERE AGE＞(SELECT ACE WHERE SN='王华')D．SELECT SN,ACE,SEX FROM S WHERE ACE＞王华 AGE
考题
实现“从学生信息表中找出性别为女的学生姓名”的SQL语句是A．SELECT*FROMsB．SELECT*FROM s WHERE sex＝'女'C．SELECT sname FROM s WHERE sex＝'女'D．SELECT*FROM s WHERE grade＝"
考题
第(38)～(40) 题基于学生一课程数据库中的3个基本表：学生信息表：s(sno，sname，sex，age，dept)主码为sno课程信息表：c(cno，cname，teacher)主码为cno学生选课信息表：sc(sno，cno，grade)主码为(sno，cno)实现“从学生信息表中找出性别为女的学生姓名”的SQL语句是A．SELECT * FROM sB．SELECT * FROM s WHERE sex='女'C．SELECT sname FROM s WHERE sex='女'D．SELECT * FROM s WHERE grade="
考题
检索所有比"王华"年龄大的学生姓名、年龄和性别。正确的SELECT语句是()
A、SELECT SN，AGE，SEX FROM SSHERE AGE>(SELECT AGE FROM S)WHERE SN=’王华’)B、SELECT SN，AGE，SEXFROM SWHERE SN=’王华’C、SELECT SN，ACE，SEX FROM SWHERE AGE>(SELECT ACEWHERE SN=’王华’)D、SELECT SN，ACE，SEX FROM SWHERE ACE>王华AGE
考题
S(S#,SN,SEX,AGE,DEPT) C(C#,CN) SC(S#,C#,GRADE)其中：S#为学号，SN为姓名，SEX为性别，AGE为年龄，DEPT为系别，C#为课程号， CN为课程名，GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是______。A．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE FROM S WHERE SN＝'王华')B．SELECT SN, AGE, SEX FROM S WHERE SN='王华'C．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE WHERE SN＝'王华')D．SELECT SN,AGE,SEX FROM S WHERE AGE＞王华AGE
考题
The best title for this passage would be ______.A) The Importance of Being VisibleB) Role of Women and Minorities in ManagementC) Job Performance and AdvancementD) Sex and Career Success
考题
下面关于TITLE元素说法正确的一项是______。A.TITLE元素由一个起始标记和一个结束标记
下面关于TITLE元素说法正确的一项是______。A．TITLE元素由一个起始标记＜TITLE＞和一个结束标记＜/TITLE＞定界。实际标题位于两个标记之间，而且还要用引号把标题括起来B．TITLE元素位于＜SELECT＞…＜/SELECT＞之间C．除了TITLE元素外，HEAD之间的元素对文档阅读者来说是不可见的，起码是不可直接见到的D．TITLE和文档的文件名作用是一样的
考题
阅读下列XML文档，回答问题1至问题4，将解答填入对应栏内。【XML文档】＜? Xml version= "1.0" encoding=" GB2312 "?＞＜!—以下是文档的主体部分→＜college＞＜title＞希赛教育＜/title＞＜head＞软考培训部＜/Head＞＜Stu_Num unit="人"＞2＜/Stu_Num＞＜Student＞＜Name＞张网管＜/Name＞＜Age＞21 ＜/Age＞＜Sex＞男＜/Sex＞＜Class＞软考2班＜/Class＞＜/Student＞＜Student＞＜Name＞李软设＜/Name＞＜Age＞20＜/Age＞＜Sex＞女＜/Sex＞＜Class＞软考3班＜/Class＞＜/Student＞＜/College＞与HTML相比，XML具有哪些特点?
考题
S(S,SN,SEX,AGE,DEPT)C(C,CN)SC(S,C,GRADE)其中:S为学号,SN为姓名,SEX为性别,AGE为年龄,DEP
S(S#,SN,SEX,AGE,DEPT) C(C#,CＮ) SC(S#,C#,GRADＥ) 其中：S#为学号，SN为姓名，SEX为性别，AGE为年龄，DEPT为系别，C#为课程号， CN为课程名，GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别。 正确的SELECT语句是______。A．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE FROM S WHERE SN＝‘王华’)B．SELECT SN,AGE,SEX FROM S WHERE SN＝‘王华’C．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE WHERE SN＝‘王华’)D．SELECT SN,AGE,SEX FROM S WHERE AGE＞王华 AGE
考题
现有一个HTML文档，其中有一段文字是“张莫创建于2003年9月”。这段文字最有可能是放在______之间。A．＜TITLE＞…＜/TITLE＞B．＜ADDRESS＞…＜/ADDRESS＞C．＜TEXTAREA＞…＜/TEXTAREA＞D．＜SELECT＞…＜/SELECT＞
考题
Click the Exhibit button to examine the data of the EMPLOYEES table.Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee‘s manager, for all the employees who have a manager and earn more than 4000?（）A.SELECT employee_id Emp_id, emp_name Employee, salary, employee_id Mgr_id, emp_name Manager FROM employees WHERE salary 4000;B.SELECT e.employee_id Emp_id, e.emp_name Employee, e.salary, m.employee_id Mgr_id, m.emp_name Manager FROM employees e JOIN employees m WHERE e.mgr_id = m.mgr_id AND e.salary 4000;C.SELECT e.employee_id Emp_id, e.emp_name Employee, e.salary, m.employee_id Mgr_id, m.emp_name Manager FROM employees e JOIN employees m ON (e.mgr_id = m.employee_id) AND e.salary 4000;D.SELECT e.employee_id Emp_id, e.emp_name Employee, e.salary, m.mgr_id Mgr_id, m.emp_name Manager FROM employees e SELF JOIN employees m WHERE e.mgr_id = m.employee_id AND e.salary 4000;E.SELECT e.employee_id Emp_id, e.emp_name Employee, e.salary, m.mgr_id Mgr_id m.emp_name Manager FROM employees e JOIN employees m USING (e.employee_id = m.employee_id) AND e.salary 4000;
考题
The way in which people address each other depends on their age, sex, social group and personal relationship. The English system of address forms frequently used includes first name, last name, title+last name, （）, and kin term.A、title+first nameB、title+titleC、title aloneD、first name+last name+title
考题
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
考题
数据库中有一张表名称为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’男’
考题
现有三个表即学生表S、课程表C和学生选课表SC，它们的结构如下：S（S#，SN，SEX，AGE，DEPT）；C（C#，CN）；SC（S#，C#，GRADE）。其中：S#为学号，SN为姓名，SEX为性别，AGE为年龄，DEPT为系别，C#为课程号，CN为课程名，GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是（）A、SELECT SN，AGE，SEX FROM SWHE RESN＝“王华”B、SELECT SN，AGE，SEX FROM SWHE REAGE＞（SELECTAGEFROMSWHERESN=“王华”）C、SELECT SN，AGE，SEX FROM SWHE REAGE＞（SELECTAGEWHERESN=“王华”）D、SELECT SN，AGE，SEX FROM SWHE REAGE＞王华.AGE
考题
数据库中有一张表名称为Student，有列Name，Age，IDCard，Sex。要求查询所有男同学信息，下列哪个SQL语句是正确的？（）A、Select*FromStudentWhereSex=’男’B、Select*FromStudentWhereSex’女’C、Select*FromStudentWhereSexLike’男’D、Select*FromStudentWhereSexIn’男’
考题
Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A、17000.00B、17000*****C、****170.00D、**17000.00E、an error statement
考题
Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID) EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 HR_MGR 5000 106 Bryan 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA_DIR 6500 Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000?（）A、SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary 4000;B、SELECT e.employee_id "Emp_id", e.emp_name "Employee",C、salary,D、employee_id "Mgr_id", m.emp_name "Manager" FROM employees e, employees m WHERE e.mgr_id = m.mgr_id AND e.salary 4000;
考题
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. EMPLOYEES NOT NULL, EMPLOYEE_ID NUMBER Primary Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, Primary DEPARTMENT_ID NUMBER Key VARCHAR2 DEPARTMENT_NAME (30) References NGR_ID MGR_ID NUMBER column of the EMPLOYEES table Foreign key to LOCATION_ID NUMBER LOCATION_ID column of the LOCATIONS table LOCATIONS NOT NULL, Primary LOCATION_ID NUMBER Key VARCHAR2 CITY |30) Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?（）A、SELECT emp_name, department_name, city FROM employees e JOIN departments d USING (department_id) JOIN locations 1 USING (location_id) WHERE salary 10000;B、SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 JOIN ON (e.department_id = d.department id) AND (d.location_id =1.location_id) AND salary 10000;C、SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 WHERE salary 10000;D、SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 WHERE e.department_id = d.department_id AND d.location_id = 1.location_id AND salary 10000;E、SELECT emp_name, department_name, city FROM employees e NATURAL JOIN departments, locations WHERE salary 10000;
考题
单选题Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A
17000.00B
17000*****C
****170.00D
**17000.00E
an error statement
考题
单选题Examine the structure if the EMPLOYEES table: Column name Data Type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) NOT NULL SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows?（）A
CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);B
CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);C
CREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;D
CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;
考题
单选题Select emp_id，emp_name，sex，title，wage from employee order by emp_name句子得到的结果集是按（）排序。A
emp_idB
emp_nameC
sexD
wage
考题
单选题Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A
17000.00B
17000*****C
****170.00D
**17000.00E
an error statement
考题
单选题What is the best title for the passage?A
The Place of Women in Society.B
He or She.C
Chairman or Chairwoman.D
Language and Sex.
考题
多选题数据库中有一张表名称为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’男’
热门标签
最新试卷
