Evolution of Oracle - Quiz Explanation

The correct answers are indicated below, along with the text that explains the correct answers.

 
1. When it is important to provide an Oracle database that will be able to start small and later support thousands of users, the best approach is to use
Please select the best answer.
  A. TCP/IP
  B. Oracle Parallel Server
  C. Oracle Net Services with SQL*Net
  D. IBM SNA
 

The correct answer is B.


When it is important to provide an Oracle database that will be able to start small and later support thousands of users, the best approach is to use the Oracle Parallel Server. OPS enables many processors to share a single Oracle database. As the number of users increases, the number of processors can be increased. A is incorrect because TCP/IP is a protocol that does not help with scalability. C is incorrect because Oracle Net Services is used only for distributed systems and does not address scalability. D is incorrect because IBM SNA is a mainframe gateway and has nothing to do with scalability.

2. The most popular communication protocol for Oracle Net Services on UNIX systems is
Please select the best answer.
  A. TCP/IP
  B. SPX
  C. SNA
  D. DecNet
 

The correct answer is A.


The most popular communication protocol for Oracle Net Services on UNIX systems is TCP/IP. B, C, and D are incorrect because SPX, SNA, and DecNet are not widely used communications protocols. This is because of the widespread use of TCP/IP with UNIX-based systems.

3. The popularity of the Internet has created which of the following scenarios?
Please select the best answer.
  A. Widely distributed Oracle databases across a wide-area network
  B. Distributed databases with WebServer gateways
  C. Networks of networked databases
  D. ADA databases
 

The correct answer is B.


The popularity of the Internet has created distributed databases with WebServer gateways. (Oracle WebServer is the networking tool that enables an Internet user to access an Oracle database.) A is incorrect because WAN Oracle systems are not on the Internet. C is incorrect because networked databases do not use the Internet.