What is a Database instance ? Explain?
- 3 Answers
- 7246 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 |
Explain the use of grant option in exp command.
What is query image?
Explain drop constraint oracle?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
What is Water Mark in Oracle?
How do I learn what codesets are available in oracle?
How would you begin to troubleshoot an ORA-3113 error?
What are the different types of synonyms?
What are the different types of trigger and explain its various uses and functions?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
Please explain compound trigger in oracle?
Oracle General 
