Which of the following commands is a Data Manipulation Language (DML) statement? MCQ with Answer and Explanation

Which of the following commands is a Data Manipulation Language (DML) statement?
A. RENAME
B. TRUNCATE
C. COMMENT
D. UPDATE
Answer: Option D
Solution (By JKSSB Mock Tests)
UPDATE is a DML statement because it is used to modify existing data values within rows of a database table, rather than modifying the structural schema.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
What does ACID stand for in the context of database transactions?
A. Atomicity, Consistency, Integrity, Durability
B. Atomicity, Concurrency, Isolation, Durability
C. Atomicity, Consistency, Isolation, Durability
D. Atomicity, Consistency, Integrity, Data

Correct Answer: Option C


Explanation:
ACID stands for Atomicity, Consistency, Isolation, and Durability, which are the key properties that guarantee reliable processing of database transactions.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which language category in SQL is used by database administrators to grant and revoke access privileges and security permissions?
A. DCL
B. DML
C. TCL
D. DDL

Correct Answer: Option A


Explanation:
Data Control Language (DCL) includes commands like GRANT and REVOKE, which manage privileges and security configurations for database users.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What is the role of a database administrator (DBA)?
A. To manage and maintain the database system
B. To develop applications
C. To design the user interface
D. To write queries

Correct Answer: Option A


Explanation:
A DBA is responsible for the overall administration, maintenance, performance, security, and backup of the database system.

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