Which of the following concurrency control schemes is not based on serializability property?

Question

Which of the following concurrency control schemes is not based on serializability property?

A. Two-phase locking

B. Timestamped based locking

C. Graph-based locking

D. none of the above

Share this question with your friends

Show all Advance DBMS MCQ

Comment

Radio frequencies below ............. are more suitable for omnidirectional applications.

A. 300MHz

B. 1GHz

C. 5GHz

D. 10 GHz

Discuss this answer

............... noise is caused by the random motion of the electrons in a wire and is avoidable.

A. Thermal

B. Intermodulation

C. Cross talk

D. Impulse

Discuss this answer

Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.

A. i ,iii only

B. ii, iv only

C. iii, iv only

D. ii, iii, iv

Discuss this answer

Generalization is a

A. top-down approach.

B. bottom-up approach.

C. left-right approach.

D. none of the above

Discuss this answer

A transaction is said to have terminated if it has

A. either committed or aborted

B. either partially committed or aborted

C. either committed or failed

D. none of these

Discuss this answer

File organization that provides fast access to any arbitrary record

A. Hashed file

B. B-tree

C. Ordered file

D. Unordered file

Discuss this answer

DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions

A. Backup

B. Recovery

C. Grant

D. Troubleshooting

Discuss this answer

Technique(s) used for data recovery after any failure

A. Logging

B. Recovery manager

C. Both A and B are true

D. Both A and B are false

Discuss this answer

In a Hierarchical model records are organized as

A. Graph.

B. List.

C. Links.

D. Tree.

Discuss this answer

EEPROM

A. Electrically Extractable Programmable Read Only Memory

B. Electrically Erasable Programmable Read Only Memory

C. Electronically Erasable Programmable Read Only Memory

D. Electrically Erasable Programmable Read Only Memory

Discuss this answer

Electromagnetic spectrum included in radiowaves are
i) Super High Frequency (SHF)
ii) Very High Frequency (VHF)
iii) Ultra High Frequency (UHF)
iv) High Frequencies (HF)

A. i, ii and iii only

B. i, ii and iv only

C. ii, iii and iv only

D. i, iii and iv only

Discuss this answer

In the architecture of a database system external level is the

A. physical level.

B. logical level.

C. conceptual level

D. view level.

Discuss this answer

Specialization is a

A. top-down approach.

B. bottom-up approach.

C. left-right approach.

D. none of the above

Discuss this answer

Referential integrity

A. controls relationships between operations of an object

B. controls relationships between instances of a class

C. controls relationships between attributes in a table

D. controls relationships between tables in a database

Discuss this answer

A type of query that is placed within a WHERE or HAVING clause of another query is called

A. Super query

B. Sub query

C. Master query

D. Multi-query

Discuss this answer

In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?

A. parallel

B. serial

C. analog

D. digital

Discuss this answer

A transaction which may not complete its execution successfully is termed as

A. Failed

B. Aborted

C. Blocked

D. Finished

Discuss this answer

Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions

A. i only

B. ii only

C. Both A and B

D. None of the above

Discuss this answer

The minimal set of super key is called

A. Primary key

B. Secondary key

C. Candidate key

D. Foreign key

Discuss this answer

In an Entity-Relationship Diagram Diamonds represents

A. Attributes

B. Multi-valued attributes

C. Weak entity set

D. Relationship sets

Discuss this answer

Data stored in cursor is called ……………

A. record

B. active data set

C. object

D. none of the above

Discuss this answer

The statement in SQL which allows to change the definition of a table is

A. Select

B. Update

C. Create

D. Alter

Discuss this answer

Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?

A. BCNF

B. Second

C. Third

D. Fourth

Discuss this answer

Which of the following is a classical approach to database design?

A. Left Right approach

B. Right Left approach

C. Top Down approach

D. Bottom Up approach

Discuss this answer

Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization

A. i and ii only

B. ii and iii only

C. i and iii only

D. All i, ii iii

Discuss this answer

Technique used in log based recovery

A. Immediate database modification

