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

How to define default values for formal parameters?

786


What do you mean by a tablespace?

786


Explain the features of oracle?

804


How to use null as conditions in oracle?

774


what is the difference between substr and instr function in oracle?

824


How to select some rows from a table in oracle?

817


Where is the export dump file located?

801


How to create a table index?

799


Explain do view contain data?

785


Which is better Oracle or MS SQL? Why?

4433


Explain oracle data types with examples?

770


what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1948


how can we store any pdf file in oracle

1868


What is an oracle function?

836


What is a table index?

769