If you have an example table, what is the best w

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

If you have an example table, what is the best way to get sizing data for the production table implementation?

Level: Intermediate
Expected answer: The best way is to analyze the table and then use the data provided in the DBA_TABLES view to get the average row length and other pertinent data for the calculation. The quick and dirty way is to look at the number of blocks the table is actually using and ratio the number of rows in the table to its number of blocks against the number of expected rows.

(Continued on next question...)

Other Job Interview Questions

• What is forms_DDL?
• What are the different default triggers created when Master Deletes Property is set to Non-isolated?
• How would you determine what sessions are connected and what resources they are waiting for?
• Where is the external query executed at the client or the server?
• What is a Database instance?
• Shall we create procedures to fetch more than one record?
• What does a Control file Contain?
• Where in the Oracle directory tree structure are audit traces placed?
• What is On-line Redo Log?
• Explain the difference between a data block, an extent and a segment.
• More...