Pregunta de entrevista de Tata Consultancy Services

Can you differentiate Instance and Database?

Respuesta de la entrevista

Anónimo

22 ago 2024

In Oracle, Instance and database are two separate components but work together. Instance resides on RAM and it is the way users speak to database. The user data resides inside data files which reside on Hard Disks. Users connect to database instance and ultimately instance speaks with database. Instance can also be defined as combination of memory structures and background processes.