OCP CBT Question 595

Please solve the following question.

A user attempts to execute a `TRUNCATE TABLE employees;` statement while another session has an uncommitted `UPDATE employees SET salary = 10000 WHERE employee_id = 101;` statement pending. What is the most likely outcome?

Understanding the interaction between DDL and DML operations is crucial for predicting database behavior under concurrency.

The TRUNCATE TABLE statement will proceed immediately, and the UPDATE will be rolled back.

The UPDATE statement will complete successfully, and then the TRUNCATE TABLE statement will execute.

The TRUNCATE TABLE statement will hang, waiting for the uncommitted UPDATE transaction to either commit or roll back.

Oracle will raise an error indicating a DDL conflict, and neither statement will proceed.