Oracle
1Z0-061 · Question #82
1Z0-061 Question #82: Real Exam Question with Answer & Explanation
The correct answer is D. CREATE TABLE student_grades(student_id NUMBER(12), semester_end DATE, gpa. CONSTRAINT name FOREIGN KEY (column_name) REFERENCES table_name
Question
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?
Options
- ACREATE TABLE student_grades (student_id NUMBER(12), semester_end DATE, gpa
- BCREATE TABLE student_grades(student_id NUMBER(12), semester_end DATE, gpa
- CCREATE TABLE student_grades(student_id NUMBER(12), semester_end DATE, gpa
- DCREATE TABLE student_grades(student_id NUMBER(12), semester_end DATE, gpa
Explanation
CONSTRAINT name FOREIGN KEY (column_name) REFERENCES table_name
Community Discussion
No community discussion yet for this question.