Which operator is used in SQL to compare a value to a set of values returned by a subquery? MCQ with Answer and Explanation

Which operator is used in SQL to compare a value to a set of values returned by a subquery?
A. EXISTS
B. IN
C. LIKE
D. BETWEEN
Answer: Option B
Solution (By JKSSB Mock Tests)
IN checks if a value matches any value in a list or subquery result set.

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 a characteristic of a view?
A. It is always faster than a table
B. It is a virtual table based on a query
C. It stores data physically
D. It cannot be updated

Correct Answer: Option B


Explanation:
A view is a virtual table that does not store data physically; it presents data from one or more tables as if it were a table.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which schema architecture level describes how the data is physically stored on disk storage media?
A. Logical Level
B. External Level
C. Internal Level
D. Conceptual Level

Correct Answer: Option C


Explanation:
The Internal (or Physical) level of the three-schema architecture describes the physical storage structure and access paths of the database.

This question belongs to: Computer Database Management System (DBMS)
Question #3
The ability to modify the physical schema without forcing application programs to be rewritten is called what?
A. Physical Data Independence
B. Structural Integrity
C. Logical Data Independence
D. Data Redundancy

Correct Answer: Option A


Explanation:
Physical Data Independence is the ability to modify the physical schema (like storage devices or file structures) without changing the conceptual or external schemas.

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