What would you do if you needed to get the index of a table and identify which column the index is on?
As the interview progresses, the interviewer's questions will become more detailed and complex. This indicates that they are gaining confidence in your capabilities and want to explore your qualifications in greater detail. When this occurs, it is likely that the interviewer has already decided about your qualification for the role and is using these questions to differentiate you from other qualified candidates.
As the questions become more detailed and complex, your answers should follow suit. You can begin to embellish your responses a little more, include additional details in your answers, or provide background information to put your answers into context. Alternatively, it is okay to continue to respond with brief, concise answers, encouraging the interviewer to ask follow-up questions.
"If I needed to get the index of a table and identify which column the index is located on, I would use two commands. These are - dba_indexes and dba_ind_columns."
