Domanda di colloquio di Tata Consultancy Services

Can you differentiate Instance and Database?

Risposta di colloquio

Anonimo

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.