Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Database instance ? Explain?
- 3 Answers
- 8386 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 |
How to display the hierarchy of employee and managers without using connect by prior.
What is a tns file?
What is difference between Rename and Alias?
List out the components of logical database structure of oracle database.
What happens to the indexes if a table is recovered?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
What is oracle analytical function?
How to compare dates in oracle sql?
Can we call procedure inside function in oracle?
How to increment dates by 1 in oracle?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
Oracle General 
