Which of the following is a property of a database that ensures transactions are isolated from each other? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a property of a database that ensures transactions are isolated from each other?

A. Atomicity

B. Isolation

C. Durability

D. Consistency

Answer: Option B

Solution (By JKSSB Mock Tests)

Isolation ensures that concurrent execution of transactions results in a state that is equivalent to some serial execution.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

Share Report

In an Entity-Relationship (ER) diagram, attributes are represented using which shape?

A. Square

B. Rectangle

C. Diamond

D. Ellipse/Oval

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ellipses or ovals are used to represent attributes (properties) of entities in ER diagrams.

This question belongs to: Computer Database Management System (DBMS)

Question #2

Share Report

The command to modify existing records in a table is:

A. UPDATE

B. MODIFY

C. ALTER

D. CHANGE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
UPDATE is the DML command used to modify data in existing rows.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Share Report

Which SQL function returns the average of a numeric column?

A. SUM()

B. MEAN()

C. COUNT()

D. AVG()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
AVG() calculates the average of the values in a numeric column.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs