Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Database instance ? Explain?
- 3 Answers
- 8261 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 get maxsal , minsal, ename department wise in single query
What is a cursor and what are the steps need to be taken?
What is archive log in Oracle?
Explain coalesce function?
What is the max number of columns in an oracle table?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
What is the parameter mode that can be passed to a procedure?
Explain integrity constraints?
Describe an oracle table?
what r tyhe major differences between oracle 9i & 10g?
i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
master table and child table performances and comparisons in Oracle ?
Oracle General 
