Category: 1Z0-051 (v.1)

Exam 1Z0-051: Oracle Database 11g: SQL Fundamentals I (May 21th, 2013)

Which statement creates the foreign key?

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?


Page 1 of 2912345...1020...Last »