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

题目
单选题
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.The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA NUMBER(4,3)The registrar requested a report listing the students‘ grade point averages (GPA) sorted from highest grade point average to lowest.Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? （）A. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;B. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;C. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;D. SELECT student_id, gpa FROM student_grades ORDER BY gpa;E. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;F. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;

2.Which statement explicitly names a constraint? ()A. ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students (student_id);B. ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);C. ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);D. ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);E. ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);

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

4.You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?()A. ALTER TABLE students ADD PRIMARY KEY _ id;B. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);C. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;D. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);E. ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

更多“Examine the structure of the STUDENTS table: STUDENT_ID NUMB”相关问题

  • 第1题：

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

    A.

    B.

    C.

    D.


    参考答案：A

  • 第2题：

    Examine the structure of the STUDENTS table: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.

    B.

    C.

    D.


    参考答案：D

  • 第3题：

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

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


    正确答案：C

  • 第4题：

    You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

    • A、All data along with the table structure is deleted 
    • B、The pending transaction in the session is committed 
    • C、All indexes on the table will remain but they are invalidated 
    • D、All views and synonyms will remain but they are invalidated 
    • E、All data in the table are deleted but the table structure will remain

    正确答案:A,B,D

  • 第5题：

    Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）

    • A、You cannot roll back this statement.
    • B、All pending transactions are committed.
    • C、All views based on the DEPT table are deleted.
    • D、All indexes based on the DEPT table are dropped.
    • E、All data in the table is deleted, and the table structure is also deleted.
    • F、All data in the table is deleted, but the structure of the table is retained.
    • G、All synonyms based on the DEPT table are deleted.

    正确答案:A,B,D,E

  • 第6题：

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


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

  • 第7题：

    单选题
    Which statement explicitly names a constraint?（）
    A

    ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students (student_id);

    B

    ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);

    C

    ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);

    D

    ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);

    E

    ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);


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

  • 第8题：

    单选题
    You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）
    A

    ALTER TABLE students ADD PRIMARY KEY _ id;

    B

    ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

    C

    ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

    D

    ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

    E

    ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);


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

  • 第9题：

    单选题
    The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest. Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?（）
    A

    SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;

    B

    SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;

    C

    SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;

    D

    SELECT student_id, gpa FROM student_grades ORDER BY gpa;

    E

    SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;

    F

    SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;


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

  • 第10题：

    单选题
    You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key. You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?（）
    A

    CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY student (student_id));

    B

    CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));

    C

    CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES student (student_id));

    D

    CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));


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

  • 第11题：

    单选题
    You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）
    A

    ALTER TABLE students ADD PRIMARY KEY student_id;

    B

    ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

    C

    ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

    D

    ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

    E

    ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);


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

  • 第12题：

    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

  • 第13题：

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

    A.

    B.

    C.

    D.


    参考答案：A

  • 第14题：

    You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?（）

    • A、ALTER TABLE students ADD PRIMARY KEY student_id;
    • B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student _ id);
    • C、ALTER TABLE students ADD CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);
    • D、ALTER TABLE students MODIFY CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);

    正确答案:C

  • 第15题：

    You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）

    • A、ALTER TABLE students ADD PRIMARY KEY _ id;
    • B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
    • C、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
    • D、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
    • E、ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

    正确答案:D

  • 第16题：

    The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）

    • A、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;
    • B、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, ASC,gpa ASC;
    • C、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, gpa DESC;
    • D、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,semester_end DESC;
    • E、SELECT student_id, semester_end, gpa FROM student_grades

    正确答案:C

  • 第17题：

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


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

  • 第18题：

    多选题
    You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）
    A

    All data along with the table structure is deleted

    B

    The pending transaction in the session is committed

    C

    All indexes on the table will remain but they are invalidated

    D

    All views and synonyms will remain but they are invalidated

    E

    All data in the table are deleted but the table structure will remain


    正确答案： B,C
    解析： 暂无解析

  • 第19题：

    单选题
    The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）
    A

    SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;

    B

    SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, ASC,gpa ASC;

    C

    SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, gpa DESC;

    D

    SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,semester_end DESC;

    E

    SELECT student_id, semester_end, gpa FROM student_grades


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

  • 第20题：

    多选题
    Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）
    A

    You cannot roll back this statement.

    B

    All pending transactions are committed.

    C

    All views based on the DEPT table are deleted.

    D

    All indexes based on the DEPT table are dropped.

    E

    All data in the table is deleted, and the table structure is also deleted.

    F

    All data in the table is deleted, but the structure of the table is retained.

    G

    All synonyms based on the DEPT table are deleted.


    正确答案： B,E
    解析： 暂无解析

  • 第21题：

    单选题
    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
    解析： 暂无解析

相关内容