Isolation levels can be set...

The correct answer is A. Per transaction C. Per session D. Globally. The value of isolation_level should be READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, or SERIALIZABLE. The first form of the statement sets the server's global isolation level. It applies to all new client connections established from that point on. Existing connections are u

MySQL Storage Engines

Question

Options

APer transaction
BPer user name
CPer session
DGlobally

How the community answered

(33 responses)

A
76% (25)
B
24% (8)

Explanation

The value of isolation_level should be READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, or SERIALIZABLE. The first form of the statement sets the server's global isolation level. It applies to all new client connections established from that point on. Existing connections are unaffected. The second form sets the isolation level for the current client connection only and applies to transactions the client performs from that point on. The third form sets the isolation level only for the current client's next transaction. 1. SET GLOBAL TRANSACTION ISOLATION LEVEL isolation_level; 2. SET SESSION TRANSACTION ISOLATION LEVEL isolation_level; 3. SET TRANSACTION ISOLATION LEVEL isolation_level;

Topics

#isolation levels#session scope#global configuration#SET TRANSACTION

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice