Time Left - 10:00 mins

IIIT Hyderabad Practice Quiz : Databases-1

Attempt now to get your rank among 247 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)

  • 247 attempts
  • 0 upvotes
  • 2 comments
Mar 22GATE & PSU CS

Posted by:

Priya UpadhyayPriya UpadhyayMember since Sep 2020
Priya Upadhyay
Share this quiz   |