GATE CSE 2010 | Transactions and Concurrency Question 24 | Database Management System

GATE CSE 2010

MCQ (Single Correct Answer)

-0.3

Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock?

I. 2-phase locking
II. Time-stamp ordering

I only

II only

Both I and II

Neither I nor II

GATE CSE 2005

MCQ (Single Correct Answer)

-0.3

Amongst the ACID properties of a transaction, the 'Durability' property requires that the changes made to the database by a successful transaction persist

Except in case of an Operating System crash

Except in case of a Disk crash

Except in case of a power failure

Always, even if there is a failure of any kind

GATE CSE 2004

MCQ (Single Correct Answer)

-0.3

Which level of locking provides the highest degree of concurrency in a relational database?

Page.

Table.

Row.

Page, table and row level locking allow the same degree of concurrency.

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 Subjects

Theory of Computation

Finite Automata and Regular Language Push Down Automata and Context Free Language Undecidability Recursively Enumerable Language and Turing Machine

Operating Systems

Process Concepts and Cpu Scheduling Synchronization and Concurrency Deadlocks Memory Management File System IO and Protection

Algorithms

Complexity Analysis and Asymptotic Notations Searching and Sorting Divide and Conquer Method Greedy Method P and NP Concepts Dynamic Programming

Digital Logic

K Maps Boolean Algebra Combinational Circuits Number Systems Sequential Circuits

Database Management System

Er Diagrams Functional Dependencies and Normalization Structured Query Language Relational Algebra Transactions and Concurrency File Structures and Indexing

Data Structures

Arrays Stacks and Queues Linked List Trees Graphs Hashing

Computer Networks

Concepts of Layering Data Link Layer and Switching Network Layer Application Layer Protocol Routing Algorithm TCP UDP Sockets and Congestion Control Lan Technologies and Wi-Fi Network Security

Software Engineering

Compiler Design

Lexical Analysis Parsing Syntax Directed Translation Code Generation and Optimization

Web Technologies

General Aptitude

Verbal Ability Logical Reasoning Numerical Ability

Discrete Mathematics

Set Theory & Algebra Linear Algebra Graph Theory Combinatorics Mathematical Logic Probability Calculus

Programming Languages

Basic of Programming Language Function and Recursion Pointer and Structure in C

Computer Organization

Computer Arithmetic Pipelining Machine Instructions and Addressing Modes Memory Interfacing IO Interface Alu Data Path and Control Unit Secondary Memory