Time Left - 15:00 mins
GATE CS 2021 : Database Rapid Quiz-1 (App update required to attempt this test)
Attempt now to get your rank among 826 students!
Question 1
Consider the following SQL query on a relation EmployeeSalary as follows:
SELECT Project, count(EmpId). EmpProjectCount
FROM EmployeeSalary
GROUP BY Project
ORDER BY EmpProjectCount DESC;
The given SQL query fetches?
Question 2
Consider the following relation instant
Which of the following functional dependencies are satisfied by the instance?
Which of the following functional dependencies are satisfied by the instance?
Question 3
Match the following:
Question 4
Consider the following query:
SELECT * FROM WORKER WHERE WORKER_ID <= (SELECT count(WORKER_ID)/2 from Worker);
What is the correct meaning of the given SQL Query?
Question 5
Consider a file of 8192 records. Each record is 4bytes long and its key field is of size 6 bytes. The file is ordered on a key field, and the file organization is unspanned. The file is stored in a file system with a block size is 512 bytes, and the size of a block pointer is 10bytes. If the primary index is built on the key field of the file, and a multilevel index scheme is used to store the primary index, the number of second-level blocks in the multilevel index be?
Question 6
If the following sequence of keys is inserted into an empty B+ tree of order 4 then the search key value 31 will be placed at what level(Assume root node at level 0)? 2,3,5,11,19,23,29,31
- 826 attempts
- 3 upvotes
- 5 comments
Tags :
GATE & PSU CSDatabasesSep 30GATE & PSU CS