Which SQL command is used to create a new table? MCQ with Answer and Explanation

Explanation:
A Correlated Subquery is an inner query that references columns from the outer query, meaning it must be executed repeatedly for each row evaluated by the outer query.

Explanation:
Atomicity ensures that all operations within a transaction are completed successfully; otherwise, the transaction is aborted and all changes are rolled back.

Explanation:
Strategies to handle deadlocks include timeout, lock ordering, and detection with rollback.