Answer Posted / 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 |
Post New Answer View All Answers
Explain about your project and its relation to the current job position you are applying to?
How to fetch the row which has the max value for a column?
Is postgres faster than oracle?
What is the difference between substr and instr?
Difference between varchar and varchar2 data types?
How to write a query with an inner join in oracle?
Explain how are indexes update?
How to use "in out" parameter properly?
What is a package in oracle?
How does oracle handle read consistency?
What is proxy method?
How many data types are supported?
What happens if variable names collide with table/column names?
What is background process in Oracle?
Difference between pre-select and pre-query