What are the Characteristics of Data Files?

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

(Continued from previous question...)

176. What are the Characteristics of Data Files?

A data file can be associated with only one database. Once created a data file can’t change size. One or more data files form a logical unit of database storage called a tablespace.

(Continued on next question...)

Other Job Interview Questions

• What is an OLE?
• What are the different styles of activation of ole Objects?
• What does the term panel refer to with regarda to pages?
• Give the stages of instance startup to a usable state where normal users may access it.
• What is the difference between OLE Server & OLE Container?
• Which parameter can be used to set read level consistency across multiple queries?
• What are the three types of user exits available?
• How do you reference a Parameter?
• Explain the difference between a data block, an extent and a segment.
• Explain iostat, vmstat and netstat.
• More...