In SQL, the WHERE clause is used in: MCQ with Answer and Explanation

Question
In SQL, the WHERE clause is used in:
A. SELECT, UPDATE, DELETE statements
B. Only CREATE statements
C. Only INSERT statements
D. Only SELECT statements
Answer: Option A
Solution (By JKSSB Mock Tests)
WHERE clause filters records in SELECT, UPDATE, and DELETE operations.
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 a query optimizer in a DBMS?
A. A component that determines the most efficient way to execute a query
B. A tool for indexing
C. A user interface
D. A backup utility
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The query optimizer analyzes SQL queries and selects the most efficient execution plan based on statistics and indexes.
This question belongs to: Computer Database Management System (DBMS)
Question #2
What is a pivot table in a database context?
A. A view
B. A technique to rotate rows into columns for data summarization
C. A stored procedure
D. A type of index
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Pivoting transforms data by turning unique values from one column into multiple columns, often for reporting.
This question belongs to: Computer Database Management System (DBMS)
Question #3
What is the purpose of the SQL 'CONSTRAINT' keyword?
A. To join tables
B. To create views
C. To define rules for data integrity
D. To create indexes
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Constraints are used to enforce rules on data, such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: