Consider the tables Products and Suppliers given below: | P_ID | P_Name | S_ID | |---|---|---| | 1 | Laptop | 3 | | 2 | Smartphone | 2 | | 3 | Tablet | 3 | | 4 | Headphones | 1 | Table 1: Products | S_ID | S_Name | |---|---| | 1 | Sony | | 2 | Samsung | | 3 | Apple | Table 2: Supplier Now consider the SQL query given below: Select From Products P, Supplier S Where P.P_ID<>S.S_ID How many attributes and rows will be present in the resultant output table?

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

Question 3: Consider the tables Products and Suppliers given below: |…

Question 3

+4 marksOne correct option

Consider the tables Products and Suppliers given below:

P_ID	P_Name	S_ID
1	Laptop	3
2	Smartphone	2
3	Tablet	3
4	Headphones	1

Table 1: Products

S_ID	S_Name
1	Sony
2	Samsung
3	Apple

Table 2: Supplier

Now consider the SQL query given below:

sql

1Select *
2From Products P, Supplier S
3Where P.P_ID<>S.S_ID

How many attributes and rows will be present in the resultant output table?

A
4 attributes and 9 rows
B
5 attributes and 8 rows
C
4 attributes and 8 rows
D
5 attributes and 9 rows

Show answer

Correct answer

D
5 attributes and 9 rows

See the whole paper Take it as a mock test

Question 3 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 3: Consider the tables Products and Suppliers given below: |…

Question 3

More questions from this paper