Oracle
1Z0-514 · Question #21
1Z0-514 Question #21: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-514 to reveal the answer and full explanation for question #21. The question stem and answer options stay visible for context.
Question
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: - Each student must be uniquely identifiable by the STUDENT_ID. - The STUDENT_ID columns should not be left blank. - The student should not be less than 15 years of age. - The student can only take a course that is specified in the COURSE table in the database. Which three constraints must be explicitly enforced on the table? (Choose three)
Options
- Acheck constraint on the COURSE_ID column
- Bforeign key constraint on the COURSE_ID column
- Ccheck constraint on the DATE_OF_BIRTH column
- Dunique key constraint on the STUDENT_ID column
- Enot null constraint on the DATE_OF_BIRTH column
- Fprimary key constraint on the STUDENT_ID columns
Unlock 1Z0-514 to see the answer
You've previewed enough free 1Z0-514 questions. Unlock 1Z0-514 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.