Suppose a database system crashes again while recovering from a previous crash. Assume checkpointing is not done by the database e…
The following relation records the age of 500 employees of a company, where empNo (indicating the employee number) is the key: emp…
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…
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.