Oracle
1Z0-032 · Question #30
1Z0-032 Question #30: Real Exam Question with Answer & Explanation
The correct answer is B. The INSERT statement fails and the statement is rolled back automatically.. See the full explanation below for the reasoning.
Question
In your database, you executed an INSERT statement on the PRDTB table to insert a record. The Oracle 1Z0-032 Exam tablespace does not have sufficient free space and resumable space allocation feature is not enabled. What would happen in this case?
Options
- AThe user session executing the INSERT statement gets terminated.
- BThe INSERT statement fails and the statement is rolled back automatically.
- CThe data file containing the PRDTB table segment gets corrupted and, therefore, needs recovery.
- DThe least recently used (LRU) algorithm is used to get free space and a new record is inserted.
Community Discussion
No community discussion yet for this question.