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 are the major difference between truncate and delete?

519


What is different types of joins?

577


Explain what are the different type of segments?

580


How to omit columns with default values in insert statement in oracle?

579


How do I use unicode codesets with the weblogic jdriver for oracle driver?

552






How to insert a new row into a table in oracle?

591


What do you understand by a database object? Can you list a few of them?

610


Use of an integrity constraint is better to validate data. Explain

547


How to update values on multiple rows in oracle?

602


What is logical backup in oracle?

580


Why do we need integrity constraints in a database?

588


when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1477


What are ddl statements in oracle?

592


What is a private synonym?

1086


What is BBED in Oracle?

687