Oracle
1Z0-144 · Question #2
View the exhibit and examine the structure of the EMPLOYEE table. EMPLOYEE_SEQ is an existing sequence. Examine the following block of code: Which statement is true about the above block of code?
The correct answer is A. It consists of two transactions. See the full explanation below for the reasoning.
Question
View the exhibit and examine the structure of the EMPLOYEE table. EMPLOYEE_SEQ is an existing sequence. Examine the following block of code:
Which statement is true about the above block of code?
Exhibit
Options
- AIt consists of two transactions
- BIt consists of a single transaction,
- CThe data is automatically committed after the block execution ends,
- DIt gives an error on execution because sequences cannot be used in anonymous blocks.
How the community answered
(29 responses)- A79% (23)
- B10% (3)
- C7% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.