Data Blocks

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

(Continued from previous question...)

91. Data Blocks

At the finest level of granularity, an ORACLE db??s data is stored in data blocks. One data block corresponds to a specific number of bytes of physical db space on a disk. A data block size is specified when the db is created. A db uses & allocates free db space in ORACLE data blocks.

(Continued on next question...)

Other Job Interview Questions

• Is it possible to link two groups inside a cross products after the cross products group has been created?
• What is a trace file and how is it created?
• How can you enable a trace for a session?
• What is an index? How it is implemented in Oracle database?
• What?s the command to change the SQL prompt name?
• How do you set up tablespaces during an Oracle installation?
• What are different types of modules available in oracle form?
• (On UNIX) When should more than one DB writer process be used? How many should be used?
• What is the use of break group?
• How to run SQL script from a Unix Shell?
• More...