What are the basic element of Base configuration

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

(Continued from previous question...)

197. What are the basic element of Base configuration of an oracle Database?

It consists of one or more data files. one or more control files. two or more redo log files. The Database contains multiple users/schemas one or more rollback segments one or more tablespaces Data dictionary tables User objects (table, indexes, views etc.,) The server that access the database consists of SGA (Database buffer, Dictionary Cache Buffers, Redo log buffers, Shared SQL pool) SMON (System MONito) PMON (Process MONitor) LGWR (LoG Write) DBWR (Data Base Write) ARCH (ARCHiver) CKPT (Check Point) RECO Dispatcher User Process with associated PGS

(Continued on next question...)

Other Job Interview Questions

• How do I eliminate the duplicate rows ?
• What is a deadlock? Explain.
• Do View contain Data?
• How do you switch to DOS prompt from SQL prompt?
• What is the “LOV of Validation” Property of an item? - What is the use of it?
• A user selects from a sequence and gets back two values, his select is:
• What is Database Link?
• How can a text file be attached to a report while creating in the report writer?
• Give two examples of how you might determine the structure of the table DEPT.
• When looking at the estat events report you see that you are getting busy buffer waits. Is this bad? How can you find what is causing it?
• More...