What is a database instance? Explain.

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

(Continued from previous question...)

75. What is a database instance? Explain.

A database instance (Server) is a set of memory structure and background processes that access a set of database files. The processes can be shared by all of the users.
The memory structure that is used to store the most queried data from database. This helps up to improve database performance by decreasing the amount of I/O performed against data file.

(Continued on next question...)

Other Job Interview Questions

• What is the use of Control File?
• Explain the use of TKPROF? What initialization parameter should be turned on to get full TKPROF output?
• Can you pass data parameters to forms?
• What are the different types of Record Groups?
• What are the different display styles of list items?
• Is it possible to modify an external query in a report which contains it?
• (On UNIX) When should more than one DB writer process be used? How many should be used?
• Can objects of the same Schema reside in different tablespaces?
• How can a button be used in a report to give a drill down facility?
• What are the different windows events activated at runtimes?
• More...