Home › GATE CSE › computerscience › Database Management Systems › If $R$ is your playlist and $S$ is your friend's…
If $R$ is your playlist and $S$ is your friend's, then $R - S$ returns
Aevery song in at least one of the playlists
Bsongs in your playlist that are NOT in your friend's
Csongs in both playlists
Dsongs in your friend's playlist that are not in yours
Answer & Solution
Correct answer: B. songs in your playlist that are NOT in your friend's
Difference keeps tuples from the first input that are NOT in the second. Order matters: $R - S$ is your-only; $S - R$ is friend-only. Songs in both would be intersection; in at least one is union.
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