B. Graph-based recovery

C. key dependencies

D. none of the above

Discuss this answer

A transaction which completes successfully is called

A. Granted

B. Committed

C. Compensated

D. Accomplished

Discuss this answer

Data fragmentation is performed by the …… and each fragment is stored at…………..

A. DBMS, same site

B. OS ,same site

C. DBMS ,different site

D. OS ,different site

Discuss this answer

An operation that will increase the length of a list is

A. insert

B. modify

C. lookup

D. none of the above

Discuss this answer

The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol

A. i, ii only

B. ii and iv only

C. ii and iv only

D. i, iv only

Discuss this answer

Accepted Answer

C. Graph-based locking

Which of the following concurrency control schemes is not based on serializability property?

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

Radio frequencies below ............. are more suitable for omnidirectional applications.

............... noise is caused by the random motion of the electrons in a wire and is avoidable.

Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.

Generalization is a

A transaction is said to have terminated if it has

File organization that provides fast access to any arbitrary record

DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions

Technique(s) used for data recovery after any failure

In a Hierarchical model records are organized as

EEPROM

Electromagnetic spectrum included in radiowaves are
i) Super High Frequency (SHF)
ii) Very High Frequency (VHF)
iii) Ultra High Frequency (UHF)
iv) High Frequencies (HF)

In the architecture of a database system external level is the

Specialization is a

Referential integrity

A type of query that is placed within a WHERE or HAVING clause of another query is called

In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?

A transaction which may not complete its execution successfully is termed as

Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions

The minimal set of super key is called

In an Entity-Relationship Diagram Diamonds represents

Data stored in cursor is called ……………

The statement in SQL which allows to change the definition of a table is

Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?

Which of the following is a classical approach to database design?

Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization

Technique used in log based recovery

A transaction which completes successfully is called

Data fragmentation is performed by the …… and each fragment is stored at…………..

An operation that will increase the length of a list is

The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol

Also checkout

Which of the following concurrency control schemes is not based on serializability property?

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

Radio frequencies below ............. are more suitable for omnidirectional applications.

............... noise is caused by the random motion of the electrons in a wire and is avoidable.

Select the incorrect statement(s)i) Foreign key values can be left blankii) In SQL duplicates may be presentiii) Theta join operation doesnt remove duplicate columns.iv) NULL value means string of blank characters.

Generalization is a

A transaction is said to have terminated if it has

File organization that provides fast access to any arbitrary record

DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions

Technique(s) used for data recovery after any failure

In a Hierarchical model records are organized as

EEPROM

Electromagnetic spectrum included in radiowaves arei) Super High Frequency (SHF)ii) Very High Frequency (VHF)iii) Ultra High Frequency (UHF)iv) High Frequencies (HF)

In the architecture of a database system external level is the

Specialization is a

Referential integrity

A type of query that is placed within a WHERE or HAVING clause of another query is called

In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?

A transaction which may not complete its execution successfully is termed as

Attenuation can be also expressed in decibel dB) and commonly used because.i) Signal strengths often fall off logarithmicallyii) Cascade losses and gains can be calculated with simple additions and subtractions

The minimal set of super key is called

In an Entity-Relationship Diagram Diamonds represents

Data stored in cursor is called ……………

The statement in SQL which allows to change the definition of a table is

Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?

Which of the following is a classical approach to database design?

Extended Entity Relationship model consists of which of the followingi) Specializationii) Generalizationiii) Categorization

Technique used in log based recovery

A transaction which completes successfully is called

Data fragmentation is performed by the …… and each fragment is stored at…………..

An operation that will increase the length of a list is

The types of noiseless channels arei) Selective Reject ARQii) simplest protocoliii) Go-Back-N ARQiv) Stop-and-Wait Protocol

Also checkout

Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.

Electromagnetic spectrum included in radiowaves are
i) Super High Frequency (SHF)
ii) Very High Frequency (VHF)
iii) Ultra High Frequency (UHF)
iv) High Frequencies (HF)

Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions

Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization

The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol