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?
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
Tags :
GATE & PSU CSDatabasesSep 27GATE & PSU CS