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

What is where clause in oracle?

526


What is raw datatype?

588


Difference between oracle's plus (+) notation and ansi join notation?

568


What are the ansi data types supported in oracle?

515


How do I recompile a procedure in oracle?

527






How to apply filtering criteria at group level in oracle?

577


What suggestions do you have to reduce the network traffic?

538


Explain an extent?

656


If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1789


what is a Nested Loop join?

1560


How to connect ms access to oracle servers?

546


How to create a table index?

558


How to count duplicated values in a column in oracle?

548


How to view existing locks on the database?

543


What is Redo Log Buffer in Oracle?

623