网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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';
参考答案
更多 “ 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';” 相关考题
考题
－－－ Here is the company structure of Bi bury Systems. －－－ I see. Where does Kate fit____the company structure?
A.withB.intoC.inD.onto
考题
Being interested in the relationship of language and thought, Whorf developed the idea that the structure of language determines the structure of habitual thought in a society.
考题
M．Jackson suggested the data structure oriented software design method．Which of the following structure can be introduced by using input data structure?A．algorithm structureB．procedure structureC．code structureD．program structure
考题
In credit mix, tenor refers to ______.A．term of loanB．term structure of loanC．term of assetD．term structure of asset
考题
Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query?()
A. To find the tax percentage for each of the employees.B. To list the name, job id, and manager name for all the employees.C. To find the name, salary, and department name of employees who are not working with Smith.D. To find the number of employees working for the Administrative department and earning less then 4000.E. To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
考题
Examine the structure of the EMPLOYEES table:You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:Which UPDATE statement meets the requirements?（）A.B.C.D.E.
考题
Examine the structure of the EMPLOYEES table:What is the correct syntax for an inline view?()
A.B.C.D.
考题
Examine the structure of the EMPLOYEES table:You issue these statements:At the end of this transaction, what is true?()
A. You have no rows in the table.B. You have an employee with the name of James.C. You cannot roll back to the same savepoint more than once.D. Your last update fails to update any rows because employee ID 180 was already eleted.
考题
Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables:Which MERGE statement is valid?()
A.B.C.D.
考题
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?()
A.B.C.D.
考题
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which UPDATE statement is valid?()
A.B.C.D.
考题
Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()
A.B.C.D.
考题
The three main things that a learner has to acquire when learning a new structure are the form, meaning and（）of the structure.
考题
The（）may examine or re-examine the goods or take samples from them straightaway in the absence of the consignee or the consignor whenever it considers this necessary.A、CustomsB、The ministry of commerceC、The state councilD、the commodity inspection institution
考题
Your alert log file has the following information： Tue May 25 17：43：38 2004 ORA-00060： Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc. What would you do to ensure that database is still running correctly？（）A、examine the trace file and kill the session that caused the deadlockB、examine the trace file and kill both the sessions responsible for the deadlockC、examine the trace file for details and ask the user who caused the deadlock to roll back the transactionD、examine the trace file for details and remember that deadlocks are resolved automatically by Oracle databaseE、examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
考题
Your network consists of a single Active Directory domain that contains two domain controllers. Both domain controllers run Windows Server 2003 Service Pack 2 (SP2). Auditing of successful account logon events is enabled on all computers in the domain. You need to identify the last time a specific user logged on to the domain. What should you do? （）A、Examine the System Event Log on the user’s computer.B、Examine the System Event Log on both domain controllers.C、Examine the Security Event Log on both domain controllers.D、Examine the Application Event Log on the user’s computer.
考题
单选题下列命令中，仅拷贝表文件结构的命令是（）A
COPY TOB
COPY STRUCTURE TOC
COPY FILE TOD
COPY STRUCTURE TO EXETENDED
考题
填空题The three main things that a learner has to acquire when learning a new structure are the form, meaning and（）of the structure.
考题
单选题View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries？ （）A
displaying the total order value for sales representatives 161 and 163B
displaying the order total for sales representative 161 in the year 1999C
displaying the number of orders that have order mode online and order date in 1999D
displaying the number of orders whose order total is more than the average order total for all online orders
考题
单选题The（）may examine or re-examine the goods or take samples from them straightaway in the absence of the consignee or the consignor whenever it considers this necessary.A
CustomsB
The ministry of commerceC
The state councilD
the commodity inspection institution
考题
单选题A data manipulation language statement （）.A
completes a transaction on a tableB
modifies the structure and data in a tableC
modifies the data but not the structure of a tableD
modifies the structure but not the data of a table
热门标签
最新试卷
