[单选]
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'

购买一家现存企业之前，必须对其基本情况进行全面的审查，下列各项内容中，（）项不属于审查范围。财务状况。市场状况。出售原因。员工年龄结构。双代号网络图中，在节点之间（）出现带双向箭头的连线。可以。严禁。视情况而定是否可以。特殊情况可以。 AUM has been retaining about 15 minutes worth of undo. You want to double the retentionperiod， but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However， AUM still retains only about 15 minutes worth of undo. What is the problem？（） You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.。 You need to increase the size of the undo tablespace.。 The undo tablespace is not set to auto-extend.。 You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.。《中华人民共和国反洗钱法》规定：海关发现个人出入境携带的现金超过规定金额的，应当及时向什么部门通报？（）国务院反洗钱行政主管部门。侦查机关。反洗钱监测分析中心。国务院反洗钱其他监管部门。 A customer is currently using a Windows file server to share NFS storage (9 TB) to theirapplication server, and a small SAN to supply block I/O to their database servers (5 TB). As theircurrent hardware is aging they are looking for a new best of breed technology to combine file andblock I/O on a single storage unit. Which IBM solution would provide that capability at the lowestcost?（） IBM XIV Storage System 。 IBM System Storage DS8700 。 IBM System Storage N6070 。 IBM System Storage N6210。

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? （）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-007题库

相关题目: