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

In SQL, the WHERE clause is used in:

A. Only SELECT statements

B. SELECT, UPDATE, DELETE statements

C. Only INSERT statements

D. Only CREATE statements

Answer: Option B

WHERE clause filters records in SELECT, UPDATE, and DELETE operations.

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

No comments yet. Be the first to start the discussion!

Question #1 Report Error

Which SQL statement is used to delete all rows from a table without logging individual row deletions?

A. DROP TABLE table_name;

B. DELETE FROM table_name;

C. TRUNCATE TABLE table_name;

D. REMOVE FROM table_name;

Correct Answer: Option C

Explanation:
TRUNCATE TABLE removes all rows and is a DDL operation with minimal logging, often faster than DELETE without WHERE.

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

Question #2 Report Error

Which type of database model organizes data in a tree-like structure?

A. Relational model

B. Network model

C. Object-oriented model

D. Hierarchical model

Correct Answer: Option D

Explanation:
The hierarchical model arranges data in a parent-child relationship, forming a tree structure.

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

Question #3 Report Error

In an Entity-Relationship (ER) diagram, what geometric shape is used to represent an entity type?

A. Ellipse

B. Rectangle

C. Triangle

D. Diamond

Correct Answer: Option B

Explanation:
In standard ER modeling notation, rectangles are used to represent entity sets or entity types.

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