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

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

A. Consistency

B. Durability

C. Atomicity

D. Isolation

Answer: Option D

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)

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

Question #1 Report Error

Which of the following is a DCL (Data Control Language) command?

A. CREATE

B. SELECT

C. GRANT

D. COMMIT

Correct Answer: Option C

Explanation:
GRANT and REVOKE are DCL commands. COMMIT is TCL, SELECT is DML, CREATE is DDL.

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

Question #2 Report Error

Which of the following is a valid SQL numeric function?

A. All of the above

B. CEILING

C. FLOOR

D. ROUND

Correct Answer: Option A

Explanation:
ROUND, CEILING, and FLOOR are common mathematical functions in SQL.

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

Question #3 Report Error

What is the purpose of the SQL GROUP BY ... HAVING combination?

A. To select individual rows

B. To join groups

C. To filter groups based on aggregate values

D. To sort groups

Correct Answer: Option C

Explanation:
HAVING is used in conjunction with GROUP BY to filter groups based on conditions applied to aggregate functions.

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