What is a Database instance ? Explain?

Answer Posted / nishi

A database instance is a set of memory structures that manage database files. A database is a set of physical files on disk created by the CREATE DATABASE statement. The instance manages its associated data and serves the users of thedatabase.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1897


What is oracle and what are its different editions?

817


Explain a private synonyms?

843


What is the dynamic sql in oracle?

828


Which is better Oracle or MS SQL? Why?

4476


Explain the use of Merge statement in oracle 11g

812


What is a connect identifier?

797


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1968


How to bring a tablespace online?

761


List out the difference between commit, rollback, and savepoint?

833


What does sharding mean?

787


What are the different types of modules in oracle forms?

768


What are the different types of synonyms?

853


What is PL/SQL ?

1432


How to login to the server without an instance?

848