itgle.com
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 storesinformation about the student‘s grades. Both of the tables h
题目
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 storesinformation 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 thatpoints 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));
相似考题
更多“You need to design a student registration database that contains several tables storing ac ”相关问题
-
第1题：
Which order of steps is followed in carrying out the project?
A. Assessment－Prototype－Design－Construction.
B. Assessment－Design－Prototype－Construction.
C. Design－Assessment－Prototype－Construction.
D. Design－Prototype－Assessment－Construction.
正确答案：D
-
第2题：
A passenger plane is able to carry a fixed weight, including passengers and fuel.Which wing design would be best for such a plane?
A.Design 1
B.Design 2
C.Design 3
D.Design 4
正确答案：BTo handle the question, you need to infer that the “best” design would be one that is most efficient in terms of its lift-to-drag ratio as well as in terms of fuel consumption. Fortunately,Tables 1 and 2 each show that design 2 is most efficient.
-
第3题：
Several@functionscanexecutemultiplestatements.Whichoneofthefollowinginitializesavariableandcanincrementinduringtheoperation?()A.@do
B.@for
C.@while
D.@dowhile
参考答案：B
-
第4题：
［A］ alternate ［B］ different ［C］ varied ［D］ several
正确答案：A本题考查形容词词义辨析。空格处填入的形容词修饰months。alternate可意为“间隔的，每隔（……天的）”，如He has to work on alternate Sundays.（他每隔一周就有一个周日得上班。）different意为“不同的”，如shirts of different colors（颜色不同的衬衫）。varied意为“各种各样的”，如varied cultures（各种不同的文化）。several意为“几个，若干”，如several hours a day（每天几个小时）。根据句意，司法官或总管官员拥有权力的时间应是“每隔一个月”，而不是“不同的月”、“各种各样的月”或“几个月”。因此，［A］为正确项。
-
第5题：
The stages within the development phase of the software life cycle are ( 71 ).
A.design, analysis, implementation, and testing
B.analysis, design, implementation, and testing
C.analysis, design, testing, and implementation
D.design, analysis, testing, and implementation
正确答案：C
-
第6题：
Refer to the exhibit. Which two statements about the topologies shown are correct?()
A. Design 1 is a looped triangle design.
B. Design 2 is a looped triangle design.
C. Design 2 achieves quick convergence using RSTP.
D. Both designs supportstateful services at the aggregation layer.
E. Design 2 is the most widely deployed in enterprise data centers.
参考答案：A, D