Physical DB Structure

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

(Continued from previous question...)

85. Physical DB Structure

ORACLE db consists of atleast one or more data files, two or more redo log files & one or more control files. The files of a db provide the actual physical storage for db info.

(Continued on next question...)

Other Job Interview Questions

• How to remove duplicate records from a table?
• Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
• How can you rebuild an index?
• Explain the use of TKPROF? What initialization parameter should be turned on to get full TKPROF output?
• What is your typical day like?
• What is the use of INCTYPE option in EXP command?
• Are you a nuts-n-bolts DBA or a tools-n-props DBA
• What are the types of SQL statement?
• Auditing
• What are the two panes that Appear in the design time pl/SQL interpreter?
• More...