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 what are synonyms used for?
How to set up autotrace for a user account?
Explain an integrity constrains?
What is Java Pool in Oracle?
How to speed up webrick?
How to create a stored procedure in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Why does for update in oracle 8 cause an ora-01002 error?
Point the difference between translate and replace?
What are the restrictions in a oracle read only transaction?
Can we write dml statement in function in oracle?
How to insert a new row into a table in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
interview questions with answer for cts
Design database draw er diagram for a certain scenario ?