OCP fundamental II Chapter 1 Introduction to Network Administration- Review Questions

Chapter 1 - Introduction to Network Administration
Review Questions

1. All of the following are examples of networking architectures except:
A. Client/server
B. N-tierC. Single-tier
D. Two-tie
E. All of the above are examples of network architectures.

Ans E.
All of these are examples of network connectivity configurations. Networking can be as simple as a dumb terminal connected directly to a server via a serial connection. It can also be as complex as an n-tier architecture that may involve clients, middleware, the Internet, and database servers.
----------

2. You manage one non-Oracle database and several Oracle databases. An application needs to access the non-Oracle databases as if it were part of the Oracle databases. What tool will solve this business problem? Choose the best answer.
A. Oracle Advanced Security
B. Oracle Connection Manager
C. Heterogeneous Services
D. Oracle NetE. None of the above

Ans C.
Oracle Advanced Security would not solve this application problem becauseit addresses security and not accessibility to non-Oracle databases. Oracle Net would be part of the solution, but another Oracle Network component is necessary. Connection Manager would also not be able to accommodate this requirement on its own. Heterogeneous Services is the correct answer because these services providecross- platform connectivity to non-Oracle databases.
----------

3. Which of the following is true about Oracle Net?
A. It is not an option included in the Oracle Enterprise installation.
B. It only works on TCP/IP platforms.
C. It has an open API.
D. It is never installed directly on a client workstation.

Ans.
C. Oracle Net is included in the Oracle Enterprise installation and works with a variety of protocols. It also has a client and a server component. The only statement that is true about Oracle Net is that it has an open Applications Program Interface (API), which means that third-party software can write to these specifications to interact directly with Oracle Net.
--------

4. A DBA wants to centrally administer all of the Oracle network services in a large Oracle9i installation with many network services. Which facility wouldbest provide this functionality at minimal cost?
A. Advanced Security
B. Heterogeneous Services
C. Oracle Shared Server
D. Oracle Internet Directory

Ans D.
Advanced Security, Heterogeneous Services, and Oracle Shared Server would not provide a solution to this business need because none of these address the issue of centrally managing network services. The best solution to the problem is the Oracle Internet Directory because it would facilitate centralized naming.

------
5. What are TCP/IP, DECnet, and LU6.2 all examples of?
A. Computer programming languages
B. Oracle Net connection tools
C. Networking protocols
D. Network programming languages

Ans C.
TCP/IP, DECnet, and LU6.2 are all examples of network protocols.

------

6. Which feature of Oracle Net best describes this statement: "Oracle Net supports TCP/IP and LU6.2."?
A. GUI tools integration
B. Robust tracing and diagnostic tools
C. Zero configuration on the client
D. Network transport protocol support

Ans D.
Oracle Net allows for support of multiple protocols. TCP/IP and LU6.2 are two examples of the protocols that Oracle Net supports.
-------

7. What is a solution that Oracle9i employs with Oracle Net that allows connectivity of Java Components such as Enterprise JavaBeans?
A. LU6.2
B. IPA
C. GIOP
D. Oracle Internet Director

Ans. C.
The General Inter-ORB Protocol is a protocol that supports connectivity of Java components.
--------

8. What is the standard that the Oracle Net communications stack is based on?
A. OCI
B. NPI
C. OSI
D. API

Ans C.
The Oracle Net communications stack is based on the Open Systems Interconnection (OSI) model. NPI and OCI are parts of the Oracle Net stack and API stands for Applications Program Interface.
----------

9. "Responsible for moving bits across the wire" describes which of the following OSI layers?
A. Application Layer
B. Physical Layer
C. Data Link Layer
D. Network Layer

Ans B.
The Physical Layer is responsible for sending the actual data bits acrossthe network. The other layers are all above this base layer.
-------

10. What is the default name of the process that is used to make external calls via Oracle Net?
A. externalproc
B. external
C. extproc
D. procext
Ans. C. The default name of the external procedure process is extproc. lsnrctl is a utility used to manage the listener service. External and procext are not valid responses.
----------------

11. IIOP is an example of which of the following?
A. Tools to use for Oracle Net
B. Oracle network integration utilities
C. Internet network protocol
D. Portions of the Oracle Net stack

Ans C.
IIOP is an example of an Internet network protocol.
-------

12. Connection Manager provides which of the following?
A. Multiplexing
B. Cross protocol connectivity
C. Network access control
D. All of the above

Ans D.
Connection Manager is a middleware solution that provides for multiplexing of connections, cross protocol connectivity, and network access control. All of the answers describe Connection Manager.
-------

13. Which of the following is true about the OCI layer?
A. It displays the graphical interface
B. Its datatype conversions are handled.
C. It interfaces directly with the protocol adapters.
D. It interfaces directly with the TTC layer.
E. None of the above.

Ans D.
The OCI layer is below the application layer and above the TTC layer. The call interface handles such things as cursor management and SQL execution. This information is passed on to the Two-Task Common layer. --------

14. To which of the choices below does the following statement apply? "Prevents direct communication between a client and applications inside the corporate network."
A. Proxy-based
B. Filter-based firewalls
C. Both types of firewalls
D. Neither type of firewall

Ans A.
Proxy-based firewalls prevent any direct contact between a client and applications inside a corporate firewall. Filter-based firewalls inspect the packet headers but pass the packet on without modification to the destination application. Proxy-based firewalls act more as a relay between external clients and internal applications.
-------

15. When a connection is made via a Java applet, what type of driver is utilized?
A. JDBC OCI driver
B. JDBC Thin Driver
C. ODBC driver
D. OCI driver

Ans B.
The JDBC Thin Driver would be utilized if a Java applet is used to communicatewith an Oracle database through an application server.
-------

16. A client workstation connects to a transaction server, which passes on requests to the Oracle database. This is a description of which of the following?
A. Single-tier architecture
B. Client/server architecture
C. N-tier architecture
D. None of the above

Ans C.
When you introduce middle tiers into the processing of a transaction, this is known as n-tier architecture.
--------

17. Which Oracle Net networking product can be best described as middleware?
A. Oracle Internet Directory
B. Oracle Connection Manager
C. Oracle Advanced Networking
D. Oracle Shared Server

Ans B.
The Connection Manager is a middle-tier option that provides multi-protocol interchange, connection concentration, and client access control.
----------

18. Which of the following are characteristics of complex networks?
A. Multiple protocols
B. Diverse geographic locations
C. Multiple operating systems
D. Multiple hardware platforms
E. All of the above

Ans:
E. All of these are characteristics of complex networks.
-------
19. What is the preferred method of centralized naming in an Oracle9i environment?
A. Oracle Names Server
B. Oracle Connection Manager
C. Oracle Shared Server
D. Directory Naming with Oracle Internet Directory

Ans D.
Oracle Internet Directory and Directory Naming are displacing the Oracle Names Server as the preferred method of centralized naming.
---------------

20. Which of the following is an example of the ability to group connections together?
A. Protocol Interchange
B. Network Access Control
C. Multiplexing
D. Data Integrity checking
E. None of the above

Ans: C.
Multiplexing is a characteristic of the Oracle Connection Manager that allows several incoming requests to be handled and transmitted simultaneously over a single outgoing connection. This is a scalability feature provided by Connection Manager.