| Back to Questions Page |
| |
| Question |
What is Dedicated Server Configuration? |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | In a Dedicated Server Configuration a Server Process handles
requests for a Single User Process
 |
| Siva.k |
| |
| |
| Question |
What are the functions of SMON? |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | smon is background process in a sga.
its name is system monitor.function is monitering the system
its used for database recovery when database is crash.  |
| Ankur Aggarwal |
| |
| |
| Answer | smon is used for rolling forward the committed data and
rolling back the rollback data.smon writes commited data
from log buffer to data files.  |
| Pravin Pardeshi |
| |
| |
|
|
| |
| Question |
What is the function of ARCH? |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | its a background process.its used when archive log parameter
enabled.its making archive file.archive file is a replica
of redolog file.  |
| Ankur Aggarwal |
| |
| |
| Question |
What is Shared SQL Area? |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | A Shared SQL area is required to process every unique SQL
statement submitted to a database and contains information
such as the parse tree and execution plan for the
corresponding statement.
 |
| Siva.k |
| |
| |
| Question |
What is a Multi-threaded Server Configuration? |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | In a Multi-threaded Server Configuration many user processes
share a group of server process.
 |
| Siva.k |
| |
| |
|
| |
|
Back to Questions Page |