Explore topic-wise MCQs in Translation and Regulation.

Who detects the failure of the system and restore the database to consistent state ?

Which phage always carries a small piece of E.coli genome?

Which of the following are functions of Database Manager ?

1. Interacting with File Manager
2. Creating Queries to Access data
3. Security Enforcement
4. Database Definition and Schema Generation

Transaction management ensures ____________ and __________ properties.

___________ is an interface between low level database and application program.

A transaction may not always complete its execution successfully. Such a transaction is termed

Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction?

What are the Svedberg values for the subunits of the 70S ribosomes of E. colli?

When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj ). Otherwise, Ti is rolled back (dies). This is

The deadlock state can be changed back to stable state by using _____________ statement.

What are the ways of dealing with deadlock ?

A lock that allows concurrent transactions to access different rows of the same table is known as a

Database locking concept is used to solve the problem of

Which of these is data type long literal?

A deadlock exists in the system if and only if the wait-for graph contains a ___________.

Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is

The deadlock in a set of transaction can be determined by

When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp larger than that of Tj (that is, Ti is younger than Tj ). Otherwise, Tj is rolled back (Tj is wounded by Ti ). This is

The execution sequences in concurrency control are termed as ________

Which of the following is not a transaction state?

____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

Transaction processing is associated with everything below except

The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties.

__________ states that only valid data will be written to the database.

The database system must take special actions to ensure that transactions operate properly without interference from concurrently executing database statements. This property is referred to as

The property of a transaction that persists all the crashes is

Identify the characteristics of transactions

Which of the following has all-or-none property?

A transaction is delimited by statements (or function calls) of the form __________

State true or false: Information residing in the volatile storage does not usually survive system crashes

Which of the following systems is responsible for ensuring isolation?

Which of the following systems is responsible for ensuring durability?

Which of the following is not a property of a transaction?

Execution of translation in isolation preserves the _________ of a database

The all-or-none property is commonly referred to as _________

Which of the following is a property of transactions?

A transaction that has not been completed successfully is called as _______

_________ rollback requires the system to maintain additional information about the state of all the running transactions.

What is ACID properties of Transactions?

With regards to transaction processing, any DBMS should be capable of:

The scheme that controls the interaction between executing transactions is called as _____

A transaction completes its execution is said to be

A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.

Collections of operations that form a single logical unit of work are called __________

The application of database management system in air flight seat booking in a way that one seat is accessed by only one clerk for customer reservation is classified as

In database management system, the executing process or executing program which considers the updating or reading of records stored in database is called