×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
The Oracle Shared Server architecture reduces memory usage by reducing the number of server processes
required. To process a request for a server process, the following tasks are performed:
required. To process a request for a server process, the following tasks are performed:
1. A shared server picks up the request from the request queue and processes the request.
2. The dispatcher retrieves the response from the response queue.
3. A user sends a request to its dispatcher.
4. The dispatcher returns the response to the user.
5. The shared sever places the response on the calling dispatcher's response queue.
6. The dispatcher places the request into the request queue in the SGA. Put the above task in the order in
which they are performed.
2. The dispatcher retrieves the response from the response queue.
3. A user sends a request to its dispatcher.
4. The dispatcher returns the response to the user.
5. The shared sever places the response on the calling dispatcher's response queue.
6. The dispatcher places the request into the request queue in the SGA. Put the above task in the order in
which they are performed.
2.
Which RMAN command do you use to verify that the RMAN repository information is synchronized with the
actual files that exist on disk?
actual files that exist on disk?
3.
What is true regarding direct-load insert?
4.
When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you
perform?
perform?
5.
Which phrase best describes RMAN multiplexed backup sets?
6.
Which modifier is used to change listener parameters in the Listener Control utility environment?
7.
A user is running a long update batch file. Many tables are updated and all the statements are in one
transaction. Before the process is finished, the user machine lost power. When the user calls you, what should
you do as DBA?
transaction. Before the process is finished, the user machine lost power. When the user calls you, what should
you do as DBA?
8.
Your database is running in NOARCHIVELOG mode. Every night there is a backup taken using RMAN. During
your startup this morning you received en error regarding DISK 3 on your server. This is the location of your
data file for the SYSTEM tablespace.
Which option is open to you?
your startup this morning you received en error regarding DISK 3 on your server. This is the location of your
data file for the SYSTEM tablespace.
Which option is open to you?
9.
You created a database by using the Database Configuration Assistant. What must you do to access a user
account in the sample schemas?
account in the sample schemas?
10.
You company has four DBAs. You need to know which DBA added a column to the JOB_HISTORY table. The
database cannot be offline during work hours. Which LogMiner command can you use to find out which user
made the table change?
database cannot be offline during work hours. Which LogMiner command can you use to find out which user
made the table change?