Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Database instance ? Explain?
- 3 Answers
- 8090 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sawant
A database instance (Server) is a set of memory structure
and background processes that access a set of database files.
The process can be shared by all users.
The memory structure that are used to store most
queried data from database. This helps up to improve
database performance by decreasing the amount of I/O
performed against data file.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / krishna mohan mishra
The database instance refers to a complete database
environment. It includes RDBMS software, table structure,
stored procedures and other functions. It is normally used
when administrators tend to describe multiple instances of
the same database. It is also called as environment in
technical terms.
---Krishna Mohan Mishra
| Is This Answer Correct ? | 1 Yes | 2 No |
What is SAVE POINT ?
what is the difference between oracle enterprise edition and oracle express edition?
What are the types of trigger in oracle?
How to update a table row with a record?
difference between truncate and delete ,drop?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is a user account in oracle?
What is a lookup table in oracle?
Please explain joins in oracle?
How many types of segments in Oracle?
What are main difference between Stored Procedure and Functions.
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
Oracle General 
