Computer Science · SQL Subqueries
Which of the following statements regarding the operational rules and characteristics of SQL Subqueries are correct? A. The inner query executes first, and its result is utilized by the outer SQL statement. B. Subqueries must always be enclosed in parentheses and can appear in WHERE, FROM, or HAVING clauses. C. The ORDER BY clause can be used inside a subquery to organize data before passing it to the outer query. D. A subquery creates a lookup structure that physically stores data to speed up retrieval operations. Choose the most appropriate answer from the options given below:
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1B, C and D Only
- 2A, C and D Only
- 3B and C Only
- 4A and B Only✓
Correct answer
A and B Only
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!
Online Test Series
Start Free Mock Test →Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Chapter Practice
Practice SQL Subqueries MCQs →Want more practice questions on SQL Subqueries?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · SQL Subqueries