Time Left - 45:00 mins

GATE CS 2021 : Database 6 (App update required to attempt this test)

Attempt now to get your rank among 1035 students!

Question 1

Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

Question 2

Generalization is a bottom up design process that combines several entities sets, which share the same features into a higher-level entity set

Question 3

Consider the following relational instance Emp (Eid, Ename, PAN No):

How many tuples will be generated when the following Query is executed___________.

Select Empid

From Emp

Where PAN N0= NULL;

Question 4

Which of the following combinations represents a valid data model?

Question 5

Which one of the following statements is NOT correct about the B+ tree data structure used for creating an index of a relational database table?

Question 6

Consider the following ERD:

The number of minimum Relations which satisfy 1NF _________. (Partial participation between E1 and R should not be lost in RDBMS design).

Question 7

The following diagram describes a part of an ER Diagram

                                                    

Select the false statements among the following on the above diagram:

Question 8

SELECT e.ename, d.dname
FROM   emp e, dept d
WHERE  e.deptno = d.deptno
AND    e.sal > 1000;

Determine the capability of the SELECT statement demonstrated in the given query.

A.Selection
B. Filtering
C. Joining
D. Projection

Question 9

What is the minimum level of B tree index required for storing 7500 key and order of B tree is 6 (Order is maximum child pointer node can have) ________.

Question 10

How many tuples are in the output of following query?

user(name,age,userid) is a relation where userid is primary key.

SELECT  name, userid
FROM user
WHERE name like '%e%a' and userid like '%_a';

Question 11

Consider a database that has the relation schema EMP (EmpId, EmpName, and DeptName).
An instance of the schema EMP and a SQL query on it are given below.


The output of executing the SQL query is _____.

Question 12

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 13

Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is

Question 14

Consider the following statement regarding Recoverability:
S1: A strict recoverable schedule is always a serializable schedule.
S2: if a Schedule is view serializable as well as conflict serializable, than it is also a recoverable schedule
S3: Strict recoverability may lead to deadlock.
Which of the following is false?

Question 15

Which of the following is correct?
  • 1035 attempts
  • 5 upvotes
  • 8 comments
Aug 9GATE & PSU CS