What should you check first if you see multiple fragments in the SYSTEM tablespace?
While the interviewer asks you this question directly, it could also have been presented as a case during the interview. If asked in the form of a question, they expect you to compose a brief, concise response. If presented as a case, they expect you to demonstrate how you would perform this task or resolve the issue. This may involve using the appropriate commands, taking action, or creating code. It will also likely involve discussion of your response to the case, including alternative ways you could have resolved it.
If you are asked a question about a specific scenario and how to resolve it, provide the interviewer with a brief, direct response to their question. If you are presented with a case, first analyze what you are being asked to do and then formulate a plan to address the interviewer's scenario. Be prepared to justify your response and discuss alternative ways you could have resolved the situation.
"If I were to observe multiple fragments in the SYSTEM tablespace, I would ensure that database users didn't set the SYSTEM tablespace as their TEMPORARY or DEFAULT tablespace assignment. I could accomplish this by checking the DBA_USERS view. Once I confirmed that this was the case, I would reset the SYSTEM tablespace properly."
