📝 Question
#1196
The primary key in the section relation is
✓
Correct Answer
C. Both Course_id and Sec_id
💡
Explanation
Here Course_id is the only attribute that has a unique entries. So, Course_id is the primary key in the section relation table. 3. SELECT * FROM teaches WHERE Sec_id = 'CS-101'; a) 1003 b) 1001 c) None d) Error message appears The value CS-101 matches the Course_id but not Id. 4. SELECT Id, Course_id, Building FROM SECTION s AND teaches t WHERE t.year=2009; a) 1003 b) 1001 c) Both 1003 and 1001 d) Error message appears Two rows are select in the above query.
⌨️ Press
A
B
C
D
to select