Which of the following is a TCL (Transaction Control Language) command? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a TCL (Transaction Control Language) command?

A. SAVEPOINT

B. SELECT

C. CREATE

D. DROP

Answer: Option A

Solution (By JKSSB Mock Tests)

Transaction Control Language includes COMMIT, ROLLBACK, and SAVEPOINT.

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

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

A. Atomicity

B. Durability

C. Isolation

D. Consistency

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
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)

Question #2

Share Report

Which of the following best defines a Database?

A. Software for creating spreadsheets

B. A single file containing text

C. A collection of related data organized for easy access

D. Hardware used to store programs

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A database is an organized collection of related data stored electronically for efficient retrieval and management.

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

Question #3

Share Report

What is a database lock?

A. A backup file

B. A mechanism to prevent simultaneous access to the same data causing inconsistency

C. A user account

D. A type of index

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Locking is a concurrency control mechanism that ensures data integrity during simultaneous transactions.

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

Explore All Database Management System (DBMS) MCQs