“The student” in the sentence “The student liked the linguistic lecture”, and “The linguistic lecture” in the sentence “The linguistic lecture liked the student.” belong to the same syntactic category...

第1题

[判断题] “The student” in the sentence “The student liked the linguistic lecture.”，and “The linguistic lecture” in the sentence “The linguistic lecture liked the student.”belong to the same syntactic category.

点击查看答案

第2题

[单选题] 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));

点击查看答案

第3题

[单选题] 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));

点击查看答案

第4题

[单选题] Examine the description of the MARKS table: SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: What is the result of the SELECT statement?（）

A、The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject. B、The statement returns an error at the SELECT clause. C、The statement returns an error at the WHERE clause. D、The statement returns an error at the ORDER BY clause.

点击查看答案

第5题

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

点击查看答案

第6题

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

点击查看答案

第7题

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

点击查看答案

第8题

[单选题] A college has a small campus where 25 faculty members are located. The faculty offices and student computers are currently on the same network. The faculty are concerned about students being able to capture packets going across the network and obtain sensitive material. What could a network administrator do to protect faculty network traffic from student connections?（）

A、Install anti-virus software on the student computers. B、Put the faculty computers in a separate VLAN. C、Power down the switches that connect to faculty computers when they are not in use. D、Remove the student computers from the network and put them on a peer-to-peer network. E、Create an access list that blocks the students from the Internet where the hacking tolls are located.

点击查看答案

第9题

[单选题] Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT subj1+subj2 total_marks, std_id FROM marks WHERE subj1 > AVG(subj1) AND subj2 > AVG(subj2) ORDER BY total_ marks; What is the result of the SELECT statement? （）

A、The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject. B、The statement returns an error at the SELECT clause. C、The statement returns an error at the WHERE clause. D、The statement returns an error at the ORDER BY clause.

点击查看答案

“The student” in the sentence “The student liked the linguistic lecture”, and “The linguistic lecture” in the sentence “The linguistic lecture liked the student.” belong to the same syntactic category.

请使用微信扫码支付