Question

COMMIT statement will help to save my transactions which are executed in same schema and multiple sessions. Tue or false

Answer 1

Explanation:

Jrkrkkrkrkrkrieoeiieiei3i3o3oi4i4i4

True.

Or false

Answertrue

Answer 2

False

• Not at all, only the session in which the COMMIT is completed.
• Oracle is implied to be the DBMS by the phrases session and schema; these terms have quite different connotations in other systems.)
• If your RDBMS supports XA, the only option for several sessions to handle a single transaction is to build a XA transaction. An SQL COMMIT in a session only impacts work done through that specific server connection.
• Only the session in which the COMMIT is finished, not at all.
• The words "session" and "schema," which have very different meanings in other systems, are used to denote Oracle as the DBMS.)
• The only way for many sessions to manage a single transaction if your RDBMS supports XA is to construct a XA transaction. Work done via that particular server connection is the only work that is affected by a SQL COMMIT in a session.

#SPJ2