Network Topology   «Prev  Next»

Oracle SQL Net Architecture - Quiz

 
1. The remote database name is kept within which Oracle parameter file?
Please select the best answer.
  A. sqlnet.ora
  B. tnsnames.ora
  C. protocol.ora
  D. The database link

2. Which of the following is not always contained in the tnsnames.ora file?
Please select the best answer.
  A. Port number
  B. Host name
  C. IP address
  D. Protocol

3. How do you hide the fact that a table is being used by a remote database?
Please select the best answer.
  A. Create a database synonym.
  B. Create an alias in the tnsnames.ora file.
  C. Provide a dedicated listener process on the remote server.
  D. Make the service name the same as the database name in the tnsnames.ora file.

4. Which of the following statements is not true about dedicated listener processes?
Please select the best answer.
  A. The listener process can be seen with a UNIX command.
  B. The Net connections can be seen by querying the v$ views at the remote database.
  C. The listener is required for all Net clients.
  D. The listener is started on each remote database server.

5. Which of the following statements regarding the tnsnames.ora file are true?
Please select all the correct answers.
  A. The tnsnames.ora file is not required for Oracle servers.
  B. Most Windows clients create individual tnsnames.ora files.
  C. The DBA usually maintains a master tnsnames.ora file.
  D. The tnsnames.ora file always contains the host IP address for the remote server.

6. Which of the following statements regarding dead client detection is not true?
Please select the best answer.
  A. The dead client detection is specified in the sqlnet.ora file.
  B. Dead client detection polls the server at predetermined intervals.
  C. Dead connection poll times are specified within the expire_time parameter.
  D. Dead connections are terminated on the client and the server.