Oracle
1Z0-144 · Question #48
You create the following table and execute the following code: Which statement is true about the outcome of the above code?
The correct answer is B. It gives an error but saves the inserted rows and the update to the first row. error: variable buffer too small length of "Bookkeeper (Senior)" = 19 and more than field size of emp_temp.job
Interacting with the Oracle Database
Question
You create the following table and execute the following code:
Which statement is true about the outcome of the above code?
Exhibit
Options
- AIt executes successfully and all the rows are updated.
- BIt gives an error but saves the inserted rows and the update to the first row.
- CIt gives an error but saves the inserted rows; however, no rows are updated.
- DIt gives an error and all the data manipulation language (DML) statements are rolled back
How the community answered
(38 responses)- A16% (6)
- B74% (28)
- C5% (2)
- D5% (2)
Explanation
error: variable buffer too small length of "Bookkeeper (Senior)" = 19 and more than field size of emp_temp.job
Topics
#DML transactions#savepoints#error handling#rollback
Community Discussion
No community discussion yet for this question.