Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return the Registration2 relation from the Registration relation?
A) SELECT Course_Code FROM Registration;
B) SELECT * FROM Registration WHERE Registration_ID = 1003 AND Registration_ID = 1005;
C) SELECT * FROM Registration WHERE Course_Code = 'A4343';
D) SELECT Registration_ID, Student_ID, First_Name, Last_Name

Question

Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return the Registration2 relation from the Registration relation? 
A) SELECT Course_Code FROM Registration; 
B) SELECT * FROM Registration WHERE Registration_ID = 1003 AND Registration_ID = 1005; 
C) SELECT * FROM Registration WHERE Course_Code = 'A4343'; 
D) SELECT Registration_ID, Student_ID, First_Name, Last_Name

Quizplus · Accepted Answer

The Answer of Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return the Registration2 relation from the Registration relation? 
A) SELECT Course_Code FROM Registration; 
B) SELECT * FROM Registration WHERE Registration_ID = 1003 AND Registration_ID = 1005; 
C) SELECT * FROM Registration WHERE Course_Code = 'A4343'; 
D) SELECT Registration_ID, Student_ID, First_Name, Last_Name

Consider the Registration Relation Shown in the Exhibit