CIW Exam Questions

Which of the following SQL statements would return the Registration2 relation from the Registration

Consider the Registration relation shown in the exhibit.

Which of the following SQL statements would return the Registration2 relation from the Registration relation?

A.
SELECTCourse_Code
FROM Registration;

B.
SELECT * FROM
Registration WHERE
Registration_ID = 1003 AND
Registration_ID = 1005;

C.
SELECT * FROM Registration
WHERE Course_Code = ‘A4343’;

D.
SELECTRegistration_ID, Student_ID, First_Name, Last_Name