The command to modify existing records in a table is: MCQ with Answer and Explanation

Question

Share Report Error

The command to modify existing records in a table is:

A. UPDATE

B. MODIFY

C. CHANGE

D. ALTER

Answer: Option A

Solution (By JKSSB Mock Tests)

UPDATE is the DML command used to modify data in existing rows.

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 of the following is not an aggregate function in SQL?

A. MAX

B. DESC

C. AVG

D. SUM

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
DESC is a keyword for sorting order, not an aggregate function.

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

Question #2

Which clause is used in SQL queries to filter rows and retrieve only those records that satisfy a specific condition?

A. HAVING

B. ORDER BY

C. GROUP BY

D. WHERE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The WHERE clause is used to filter records based on a specified condition before any grouping takes place.

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

Question #3

In SQL, which operator is used to combine two conditions and returns true if both are true?

A. AND

B. NOT

C. OR

D. XOR

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The AND operator returns true only if both conditions are true.

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

Explore All Database Management System (DBMS) MCQs