Observe the following table CANDIDATE 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.
TABLE: CANDIDATE
NO | NAME | STREAM |
---|---|---|
C1 | AJAY | LAW |
C2 | ADITI | MEDICAL |
C3 | ROHAN | EDUCATION |
C4 | RISHAB | ENGINEERING |
RESULT
NO | NAME |
---|---|
C3 | ROHAN |