Home › GATE CSE › computerscience › Database Management Systems › A correlated subquery differs from an uncorrelat…
A correlated subquery differs from an uncorrelated one in that
Ait always returns exactly one row
Binner uses outer columns; re-runs per outer row
Cit cannot be used inside WHERE clauses
Dit is forbidden in standard SQL
Answer & Solution
Correct answer: B. inner uses outer columns; re-runs per outer row
A correlated subquery uses values from the outer row in its own predicate, so it must be re-evaluated for each outer row. An uncorrelated subquery can be evaluated once and cached. Correlated subqueries are slower per row but more expressive; they are fully standard SQL.
Related questions
The main reasons production DBMSs avoid shadow paging in favour of WAL are that shadow pagWhat is the purpose of a Compensation Log Record (CLR) in ARIES?ARIES recovery is structured as exactlyFuzzy checkpoints differ from naive checkpoints byIn standard log-based recovery, the order of operations isAfter a crash, with checkpointing, the recovery system scans the logA complete log record for a write operation includesPer WAL semantics, a transaction is officially committed at the moment