What is the role of the 'WHERE' clause in an UPDATE statement? MCQ with Answer and Explanation

Question

Share Report Error

What is the role of the 'WHERE' clause in an UPDATE statement?

A. To specify which rows to update

B. To specify the new values

C. To join tables

D. To sort the results

Answer: Option A

Solution (By JKSSB Mock Tests)

The WHERE clause in UPDATE identifies the rows that will be updated. Without it, all rows would be updated.

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 SQL command is used to add new rows of data into an existing table?

A. ADD

B. UPDATE

C. INSERT

D. APPEND

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The INSERT command is a Data Manipulation Language (DML) statement used to add new records/rows to a table.

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

Question #2

Which SQL command is used to reverse or undo all modifications made during the current transaction that have not yet been committed?

A. SAVEPOINT

B. ROLLBACK

C. REVERT

D. UNDO

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The ROLLBACK command is a TCL statement used to undo transactions, restoring the database to its last committed or safe state.

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

Question #3

Which type of JOIN combines all rows from the left table and all rows from the right table, filling in NULLs wherever a match is missing on either side?

A. Full Outer Join

B. Inner Join

C. Cross Join

D. Natural Join

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Full Outer Join combines the behavior of both Left and Right Outer Joins, returning all rows from both tables and applying NULL values where matches do not exist.

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

Explore All Database Management System (DBMS) MCQs