QUESTION 12 OF 30

What command can you use if you want to see the statistics of an Oracle table?

Interviewers are likely to ask you about different commands used to tune an Oracle database. They want to know that you understand how to do this and the commands used to accomplish individual tasks. These may be individual questions similar to this one or be presented in the form of a case in which you are asked to execute the command or create code required to accomplish the task designated by the interviewer.

It is typical for interviews for technical roles such as an Oracle administrator and tuner to include cases. These are scenarios created by the interviewer which you are asked to resolve using your knowledge of this job. You can prepare for these cases by reviewing the processes, procedures, and commands you use to execute tasks when optimizing an Oracle DBMS. Practicing these scenarios before the interview will familiarize you with them and enable you to complete the case during the interview.

"The command I typically use to view the statistics of an Oracle table is - select num_rows, blocks, empty_blocks from dba_tables where tab_name'emp'."

Unlock all 30 Oracle Performance Tuning questions

Unlock expert responses to complex tuning scenarios that database architects evaluate.

Get Started

Previous Question Next Question

Oracle Performance Tuning Mock Interview

What command can you use if you want to see the statistics of an Oracle table?

Unlock all 30 Oracle Performance Tuning questions

30 Oracle Performance Tuning Interview Questions & Answers