Oracle
1Z0-052 · Question #110
1Z0-052 Question #110: Real Exam Question with Answer & Explanation
The correct answer is A: Add a data file to the SMD tablespace.. See the full explanation below for the reasoning.
Question
The user HR receives the following error while inserting data into the TTK table: ERROR at line 1: ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation, you find that SMD is a small file tablespace. Which three action would allow the user to insert data? (Choose three.)
Options
- AAdd a data file to the SMD tablespace.
- BAdd a data file to the temporary tablespace associated with the user HR.
- CResize the data file associated with the SMD tablespace to make it larger.
- DAlter the data file associated with the SMD tablespace to grow automatically.
- EChange the segment space management for the SMD tablespace to automatic.
Community Discussion
No community discussion yet for this question.