Which of the following is a property of a transaction that ensures that the database remains in a valid state before and after the transaction? MCQ with Answer and Explanation

Explanation:
The AS keyword is used to assign a temporary alias name to an expression, column, or table within an SQL statement query execution context.

Explanation:
Shared locks allow multiple transactions to read a resource, while exclusive locks allow only one transaction to write.

Explanation:
An Insertion Anomaly occurs when certain facts cannot be recorded in a database table without falsely manufacturing or requiring the presence of other unrelated facts.