Which condition-tester returns TRUE if a subquery returns one or more records, and FALSE if the subquery returns no rows? MCQ with Answer and Explanation

Which condition-tester returns TRUE if a subquery returns one or more records, and FALSE if the subquery returns no rows?
A. EXISTS
B. IN
C. ANY
D. ALL
Answer: Option A
Solution (By JKSSB Mock Tests)
The EXISTS operator is used to test for the presence of any records in a subquery, returning TRUE as soon as a single matching row is encountered.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
The process of organizing a relational database schema to minimize data redundancy and prevent update anomalies is called what?
A. Denormalization
B. Generalization
C. Aggregation
D. Normalization

Correct Answer: Option D


Explanation:
Normalization is the systematic process of structuring relational database schemas to eliminate redundant data and maintain data integrity through decomposition.

This question belongs to: Computer Database Management System (DBMS)
Question #2
A view in DBMS is:
A. A backup of the database
B. An index on the table
C. A virtual table based on the result of a query
D. A physical copy of the table

Correct Answer: Option C


Explanation:
A view is a virtual table derived from one or more base tables.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which normal form eliminates all transitive dependencies?
A. 2NF
B. BCNF
C. 3NF
D. 1NF

Correct Answer: Option C


Explanation:
Third Normal Form (3NF) eliminates transitive dependencies, where non-key attributes depend on other non-key attributes.

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