Oracle Database 11g: Administration I — Question 1

You have to create a table, STUDENTS, with the columns: STUDENT_ID, STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID.
The following constraints have to be enforced on this table:
1) Each student must be uniquely identifiable by the STUDENT_ID.
2) STUDENT_ID column should not be left blank.
3) The student should not be less than 15 years of age.
4) The student can only take a course that is specified in the COURSE table in the database.
Which three constrains must be explicitly enforced on this table? (Choose three.)

Answer options

• A. check constraint on the COURSE_ID column
• B. foreign key constraint on the COURSE_ID column
• C. check constraint on the DATE_OF_BIRTH column
• D. unique key constraint on the STUDENT_ID column
• E. not null constraint on the DATE_OF_BIRTH column
• F. primary key constraint on the COURSE_ID column

Correct answer: B, C, F

Explanation

The correct answer includes a foreign key constraint on the COURSE_ID to ensure that the course is valid according to the COURSE table, a check constraint on the DATE_OF_BIRTH to verify that students are at least 15 years old, and a primary key constraint on the COURSE_ID to uniquely identify the course. The other options, though related to the table structure, do not fulfill the specific requirements outlined in the question.