Database Administration Interview Question:

Explain What is a database instance?

Submitted by: Administrator

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.
Submitted by: Administrator