Topic : Architecture

How do you know when the process is started?


Answer :

Using ps -ef grep process name

Show Answer Discuss

What is cursor?


Answer :

A cursor is a handle(a name or pointer) for the memory associated with a specific statement.

Show Answer Discuss

What is dedicated server configuration?


Answer :

In a dedicated server configuration a server process handles requests for a single user process.

Show Answer Discuss

What is a multi-threaded server configuration?


Answer :

In a multi-threaded server configuration many user processes share a group of server process.

Show Answer Discuss

What is a parallel server option in oracle?


Answer :

A configuration for loosely coupled systems where multiple instance share a single physical database is called parallel server.

Show Answer Discuss