FPSC - Database Administrator Model Papers -2026 — Test 2
Page 1 of 3
Question 1
Which statement cannot be rolled back because it commits automatically?
FPSC - Database Administrator Model Papers -2026
Question 2
What does COMMIT do?
FPSC - Database Administrator Model Papers -2026
Question 3
What does ROLLBACK do?
FPSC - Database Administrator Model Papers -2026
Question 4
What is the purpose of SAVEPOINT?
FPSC - Database Administrator Model Papers -2026
Question 5
Which action implicitly commits the current transaction in Oracle?
FPSC - Database Administrator Model Papers -2026
Question 6
Which ACID property means a transaction is 'all or nothing'?
FPSC - Database Administrator Model Papers -2026
Question 7
What does SELECT ... FOR UPDATE do?
FPSC - Database Administrator Model Papers -2026
Question 8
Which Oracle structure provides read consistency for queries?
FPSC - Database Administrator Model Papers -2026
Question 9
Which error is raised when two sessions deadlock?
FPSC - Database Administrator Model Papers -2026
Question 10
What is a database link in Oracle?
FPSC - Database Administrator Model Papers -2026