Multiple Choice
The ____ parameter for the SET TRANSACTION forces all queries to see a snapshot of data prior to the start of a transaction,regardless of how many DML statements are within a transaction.
A) READ ONLY
B) ISOLATION LEVEL READ COMMITTED
C) USE ROLLBACK SEGMENT
D) READ WRITE
Correct Answer:
Verified
Correct Answer:
Verified
Q19: _ are two-dimensional storage structures comprised of
Q20: A transaction is completed on execution of
Q21: The _ statement allows you to change
Q22: Database changes are undone using a(n)_ statement.
Q23: DDL statements make permanent changes to the
Q25: A transaction starts whenever a DML statement
Q26: A _ INSERT statement adds to more
Q27: The _ statement makes pending changes permanent
Q28: Describe the syntax for the single table
Q29: The SET TRANSACTION statement is mandatory for