IIIT Hyderabad Practice Quiz : Databases-1
Attempt now to get your rank among 247 students!
Consider the following E-R diagram:
What is the minimum relations required which satisfied the 2nd normal form?
Which of the following statement false for B-tree and B+ tree index.
Consider the relation ACCOUNT (AcNo, Branch_Name, Balance)
FROM (SELECT Branch_Name, SUM(Balance) as tot_balance
GROUP BY Branch_Name)
What is the result of the following relational algebra expression:
πsid, pid (Catalog)/πpid (Parts)
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