Q 1. Which of the following describes an architecture that specifies the multiple layers between a user and data, and can include web servers and application servers?
a. Client-server
b. Multitier
c. Dedicated server
d. Shared server
Q 2. In the shared server architecture, which type of process is an incoming user process connected to first, after it has been validated by the listener?
a. Dedicated server process
b. Shared server process
c. Dispatcher process
d. A second user process
Q 3. Which of the following memory areas store session information when the shared server architecture is used?
a. Large pool
b. Shared server pool
c. Database buffer cache
d. Log buffer
Q 4. When a database administrator executes the lsnrctl stop
command, what happens to any existing database connections?
a. Connections are immediately disconnected and their transactions are rolled back
b. Connections are immediately disconnected and their transactions are automatically committed
c. Connections are not disconnected...