Time Left - 10:00 mins
IIIT Hyderabad Practice Quiz : Databases-4
Attempt now to get your rank among 299 students!
Question 1
Consider the schema R(A, B, C, D, E) and functional dependencies {A → BC, CD → E, B → D, E → A}. Then the decomposition of R into R1(ABC) and R2(ADE) is
Question 2
Which of the following statements is/are FALSE?
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.
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.
Question 3
Consider the following relation:
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
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
Question 4
Consider the following relational schema for a train reservation database . Passenger (pid, pname, age) Reservation (pid, class, tid)
Table: Passenger
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?
SELECT pid
FROM Reservation ,
WHERE class ‘AC’ AND
EXISTS (SELECT * FROM Passenger
WHERE age > 65 AND
Passenger. pid = Reservation.pid)
Question 5
Consider the following statement
(i) Primary index is always sparse
(ii) Secondary index may or may not be dense
Which of the above statement is/are false?
(i) Primary index is always sparse
(ii) Secondary index may or may not be dense
Which of the above statement is/are false?
- 299 attempts
- 3 upvotes
- 0 comments
Tags :
GATE & PSU CSDatabasesMar 25GATE & PSU CS