What is FREEPAGE and PCTFREE in TABLESPACE creat

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

(Continued from previous question...)

What is FREEPAGE and PCTFREE in TABLESPACE createion?

PCTFREE: percentage of each page to be left free
FREEPAGE : Number of pages to be loaded with data betweem each free page

(Continued on next question...)

Other Job Interview Questions

• What does the CHECK Utility do?
• How many sub queries can you combine together?
• an I alter a table when other user is selecting some columns ...
• What is subselect? Is it different from a nested select ?
• What is a recovery log?
• Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
• In terms of DB2 indexing, what is the root page ?
• What is the function of buffer manager ?
• Explain the use of the WHERE clause?
• What is DB2 ( IBM Database 2 )?
• More...