State true or false: Every cascadeless schedule is also irrecoverable

Which of the following are the disadvantages of transaction concurrency?

Which of the following is a transaction isolation?

The conditions for view serializability

When is a timestamp created for a transaction?

In ___________each transaction gets its copy version of the database

What is the advantage of locking?

A transaction has __________ lock, it can read but cannot write on the item

A transaction has ________ lock, it can both read and write on the item

The common technique for identifying database modification is

A ________ in log record describes a single database write

A transaction modifies the database only when it has committed uses a _______ modification

technique

X and Y are _________ if they are operations by different transactions on the same data item,

and at least one of them is a write operation.

A schedule X is __________ if it is conflict equivalent to a serial schedule X.

Which of the following is the most cheap method?

If a transaction can be granted a lock on an item even in the presence of another lock, then

the two locks are said to be ________

The __________ indicates when a transaction can lock and unlock data items

If a transaction never makes progress, then the transaction is said to be ____________

A transaction obtained locks but did not release any locks in

Deadlock phase

Which of the following systems is responsible for ensuring availability?

A transaction that has been completed successfully is called as _______

A system is not in a _______ state if there exists a set of transactions in which every

transaction executes

Which of the following is a method in deadlock handling?

Find the minimum number of keys in leaf nodes of B+ tree if it contains maximum 9 nodes

In which tree disk access is much slower than memory access

Find the maximum number of keys in B+ tree with orber 2 and height is 3

In ........ tree both leave node and internal node have same value used to locate the individual

record

In multilevel indexes, the primary index is in

choose the correct option about indexing

....... time is to find an item and delete it as well as update the index structure.

which method is used to organize a file in multiple ways

secondary index is also named as

A relation with more than one record with unique search key is a

------ is good for dynamic databases where data grows and shrinks frequently

Choose the various methods for collision resolution

If an index is _________________ the metadata and statistics continue to exists

The Classification of security levels

Personal medical records should not be made public is

A security function handled at DBMS level is

This database security mechanism grants privileges to users

The faculty and student role are given for a DBMS system by

Which element secures data from modification?

Which element secures data from disclosure to unauthorized access?

Which element secures data from denial of service attack?

Which of the following are data base security mechanism?

The user account creation in database system is done by

The granting and revocation of privileges in database system is done by

Database audit examines

The CDATA stands for

XML files are processed by

The prevention of individual's data from retrieval is supported by

Symmetric algorithms are

Asymmetric algorithms are

Conversion of plaintext into cipher text is

The three main aspects of security

The disadvantage of distributed database is

Hiding an image into plain text is

The use of classification attribute is