

MCQOPTIONS
Saved Bookmarks
1. |
A relational schema for a train reservation database is given below. Passenger (pid, pname, age) Reservation (pid, class, tid)Table: Passenger pid pname age----------------- 0 Sachin 65 1 Rahul 66 2 Sourav 67 3 Anil 69Table : Reservationpid class tid--------------- 0 AC 8200 1 AC 8201 2 SC 8201 5 AC 8203 1 SC 8204 3 AC 8202What pids are returned by the following SQL query for the above instance of the tables? SELECT pid |
A. | 1, 0 |
B. | 1, 2 |
C. | 1, 3 |
D. | 1, 5 |
Answer» D. 1, 5 | |