IIIT Hyderabad Practice Quiz : Databases-4
Attempt now to get your rank among 275 students!
I. XML overcomes the limitations in HTML to support a structured way of organizing content.
II. XML specification is not case sensitive while HTML specification is case sensitive.
III. XML supports user defined tags while HTML uses pre-definedtags.
IV. XML tags need not be closed while HTML tags must be closed.
R(Doctor #, Patient #, Date, Diagnosis, Treat_Code, Charge)
In this relation, a tupple describes a visit of a patient to a doctor along with a treatment code and a daily, charge. Assume that each unique visit of a patient to a doctor on a particular date can reveal the diagnosis, treat_code and charge. Assume that each treatment code has fixed charge (regardless of patient). The relation R is
pid pname age
0 Sachin 65
1 Rahul 66
2 Sourav 67
3 Anil 69
Table : Reservation
pid class tid
0 AC 8200
1 AC 8201
2 SC 8201
5 AC 8203
1 SC 8204
3 AC 8202
What are the pids returned by the following SQL query for the above instance of the tables?
FROM Reservation ,
WHERE class ‘AC’ AND
EXISTS (SELECT * FROM Passenger
WHERE age > 65 AND
Passenger. pid = Reservation.pid)
(i) Primary index is always sparse
(ii) Secondary index may or may not be dense
Which of the above statement is/are false?
- 275 attempts
- 3 upvotes
- 0 comments