Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Database instance ? Explain?
- 3 Answers
- 8199 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 |
In oracle there is column command, how will you explain that?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
How to export your own schema?
Can you tell me how to add new column in existing views?how?How is possible?
What is define in oracle?
Will you be able to store pictures in the database?
Explain the use of Merge statement in oracle 11g
How to write a query with an inner join in oracle?
Explain about integrity constraint?
How to start instance with a minimal initialization parameter file?
How to upsert (update or insert into a table)?
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
Oracle General 
