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 sort the results

B. To specify which rows to update

C. To specify the new values

D. To join tables

Answer: Option B

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

A Primary Key in RDBMS must be:

A. Always a foreign key

B. Unique and not null

C. Duplicate values allowed

D. Can have null values

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A primary key uniquely identifies each record and cannot contain null values.

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

Question #2

Which normal form eliminates transitive dependencies?

A. 3NF

B. BCNF

C. 1NF

D. 2NF

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Third Normal Form (3NF) removes transitive dependencies on non-prime attributes.

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

Question #3

In SQL, which clause is used to specify the table(s) from which to retrieve data?

A. GROUP BY

B. WHERE

C. FROM

D. SELECT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The FROM clause identifies the table(s) from which data is to be selected.

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

Explore All Database Management System (DBMS) MCQs