Oracle
1Z0-514 · Question #21
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…
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.