[单选]
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 marks 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 marks;
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 marks DESC);
D . SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students ORDER BY marks DESC) WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id ='INT _ SQL'

You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； Which two statements are correct？（） The FLASHBACK TABLE statement will not be written to the alert log file.。 The EMP table that was dropped by mistake from the database will be restored.。 The changes made to the EMP table since the specified time will be undone.。 The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.。 The FLASHBACK TABLE statement will be executed within a single transaction.。 The list of transactions that have modified the EMP table since the specified time will be displayed.。国家工作人员在社会保险管理、监督工作中滥用职权、玩忽职守、徇私舞弊的，依法给予处分。违反法律规定，构成犯罪的，依法追究刑事责任。调用主窗体的（）方法，可以结束程序关闭窗体。清算假设 Given： Which three changes should be made to adapt this class to be used safely by multiple threads？（） declare reset（） using the synchronized keyword。 declare getName（） using the synchronized keyword。 declare getCount（） using the synchronized keyword。 declare the constructor using the synchronized keyword。 declare increment（） using the synchronized keyword。

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题库

相关题目: