What is a database transaction? MCQ with Answer and Explanation

Question Report Error

What is a database transaction?

A. A backup copy of the database

B. A database schema

C. A query that reads data

D. A logical unit of work that consists of one or more SQL statements

Answer: Option D

Solution (By JKExamLibrary)

A transaction is a sequence of operations performed as a single logical unit, ensuring ACID properties.

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

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

Which wildcard character is used with the SQL LIKE operator to represent zero, one, or multiple characters?

A. Hash (#)

B. Percentage sign (%)

C. Ampersand (&)

D. Underscore (_)

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
The percentage sign (%) is used as a wildcard character to match any sequence of zero or more characters in an SQL LIKE string comparison query.

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

Question #2 Report Error

Which SQL operator allows you to check if a column value matches any item contained within a comma-separated list of explicit values?

A. IN

B. EXISTS

C. BETWEEN

D. LIKE

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
The IN operator allows you to specify multiple literal values or a subquery inside a WHERE clause, testing if an attribute matches any element in the list.

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