What are the phases of a transaction? Select one:a. Control, check and read phaseb. Assert, commit and verify phase.c. Put, get and execute phase.d. Read, validation and write phase.e. Leech, seed and share phase

Fill the gaps in the following statements.A transaction that involves multiple database nodes is called a Answer 1 Question 1  transaction.The Answer 2 Question 1 level ensures that a transaction does not see any intermediate state or uncommitted changes made by other transactions.In the two-phase locking protocol, the Answer 3 Question 1 phase is where a transaction acquires all the locks it needs without releasing any locks.The Answer 4 Question 1 phase in the two-phase locking protocol is where a transaction releases its locks but cannot acquire any new locks.The term Answer 5 Question 1 refers to the ability of a database system to recover and maintain consistency after a failure.In a distributed system, the query Answer 6 Question 1 site is the location where an update transaction is initially issued.Most of the NoSQL databases can only provide Answer 7 Question 1 consistency, which is a weaker type of consistency.Answer 8 Question 1 consistency is a subtype of read-your-writes consistency that only guarantees that a process can read its own written data during a session.Answer 9 Question 1 consistency assures that when a newly written value is read the first time, all subsequent reads on this data item will not return any older valuesThe main benefits of replication include increased Answer 10 Question 1 performance and robustness against Answer 11 Question 1 of single nodes.

Which of the given options define a transaction correctly?A transaction consists of COMMIT or ROLLBACK in a database session.A transaction consists of either a collection of DML statements or a DDL or DCL or TCL statement to form a logical unit of work in a database session.A transaction consists of DDL statements on the database schema.A transaction consists of collection of DML and DDL statements in different sessions of the database.

Consider the following two transactions:T34: read(A);read(B);if A = O then B := B + 1;write(B).T35: read(B);read(A);if B = O then A := A + 1;write(A).Add lock and unlock instructions to transactions T31 and T32, so that they observe the two-phase locking protocol. (HINT: USE APPROPRIATE OPTIONS SUCH AS lock-S(A), lock-X(B), unlock(A), unlock(B), lock-S(B), lock-X(A))

Draw a state diagram and discuss the typical states that a transaction goes through during execution.

In the two-phase locking protocol, a transaction can release its locks before it has obtained all the locks it needs.Question 4AnswerTrueFalse