GATE exam stream

GATE CS — Computer Science & IT

174 questions and papers

GATE CS 2020 — Question 47

Numerical answer 2 marks Databases 2020

Consider a database implemented using a B+ tree for file indexing and installed on a disk drive with block size of 4 KB. The size of the search…

GATE CS 2015 Set 2 — Question 34

Numerical answer 1 mark Databases 2015

Consider a B+ tree in which the search key is 12 bytes long, block size is 1024 bytes, record pointer is 10 bytes long and the block pointer…

GATE CS 2017 Set 1 — Question 43

Multiple choice 2 marks Databases 2017

The following functional dependencies hold true for the relational schema \(R\{V, W, X, Y, Z\}\):V -> W VW -> X Y -> VX Y -> ZWhich of the…

GATE CS 2014 Set 2 — Question 30

Multiple choice 2 marks Databases 2014

Consider the following relational schema:employee(empId, empName, empDept) customer(custId, custName, salesRepId, rating)salesRepId is a foreign key referring to empId of the employee relation. Assume that each employee makes a…

GATE CS 2015 Set 2 — Question 42

Multiple choice 2 marks Databases 2015

Consider two relations \(R_1(A, B)\) with the tuples \((1, 5), (3, 7)\) and \(R_2(A, C) = (1, 7), (4, 9)\). Assume that \(R(A, B, C)\) is the full natural outer join of \(R_1\) and \(R_2\). Consider the following tuples of…

GATE CS 2012 — Question 43

Multiple choice 2 marks Databases 2012

Suppose \(R_1(A, B)\) and \(R_2(C, D)\) are two relation schemas. Let \(r_1\) and \(r_2\) be the corresponding relation instances. \(B\) is a foreign key that refers to \(C\) in \(R_2\).…