DML Statements & Locking — Test 1
Page 1 of 2
Question 1
Which statement correctly deletes the employee with ID 5?
FPSC - Database Administrator Model Papers -2026
Question 2
Which statement correctly updates a salary?
FPSC - Database Administrator Model Papers -2026
Question 3
Which UPDATE correctly sets a value from a subquery?
FPSC - Database Administrator Model Papers -2026
Question 4
In a conditional multitable insert, what does INSERT FIRST do?
FPSC - Database Administrator Model Papers -2026
Question 5
What does PRAGMA AUTONOMOUS_TRANSACTION do in PL/SQL?
FPSC - Database Administrator Model Papers -2026
Question 6
Which statement about Oracle's locking is correct?
FPSC - Database Administrator Model Papers -2026
Question 7
Which statement manually locks a table in exclusive mode?
FPSC - Database Administrator Model Papers -2026
Question 8
What does SELECT ... FOR UPDATE NOWAIT do when the rows are already locked?
FPSC - Database Administrator Model Papers -2026
Question 9
Which is Oracle's default transaction isolation level?
FPSC - Database Administrator Model Papers -2026
Question 10
Which statement makes a transaction see a consistent snapshot and permits no DML?
FPSC - Database Administrator Model Papers -2026