IBM
C2090-558 · Question #106
C2090-558 Question #106: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-558 to reveal the answer and full explanation for question #106. The question stem and answer options stay visible for context.
Question
Click the Exhibit button. The tables shown in the exhibit have been created for a class enrollment system where a course can be assigned to many classes. The class table joins to the course table on the course_num columns. Which two of the following SQL statements are required to establish a referential integrity relationship between these tables? (Choose two.)
Exhibit
Options
- AALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (class_id));
- BALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (course_num));
- CALTER TABLE course ADD CONSTRAINT (PRIMARY KEY (course_num));
- DALTER TABLE class ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES course);
- EALTER TABLE course ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES class);
Unlock C2090-558 to see the answer
You've previewed enough free C2090-558 questions. Unlock C2090-558 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.