Sollicitatievraag bij Tata Consultancy Services

Can you differentiate Instance and Database?

Antwoord op sollicitatievraag

Anoniem

22 aug 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.