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. SELECT

B. CREATE

C. DROP

D. SAVEPOINT

Answer: Option D

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

Which constraint ensures that all values in a column are unique?

A. CHECK

B. UNIQUE

C. PRIMARY KEY

D. FOREIGN KEY

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
UNIQUE constraint ensures that all values in a column are distinct, but allows NULL (unless combined with NOT NULL).

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

Question #2

What is the purpose of the SQL 'CONSTRAINT' keyword?

A. To create views

B. To join tables

C. To create indexes

D. To define rules for data integrity

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Constraints are used to enforce rules on data, such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK.

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

Question #3

What does DBMS stand for?

A. Database Management System

B. Data Backup Management System

C. Dynamic Binary Manipulation System

D. Digital Business Management Software

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
DBMS stands for Database Management System, which is software for creating and managing databases.

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

Explore All Database Management System (DBMS) MCQs