Home › GATE CSE › computerscience › Database Management Systems › Per the SQL standard, `column IN (subquery)` is …
Per the SQL standard, `column IN (subquery)` is equivalent to
Acolumn = ALL (subquery)
Bcolumn < ALL (subquery)
Ccolumn > ANY (subquery)
Dcolumn = ANY (subquery)
Answer & Solution
Correct answer: D. column = ANY (subquery)
IN tests set membership: is the column's value equal to at least one of the values in the set? That is exactly = ANY. `= ALL` would require equality to EVERY value (impossible unless the subquery is a single repeated value). `<` and `>` ANY/ALL test ordering, not membership.
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