What does the EXISTS operator do in SQL? MCQ with Answer and Explanation

What does the EXISTS operator do in SQL?
A. Compares two values
B. Checks if a value is null
C. Tests for the existence of rows returned by a subquery
D. Performs arithmetic
Answer: Option C
Solution (By JKSSB Mock Tests)
EXISTS returns TRUE if the subquery returns at least one row, otherwise FALSE.

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 the main advantage of using a DBMS?
A. Data integrity and security
B. Reduced application development time
C. All of the above
D. Data sharing and concurrency control

Correct Answer: Option C


Explanation:
DBMS provides numerous benefits including data sharing, concurrency control, integrity, security, and reduces development time.

This question belongs to: Computer Database Management System (DBMS)
Question #2
The intentional process of introducing redundant data into a normalized database structure to optimize read query performance is called what?
A. Normalization
B. Fragmentation
C. Denormalization
D. Decomposition

Correct Answer: Option C


Explanation:
Denormalization is a strategy applied to normalized databases where redundant data is selectively added to speed up complex read queries by minimizing costly table joins.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which type of database storage anomaly occurs when adding new data to a table is blocked because other unrelated data is missing?
A. Update Anomaly
B. Deletion Anomaly
C. Insertion Anomaly
D. Modification Anomaly

Correct Answer: Option C


Explanation:
An Insertion Anomaly occurs when certain facts cannot be recorded in a database table without falsely manufacturing or requiring the presence of other unrelated facts.

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