Which of the following is a DML statement? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a DML statement?

A. UPDATE

B. CREATE

C. ALTER

D. DROP

Answer: Option A

Solution (By JKSSB Mock Tests)

UPDATE is a Data Manipulation Language (DML) command used to modify existing records in a table. CREATE, ALTER, DROP are DDL.

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

What is the difference between a database and a database management system?

A. DBMS is the data; database is the software

B. A database is the data; DBMS is the software that manages it

C. Database is a file; DBMS is a table

D. They are the same

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A database is a collection of structured data, while a DBMS is the software used to interact with and manage that data.

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

Question #2

Which of the following is a valid SQL function to convert a string to uppercase?

A. UPPER()

B. UCASE()

C. Both A and C

D. TO_UPPER()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
UPPER() is standard SQL; some DBMS also support UCASE().

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

Question #3

What is a subquery in SQL?

A. A query nested inside another query

B. A query that returns multiple results

C. A query that is used to create a table

D. A query that is always correlated

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A subquery is a SELECT statement nested within another SQL statement (e.g., SELECT, INSERT, UPDATE, DELETE).

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

Explore All Database Management System (DBMS) MCQs