Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary Key STUDENT_NAME VARCHAR2(30) COURSE_ID VARCHAR2(10) NOT NULL MARKS NUMBER START_DATE DATE FINISH_DATE DATE You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999. Which SQL statement accomplishes this task? （）
A、SELECT student_ id, marks, ROWNUM Rank FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99 AND course_id = 'INT_SQL' ORDER BY mark DESC;

B、SELECT student_id, marks, ROWID Rank FROM students WHERE ROWID <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY mark;

C、SELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC- 99' AND course_id = 'INT_SQL' ORDER BY mark DESC;

D、SELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC) WHERE ROWNUM <= 10;

E、SELECT student id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM <= 10 AND finish date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id 'INT_SQL';

提示：未搜索到的试题可在搜索页快速提交，您可在会员中心"提交的题"快速查看答案。

答案

查看答案

搜题

相关试题

您的部门支持一台Windows 2000服务器，该服务器是带有指向公司中其他服务器节点的单机型Dfs树状结构的主机您需要拆下这台服务器进行维护升级下面哪一种情形描述了当服务器离线时用户组对Dfs树状结构中信息的访问（）

A、在该服务器离线时，用户能够访问Dfs树状结构和Dfs节点中的所有资源

B、用户将能够访问Dfs树状结构，但不能看到树状结构中的任何Dfs节点

C、用户将不能访问Dfs树状结构，但能够从它们的源共享中访问Dfs节点

D、用户将不能访问Dfs树状结构，也不能访问Dfs节点，即使从源共享中也不能访问

查看答案解析

View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is trueabout the output of the command（）

A、 The backup piece is expired as the new backup is available.

B、 The backup piece is expired because the operating-system file was not found.

C、 The backup piece is expired because the retention period for the backup has expired.

D、 The backup piece is expired because the backup set to which it belongs is not complete

查看答案解析

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) A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?（）

A、WHERE lower(country_address) = france

B、WHERE lower(country_address) = 'france'

C、WHERE lower(country_address) IS 'france'

D、WHERE lower(country_address) = '%france%'

E、WHERE lower(country_address) LIKE %france%

查看答案解析

在以下针对“客户机/服务器”计算模式的描述中，哪个选项是错误的（）

A、综合了分时共享和资源共享模式的优点

B、数据具有独立性，易于管理和维护

C、客户机负责处理用户界面和用户交互

D、所有工作负载由客户机负担，减少了服务器的工作量

查看答案解析