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 h

题目

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';
相似考题

1.－－－ Here is the company structure of Bi bury Systems. －－－ I see. Where does Kate fit____the company structure?A.withB.intoC.inD.onto

2.市场结构（Market structure）

3.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.

4.How to present a structure?

参考答案和解析
正确答案:D
更多“Examine the structure of the ST”相关问题

  • 第1题：

    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 structure

    B．procedure structure

    C．code structure

    D．program structure


    正确答案：D

  • 第2题：

    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.


    参考答案：A

  • 第3题：

    Examine the structure of the EMPLOYEES table:What is the correct syntax for an inline view?()

    A.

    B.

    C.

    D.


    参考答案：A

  • 第4题：

    Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables:Which MERGE statement is valid?()

    A.

    B.

    C.

    D.


    参考答案：A

  • 第5题：

    Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which UPDATE statement is valid?()

    A.

    B.

    C.

    D.


    参考答案：A

  • 第6题：

    检查

    A.expect

    B.except

    C.excuse

    D.examine


    正确答案：D

  • 第7题：

    hierarchical structure
    The sentence structure that groups words into structural constituents and shows the syntactic categories of each structural constituent,such as NP and VP.
    略

  • 第8题：

    检查（）

    • A、expect
    • B、except
    • C、excuse
    • D、examine

    正确答案:D

  • 第9题：

    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、Customs
    • B、The ministry of commerce
    • C、The state council
    • D、the commodity inspection institution

    正确答案:A

  • 第10题：

    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.

    正确答案:C

  • 第11题：

    填空题
    The three main things that a learner has to acquire when learning a new structure are the form, meaning and（）of the structure.

    正确答案： use
    解析： 暂无解析

  • 第12题：

    单选题
    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

    Customs

    B

    The ministry of commerce

    C

    The state council

    D

    the commodity inspection institution


    正确答案： A
    解析： 暂无解析

  • 第13题：

    In credit mix, tenor refers to ______.

    A．term of loan

    B．term structure of loan

    C．term of asset

    D．term structure of asset


    正确答案：B
    解析：term structure of loan贷款期限。credit mix信贷组合，又称为"credit portfolio"，它包括五个部分：tenor(期限)，risk rating(风险等级)，industry(行业)，obligor(债务人)，concentration(集中度)。

  • 第14题：

    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.


    参考答案：C

  • 第15题：

    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.


    参考答案：A

  • 第16题：

    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.


    参考答案：B, D

  • 第17题：

    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.


    参考答案：C

  • 第18题：

    SQL语句中修改表结构的命令是______。

    A、MODIFY TABLE B、MODIFY STRUCTURE C、ALTER TABLE D、ALTER STRUCTURE


    正确答案：C

  • 第19题：

    The three main things that a learner has to acquire when learning a new structure are the form, meaning and（）of the structure.
    use
    略

  • 第20题：

    发夹结构（hairpin structure）


    正确答案:RNA是单链线形分子，只有局部区域为双链结构。这些结构是由于RNA单链分子通过自身回折使得互补的碱基对相遇，形成氢键结合而成的，称为发夹结构。

  • 第21题：

    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 deadlock
    • B、examine the trace file and kill both the sessions responsible for the deadlock
    • C、examine the trace file for details and ask the user who caused the deadlock to roll back the transaction
    • D、examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database
    • E、examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock

    正确答案:D

  • 第22题：

    单选题
    下列命令中，仅拷贝表文件结构的命令是（）
    A

    COPY TO

    B

    COPY STRUCTURE TO

    C

    COPY FILE TO

    D

    COPY STRUCTURE TO EXETENDED


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    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 163

    B

     displaying the order total for sales representative 161 in the year 1999

    C

     displaying the number of orders that have order mode online and order date in 1999

    D

     displaying the number of orders whose order total is more than the average order total for all online orders


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    A data manipulation language statement （）.
    A

    completes a transaction on a table

    B

    modifies the structure and data in a table

    C

    modifies the data but not the structure of a table

    D

    modifies the structure but not the data of a table


    正确答案： A
    解析： 暂无解析

相关内容