DML & Transactions — Test 1
Page 1 of 2
Question 1
Which statement correctly inserts a row into the EMP table?
FPSC - Database Administrator Model Papers -2026
Question 2
What happens if an UPDATE statement has no WHERE clause?
FPSC - Database Administrator Model Papers -2026
Question 3
Which statement cannot be rolled back because it commits automatically?
FPSC - Database Administrator Model Papers -2026
Question 4
What does COMMIT do?
FPSC - Database Administrator Model Papers -2026
Question 5
What does ROLLBACK do?
FPSC - Database Administrator Model Papers -2026
Question 6
What is the purpose of SAVEPOINT?
FPSC - Database Administrator Model Papers -2026
Question 7
Which action implicitly commits the current transaction in Oracle?
FPSC - Database Administrator Model Papers -2026
Question 8
Which ACID property means a transaction is 'all or nothing'?
FPSC - Database Administrator Model Papers -2026
Question 9
What does SELECT ... FOR UPDATE do?
FPSC - Database Administrator Model Papers -2026
Question 10
Which Oracle structure provides read consistency for queries?
FPSC - Database Administrator Model Papers -2026