Time Left - 10:00 mins

IIIT Hyderabad Practice Quiz : Databases-1

Attempt now to get your rank among 270 students!

Question 1

Consider the following E-R diagram:

What is the minimum relations required which satisfied the 2nd normal form?

Question 2

Which of the following statement false for B-tree and B+ tree index?

Question 3

Consider the relation ACCOUNT (AcNo, Branch_Name, Balance)

SELECT max(tot_balance)

FROM (SELECT Branch_Name, SUM(Balance) as tot_balance

FROM account

GROUP BY Branch_Name)

Question 4

What is the result of the following relational algebra expression:

πsid, pid (Catalog)/πpid (Parts)

Question 5

Consider the following relations given below:
Animals (ID, Name, Type)
Adoption (AniID, Adopt Date)
What does the following SQL query returns?

SELECT DISTINCT Type FROM Animals WHERE
NOT EXISTS (SELECT * FROM Adoption
                    WHERE Adoption.AniID = Animals.ID)

  • 270 attempts
  • 0 upvotes
  • 2 comments
Sep 27GATE & PSU CS