Suppose a database system crashes again while recovering from a previous crash. Assume checkpointing is not done by the database e…
Let ri(z) and wi(z) denote read and write operations respectively on a data item z by a transaction Ti. Consider the following two…
Consider the relation R(P,Q,S,T,X,Y,Z,W) with the following functional dependencies. PQ → X; P → YX; Q → Y; Y → ZW Consider the de…
Consider the following statements S1 and S2 about the relational data model: S1: A relation scheme can have at most one foreign ke…
A data file consisting of 1,50,000 student-records is stored on a hard disk with block size of 4096 bytes. The data file is sorted…
The relation scheme given below is used to store information about the employees of a company, where empId is the key and deptId i…
Free account benefits
Public PYQs and reference pages stay free. Sign in when you want GATEverse to remember what you studied and guide what to practise next.