Quiz for SET TRANSACTION

Q1: Which SQL command is used to set properties like isolation level for a transaction?

A. CONFIG TRANSACTION B. SET SESSION C. SET TRANSACTION D. INIT TRANSACTION

Q2: What is the primary purpose of the SET TRANSACTION command?

A. To define transaction boundaries B. To set isolation level C. To rollback transaction D. To start a new database session

Q3: Which clause is commonly used with SET TRANSACTION to define how transactions interact?

A. ISOLATION LEVEL B. ROLLBACK SEGMENT C. AUTOCOMMIT D. COMMIT LEVEL

Q4: Which isolation level ensures that dirty reads are prevented?

A. READ UNCOMMITTED B. READ COMMITTED C. SERIALIZABLE D. REPEATABLE READ

Q5: What does SET TRANSACTION READ ONLY do?

A. Allows only SELECT queries in the transaction B. Allows all DML operations C. Commits automatically D. Disables rollback

Q6: Which isolation level is the strictest in SQL?

A. READ COMMITTED B. READ UNCOMMITTED C. REPEATABLE READ D. SERIALIZABLE

Q7: When must SET TRANSACTION be issued within a transaction?

A. Before any DML B. After COMMIT C. After any SELECT D. After ROLLBACK

Q8: Which command will set a transaction to SERIALIZABLE?

A. SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; B. SET ISOLATION LEVEL SERIALIZABLE; C. TRANSACTION LEVEL SERIALIZABLE; D. SET LEVEL SERIALIZABLE;

Q9: Which command starts a read-only transaction?

A. SET TRANSACTION READ ONLY; B. BEGIN TRANSACTION READ; C. START READ ONLY TRANSACTION; D. SET READ ONLY TRANSACTION;

Q10: What will happen if SET TRANSACTION is issued after a DML statement?

A. It will succeed B. It will throw an error C. It will be ignored D. It will commit automatically

Q11: Which of the following is NOT a valid isolation level?

A. READ UNCOMMITTED B. READ COMMITTED C. READ DEFERRED D. SERIALIZABLE

Q12: Which isolation level can lead to phantom reads?

A. READ COMMITTED B. REPEATABLE READ C. READ UNCOMMITTED D. SERIALIZABLE

Q13: Which isolation level avoids all concurrency problems?

A. READ COMMITTED B. SERIALIZABLE C. READ UNCOMMITTED D. REPEATABLE READ

Q14: What is the default isolation level in most databases like PostgreSQL or Oracle?

A. READ UNCOMMITTED B. READ COMMITTED C. REPEATABLE READ D. SERIALIZABLE

Q15: Can you change isolation level mid-transaction using SET TRANSACTION?

A. Yes B. No C. Only with admin rights D. Only in debug mode

Q16: Which clause in SET TRANSACTION is used to prevent any changes to the database?

A. READ COMMITTED B. READ UNCOMMITTED C. READ ONLY D. SERIALIZABLE

Q17: Which type of transaction uses SET TRANSACTION READ WRITE?

A. Default transactions B. System transactions C. Explicitly writable transactions D. Hidden transactions

Q18: Which SQL command allows setting the rollback segment in Oracle?

A. SET ROLLBACK SEGMENT B. SET TRANSACTION C. BEGIN SEGMENT D. ROLLBACK TO

Q19: What will SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED allow?

A. Dirty reads B. Repeatable reads C. Serializable reads D. No reads

Q20: How many times can you use SET TRANSACTION in a transaction?

A. Once B. Twice C. Unlimited D. After each DML

Q21: What is the syntax to set isolation level to REPEATABLE READ?

A. SET TRANSACTION ISOLATION LEVEL REPEATABLE READ; B. SET ISOLATION LEVEL REPEATABLE; C. TRANSACTION SET REPEATABLE; D. SET LEVEL REPEATABLE READ;