The query which selects the Course_id CS-101 from the section relation is

Select Course_id from teaches where Building = Packyard ;

Select Course_id from section where Building = Richard ;

Select Course_id from section where Year = 2009 ;

Select Course_id from teaches where Building = Packyard ;

Select Course_id from section where Sec_id = 3 ;

Explore topic-wise MCQs in Database.

This section includes 2 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.

1.	In the above teaches relation Select * from teaches where Year = 2010 displays how many rows?
A.	2
B.	4
C.	5
D.	1
Answer» B. 4

Discussion

2.	The query which selects the Course_id CS-101 from the section relation is
A.	Select Course_id from section where Building = Richard ;
B.	Select Course_id from section where Year = 2009 ;
C.	Select Course_id from teaches where Building = Packyard ;
D.	Select Course_id from section where Sec_id = 3 ;
Answer» C. Select Course_id from teaches where Building = Packyard ;

Discussion

Explore topic-wise MCQs in Database.

In the above teaches relation Select * from teaches where Year = 2010 displays how many rows?

The query which selects the Course_id CS-101 from the section relation is