GATE CSE 2003 | GATE CSE Year Wise Previous Years Questions

GATE CSE 2003

MCQ (Single Correct Answer)

-0.3

Consider the following SQL query:

Select distinct a₁, a₂, ..., a_n 

From r₁, r₂, ..., r_m 

Where P;

For an arbitrary predicate P, this query is equivalent to which of the following relational algebra expressions?

$$\prod\limits_{{a_1},{a_2},....,{a_n}} {{\sigma _p}} \left( {{r_1} \times {r_2} \times .... \times {r_m}} \right)$$

$$\prod\limits_{{a_1},{a_2},....,{a_n}} {{\sigma _p}} \left( {{r_1} \Join {r_2} \Join .... \Join {r_m}} \right)$$

$$\prod\limits_{{a_1},{a_2},....,{a_n}} {{\sigma _p}} \left( {{r_1} \cup {r_2} \cup .... \cup {r_m}} \right)$$

$$\prod\limits_{{a_1},{a_2},....,{a_n}} {{\sigma _p}} \left( {{r_1} \cap {r_2} \cap .... \cap {r_m}} \right)$$

GATE CSE 2003

MCQ (Single Correct Answer)

-0.3

Which of the following scenarios may lead to an irrecoverable error in a database system?

A transaction writes a data item after it is read by an uncommitted transaction

A transaction reads a data item after it is read by an uncommitted transaction

A transaction reads a data item after it is written by a committed transaction

A transaction reads a data item after it is written by an uncommitted transaction

GATE CSE 2003

MCQ (Single Correct Answer)

-0.6

Consider three data items D1, D2, and D3, and the following execution schedule of transactions T1, T2, and T3. In the diagram, R(D) and W(D) denote the actions reading and writing the data item D respectively. GATE CSE 2003 Database Management System - Transactions and Concurrency Question 24 English

GATE CSE 2003 Database Management System - Transactions and Concurrency Question 24 English

Which of the following statements is correct?

The schedule is serializable as T2; T3; T1

The schedule is serializable as T2; T1; T3

The schedule is serializable as T3; T2; T1

The schedule is not serializable

GATE CSE 2003

MCQ (Single Correct Answer)

-0.3

Assuming all numbers are in $$2's$$ complement representation, which of the following numbers is divisible by $$11111011?$$

$$11100111$$

$$11100100$$

$$11010111$$

$$11011011$$

PREVIOUS NEXT

GATE CSE Papers

2023