GATE CS 2021 : Database 6 (App update required to attempt this test)
Attempt now to get your rank among 1027 students!
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.
Generalization is a bottom up design process that combines several entities sets, which share the same features into a higher-level entity set
Consider the following relational instance Emp (Eid, Ename, PAN No):
How many tuples will be generated when the following Query is executed___________.
Where PAN N0= NULL;
Which of the following combinations represents a valid data model?
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?
Consider the following ERD:
The number of minimum Relations which satisfy 1NF _________. (Partial participation between E1 and R should not lost in R DBMS design).
The following diagram describes a part of an ER Diagram
Select the false statements among the following on the above diagram:
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
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) ________.
How many tuples are in the output of following query?
user(name,age,userid) is a relation where is userid is primary key.
select name,userid from user
where name like '%e%a' and userid like '%_a';
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 _____.
Consider the following SQL query:
SELECTProject, count(EmpId). EmpProjectCount
ORDERBY EmpProjectCount DESC;
The given SQL query fetches:
Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is
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?