Time Left - 10:00 mins

IIIT Hyderabad Practice Quiz : Databases-4

Attempt now to get your rank among 275 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.

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

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?
  • 275 attempts
  • 3 upvotes
  • 0 comments
Mar 25GATE & PSU CS

Posted by:

Harshita AgarwalHarshita AgarwalMember since Jul 2020
Share this quiz   |