WorksheetsOracle ch4
Total questions: 20
Worksheet time: 10mins
You connect to the database using the command: sqlplus scott/tiger@abc.com:1522/orcl. To which database are you connecting?
abc.com
tiger
orcl
scott
What is the name of the piece of shared memory that client connections are bound to during communications via Shared Server?
Program Global Area
System Global Area
Virtual Circuit
Database Buffer Cache
Your database is open and the listener LISTENER is running. The new DBA stops the listener using the command: LSNRCTL> STOP. What happens to the sessions that are presently connected to the database instance?
Sessions are able to perform only queries
Sessions are not affected and continue to function normally
Sessions are terminated and the active transactions are rolled back
Sessions are not allowed to perform any operations until the listener is started
Which configuration files are used to configure the listener? Select all that apply.
listener.ora
listener.conf
tnsnames.ora
sqlnet.ora
When using the shared server process architecture, the UGA portion of the PGA is relocated into the SGA.
True
False
Which is the Name Resolution Method that doesn't support advanced connection options?
External naming
Easy Connect naming
Local naming
Directory naming
What are the two correct statements about the Shared Server? Select all that apply.
When a connection request arrives, the listener spawns a dedicated server process
Each service that participates in the shared server architecture has at least one dispatcher process
When a connection request arrives, the listener does not spawn a dedicated server process
Connection requests are routed to the highest loaded dispatcher that is servicing a given service name
Which of the following is not correct related to Oracle Net Listener?
Is the gateway to the Oracle instance for all local user connections
Is the gateway to the Oracle instance for all nonlocal user connections
A single listener can service multiple databases
A single listener can service thousands of client connections
Which are the two true statements about Oracle Net? Select all that apply.
Is located on each client computer
Is checked at the time of commit
Oracle Net is not responsible for maintaining the session
Is located on the database server
Which is the incorrect option regarding listener configuration requirements?
Network protocol
Name or IP address of the server that the listener will run on
Operating System of the server that the listener will run on
Port that you want the listener to monitor
What is Oracle Net?
It is background component for application connections to the database
It is an original protocol used through internet
It doesn’t include an active process called the Oracle Net Listener
It is a Parameter file
The Listener Control Utility doesn’t enable you to control which task?
Starting the listener
Stopping the listener
Checking the status of the SYS user
Reinitializing the listener from the configuration file parameters
With dedicated server processes, there is:
one-to-four ratio of server processes to user processes
one-to-one ratio of server processes to user processes
one-to-two ratio of server processes to user processes
Database administration must be performed using shared servers.
True
False
Database administration must be performed using dedicated servers.
True
False
In the shared server process architecture, when a connection request arrives, the listener:
spawns a dedicated server process
Doesn’t have any action
maintains a list of dispatchers that are available for each service name
all the other options
What is the Oracle Net name resolution method that requires LDAP with information loaded?
Easy connect naming
Local naming
Directory naming
External naming
After a network session is established, Oracle Net acts as the data courier for both the client application and the database server.
True
False
To make a client or middle-tier connection, Oracle Net doesn’t require the client to know the:
Host where the listener is running
Port that the listener is monitoring
Protocol that the listener is using
Listener name
Which is the naming resolution method that has a connection string like: SQL>CONNECT hr/hr@db.us.oracle.com:1521/dba11g?
Easy connect naming
Local naming
Directory naming
External naming
