Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?（）A、SORT BY age ASC, last_nameB、S

题目

Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?（）

A、SORT BY age ASC, last_name
B、SORT BY age DESC, last_name
C、ORDER BY age DESC, last_name
D、ORDER BY age ASC, last_name

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? ()

A. GRANT select ON dept TO ALL_ USER;

B. GRANT select ON dept TO ALL;

C. GRANT QUERY ON dept TO ALL_USERS

D. GRANT select ON dept TO PUBLIC;

参考答案：D

第2题：

用SQL命令生成含有字段职工号、姓名的视图，下列语句正确的是 ______。

A．CREATE VIEW ZG_w AS SELECT职工号，姓名FROM职工

B．CREATE QUERY ZG_w AS SELECT职工号，姓名FROM职工

C．CREATE VIEW ZG w AS SELECT职工号，姓名

D．CREATE QUERY ZG_w AS SELECT职工号，姓名

正确答案：A
解析：视图是根据对表的查询来定义的，可以用命令方式来建立查询，具体格式如下：CREATEVIEWview_name[(column_name[，column_name]...)]ASselect_statement说明：viewname指定要创建的视图的名称；当没有为视图指定字段名(columnname)时，视图的字段名将与selectstatement中指定的字段名或表中的字段名同名；selectstatement是任意的SELECT查询语句。本题利用SELECT语句来指定职工表的字段职工号，姓名为查询字段。

第3题：

mysql_query在功能上等于mysql_select_db()＋mysql_db_query()。()

此题为判断题(对，错)。

正确答案:×

第4题：

SQL是哪几个英语单词的缩写（）

A、Standard Query Language
B、Structured Query Language
C、Select Query Language
D、其他三项都不是

正确答案:B

第5题：

Given the following statements:CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3);What is the result of the following query? SELECT count(*) FROM tab2;（）

A.3

B.2

C.1

D.0

参考答案：D

第6题：

Observe the structure of the table employees:The table contains 8475 records.One of the employees wants to know the names of all employees of the company. For this, he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?（）

A. Rollback segment

B. Temporary segment

C. Data segment

D. Index segment

参考答案：B

第7题：

SQL是 ______的缩写。

A．Standard Query Language

B．Structured Query Language

C．Select Query Language

D．以上都不是

正确答案：B
解析：SQL是结构化查询语言Structured Query Language的缩写。

第8题：

用SQL命令生成含有字段职工号、姓名的视图，下列语句正确的是______。

A．CREATE VIEW ZG w AS SELECT职工号，姓名FROM职工

B．CREATE QUERY ZG w AS SELECT职工号，姓名FROM职工

C．CREATE VIEW ZG w AS SELECT职工号，姓名

D．CREATE QUERY ZG w AS SELECT职工号，姓名

正确答案：A
解析：视图是根据对表的查询来定义的，可以用命令方式来建立查询，具体格式如下：
CREATEVIEWview_name[(column_nameLcolumn_nameL…)]
ASselect statement
说明：view_name指定要创建的视图的名称；当没有为视图指定字段名(column_name)时，视图的字段名将与select statement中指定的字段名或表中的字段名同名；select_statement是任意的SELECT查询语句。本题利用SELECT语句来指定职工表的字段职工号，姓名为查询字段。

第9题：

Given the following function:CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN (‘A00‘, ‘B00‘); ENDHow can this function be used in an SQL statement?

A.SELECT TABLE(EMPLIST()) FROM EMPLOYEE

B.SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE

C.SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE

D.SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t

参考答案：D

第10题：

Given the following table definitions: EMPLOYEE ID NAME DEPTID 01Smith 10 02Bossy 20 03 20 Peterson 04Goss 30 05Pape 40 06Avery 50 07O'Neal 60 08Carter 50 DEPARTMENT ID DEPTNAME 05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and the following query: SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4 Which of the following queries will produce the same result set as the query above?（）

A、SELECT e.id, d.deptname FROM employee e, department d WHERE e.id > 4
B、SELECT e.id, d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id > 4
C、SELECT e.id, d.deptname FROM employee e FULL OUTER JOIN department d ON e.id = d.id WHERE e.id > 4
D、SELECT e.id, d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4 UNION ALL SELECT e.id, d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4

正确答案:B

Given the following query:SELECT

题目

相似问题和答案

更多相关问题

相关内容