A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher.
Under the Oracle Shared Server architecture, client-user processes connect to shared user processes.
Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher.
Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.
第1题:
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true?()
第2题:
Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?()
第3题:
Click the Exhibit button and examine the diagram, which illustrates the components performing tasks within an Oracle Shared Sever environment. Which task is being performed by component 4?()
第4题:
Under the Oracle Shared Server architecture, client-user processes ultimately connect to a()
第5题:
Which four occur during the processing of a request using Oracle Shared Server?()
第6题:
MD5 authentication is supported by the Junos OS
Server mode is not supported by the Junos OS
The Junos OS can provide a primary time reference
The Junos OS does not support the use of a boot server
第7题:
Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.
The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.
Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.
The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.
第8题:
DISPATCHERS and SHARED_SERVERS
DISPATCHERS and MAX_DISPATCHERS
MAX_DISPATCHERS and MAX_SHARED_SERVERS
SHARED_SERVER_SESSIONS and DISPATCHERS
第9题:
Displays only the list of default values
Displays only the list of all basic parameters
Displays the currently in effect parameter values
Displays only the list of all advanced parameters
Displays the list of all the parameter files of a database
Displays the current contents of the server parameter file.
第10题:
Customers is owned by Oracle Human Resources whereas Locations is owned by Oracle Receivables.
Items is owned by Oracle Purchasing whereas Locations is owned by Oracle Receivables.
Sales Force is owned by Oracle Order Management whereas Employees is owned by Oracle Human Resources.
Set of books is owned by Oracle General Ledger whereas Locations is owned by Oracle Human Resources.
Suppliers is owned by Oracle Purchasing whereas Units of Measure is owned by Oracle Inventory.
第11题:
A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher.
Under the Oracle Shared Server architecture, client-user processes connect to shared user processes.
Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher.
Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.
第12题:
Only two destinations per remote database can be specified.
Destination is an Oracle Net alias specified by using the SERVICE keyword.
The REOPEN attribute must be used when using remote archive log file destinations.
The service name is resolved by searching sqlnet.ora file for the remote database name.
第13题:
Which statement is true regarding the Network Time Protocol (NTP) on Junos devices?()
第14题:
Which statement is true regarding RMAN components?()
第15题:
Which statement is true regarding Oracle Shared Server architecture?()
第16题:
You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()
第17题:
Each target database requires its own recover catalog.
RMAN scripts can be stored in the recovery catalog or the target control file.
A channel is a stream of data to a device type and corresponds to one server session.
The RMAN executable interprets sever session commands and establishes connections to the target database.
第18题:
The cranes may be operated independently
The cranes may be interconnected for twin operation
When twinned,the crane rotation on the foundation assembly is unlimited
All of the above
第19题:
The PMON process registers the request in the response queue.
A shared sever places the process request in the response queue.
A request within the request queue is processed by an idle shared server process.
A dispatcher assigns a request from the request queue to and idle shared server process.
第20题:
You do not need to restore all the data files.
You do not need to open the database with the RESETLOGS operation
You do not need to perform a full backup after the RESETLOGS operation.
You do not need to recover all the data files to the same system change number (SCN).
第21题:
Synonyms can be created only for a table
Synonyms are used to reference only those tables that are owned by another user
A public synonym and a private synonym can exist with the same name for the same table
The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
第22题:
The dispatcher returns the response to the user.
The dispatcher places the request into the request queue.
The shared server places the response in the response queue.
The response is handed off to the next available dispatcher.
A shared server picks up the request from the request queue and processes the request.
第23题:
Oracle Net Service
Oracle HTTP Service
Oracle Paging Service
Internet Directory Service
第24题:
Allocates memory for RMAN backup and restore operations
Allocates memory for shared and private SQL areas
Contains a cursor area for storing runtime information about cursors
Contains stack space
Contains a hash area performing hash joins of tables