DEVFYI - Developer Resource - FYI

What is a Database instance ? Explain

ORACLE Interview Questions and Answers (Part 1)

(Continued from previous question...)

70. 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 process can be shared by all users. The memory structure that are used to store 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 Interview Questions