Consider the tables student and course as shown below. | ID | name | dept_name | |---|---|---| | 21f11 | Ram | CS | | 21f12 | Rakesh | ME | | 21f13 | Pranav | EE | | 21f14 | Rajib | CS | | 21f15 | Vikash | BT | Table 8: student | course_id | title | dept_name | |---|---|---| | C001 | DBMS | CS | | C002 | CAD | ME | | C003 | Digital | EE | | C004 | PDSA | CS | Table 9: course How many rows are returned by the below query? (SELECT ID FROM student,course EXCEPT ALL SELECT ID FROM student) EXCEPT SELECT ID FROM student

Database Management Systems · Quiz 1 · 23 Feb 2025 · January 2025 term

Question 12: Consider the tables student and course as shown below. |…

Question 12

+4 marksNumerical answer

Consider the tables student and course as shown below.

ID	name	dept_name
21f11	Ram	CS
21f12	Rakesh	ME
21f13	Pranav	EE
21f14	Rajib	CS
21f15	Vikash	BT

Table 8: student

course_id	title	dept_name
C001	DBMS	CS
C002	CAD	ME
C003	Digital	EE
C004	PDSA	CS

Table 9: course

How many rows are returned by the below query?

sql

1(SELECT ID FROM student,course
2EXCEPT ALL
3SELECT ID FROM student)
4EXCEPT
5SELECT ID FROM student

Show answer

Correct answer: 0

See the whole paper Take it as a mock test

Question 12 of 14 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 23 Feb 2025, in the January 2025 term (IIT M DIPLOMA AN EXAM QDD2 23 Feb 2025). It carries 4 marks.

Question 12: Consider the tables student and course as shown below. |…

Question 12

More questions from this paper