Data File Handling

Question

Observe the following table MEMBER carefully and write the name of the RDBMS operation out of (i) SELECTION (ii) PROJECTION (iii) UNION (iv) CARTESIAN PRODUCT, which has been used to produce the output as shown in RESULT. Also, find the Degree and Cardinality of the RESULT.

NO MNAME STREAM
M001 JAYA SCIENCE  
M002 ADIYTA HUMANITIES 
M003 HANSRAJ SCIENCE
M004 SHIVAK COMMERCE

RESULT

NO MNAME  STREAM
M002  ADIYTA HUMANITIES 

Answer

SELECTION
Degree of table RESULT=3
Cardinality of table RESULT = 2

Sponsor Area

Some More Questions From Data File Handling Chapter