Computer Science · DBMS
A nested query using the EXISTS clause is preferred over IN primarily because:
- 1EXISTS supports arithmetic operations
- 2EXISTS enforces referential integrity
- 3EXISTS always returns aggregated results
- 4EXISTS checks only for the presence of rows and can short-circuit, improving efficiency✓
Correct answer
EXISTS checks only for the presence of rows and can short-circuit, improving efficiency
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on DBMS?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · DBMS