Oracle
1Z0-043 · Question #118
1Z0-043 Question #118: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-043 to reveal the answer and full explanation for question #118. The question stem and answer options stay visible for context.
Question
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table: ERROR at line 1: ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating, you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed? (Choose two)
Options
- ADrop and re-create the inbox.
- BCoalesce the ORDERS_IND index.
- CCoalesce the INDEXES tablespace.
- DDrop and re-create the ORDERS table.
- ERebuild the index online and move it to another tablespace.
Unlock 1Z0-043 to see the answer
You've previewed enough free 1Z0-043 questions. Unlock 1Z0-043 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.