Database Administrator (DBA) Question:
What is a Database instance?
Answer:
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.
| Previous Question | Next Question |
| What is an Index? How it is implemented in Oracle Database? | What is the use of ANALYZE command? |