Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

   
Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

 

 

Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation

 

 


 

 

 

        
 

     Oracle OCP Network Questions

 

Question:

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 would be:

Answer:

A.  TCP/IP

Answer:

B.  Real Application Clusters

Answer:

C.  Oracle*Net with SQL*Net

Answer:

D.  IBM SNA

Correct Answer:

B.  Real Application Clusters

Explanation:

The correct answer is (D) Real Application Clusters. 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 would be OPS.  A is incorrect because TCP/IP is a protocol, and this would not help with scalability.  C is incorrect because Oracle*Net is only used 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.  B is correct because OPS provide for the ability for many processors to share a single Oracle database.  As the number of users increases, the number of processors can be increased.

 

Question:

2.  The most popular communication protocol for Oracle*Net on UNIX systems is:  

Answer:

A.  TCP/IP

Answer:

B.  SPX

Answer:

C.  SNA

Answer:

D.  DecNet

Correct Answer:

A.  TCP/IP

Explanation:

The correct answer is A TCP/IP. The most popular communication protocol for Oracle*Net on UNIX systems is: B C and D are incorrect because there are not widely-used communications protocols.  The UNIX operating system makes TCP/IP the most popular protocol.

 

Question:

3.  The popularity of the Internet has created which of the following scenarios?

Answer:

A.  Widely distributed Oracle database across a wide area network.

Answer:

B.  Distributed databases with WebServer gateways.

Answer:

C.  Networks of networked databases.

Correct Answer:

B. Distributed databases with WebServer gateways.

Explanation:

The correct answer is B Distributed databases with WebServer gateways. The popularity of the Internet has created which of the following scenarios?  A is incorrect because WAN Oracle systems are not on the Internet.  C is incorrect because networked database do not impact the Internet.  Oracle WebServer is the networking tools that allows an Internet user to access an Oracle database.

Question:

1.  Which is not a valid way to establish an initial connection to an Oracle database?

Answer:

A. With a TNS connect string (t:host:database).

Answer:

B. With a database link (select * from customer@ny;)

Answer:

C. With a server connect string (sqlplus /@fred)

Answer:

D. With a telnet session.

The correct answer is D, with a telnet session. 

Explanation:

The correct answer is D, with a telnet session.  Which is not a valid way to establish an initial connection to an Oracle database? A, B, and C are incorrect because they are all valid ways to establish a database connection.  A telnet session will only establish connections with a server, not the database.

 

Question:

2.  What Oracle meta table is used to view database link information?

Answer:

A.  Remote DBA_TABLES

Answer:

B. Remote DBA_DB_LINKS

Answer:

C. Remote DBA_SYNONYMS

Answer:

D. Remote DBA_2PC_PENDING

Correct Answer:

B.  Remote DBA_DB_LINKS

Explanation:

The correct answer is B. Remote DBA_DB_LINKS. What Oracle meta table is used to view database link information?  A is incorrect because Remote DBA_TABLES only views table information.  C is incorrect because Remote DBA_SYNONYMS is only used to view synonyms.  D is incorrect because Remote DBA_2PC_PENDING is only used to view two-phase commit transactions.

 

 

Question:

3.  What file(s) are used to supply the server IP address?  (choose all that apply)

Answer:

A. The /etc/hosts file

Answer:

B. The /etc/services file

Answer:

C. The tnsnames.ora file

Answer:

D. The sqlnet.ora file

Correct Answer:

The correct answers are A and C

Explanation:

The correct answers are A and C, the /etc/hosts file and the tnsnames.ora file. What file(s) are used to supply the server IP address?  B is incorrect because /etc/services supplies only port numbers.  D is incorrect because sqlnet.ora only supplies Oracle client information.

 

Question:

4.  Which of the following files supplies the protocol information for outgoing Oracle requests?

Answer:

A. listener.ora

Answer:

B.  sqlnet.ora

Answer:

C. /etc/hosts

Answer:

D. tnsnames.ora

Correct Answer:

D.  tnsnames.ora

 

Explanation:

The correct answer is D, tnsnames.ora. Which of the following files supplies the protocol information for outgoing Oracle requests?  A is incorrect because the listener.ora file is only for incoming requests.  B is incorrect because sqlnet.ora is only for Oracle*Net clients.  C is incorrect because /etc/hosts pairs the host name to the IP address.

Question:

1.  The purpose of the tnsnames.ora file is best described as:         

Answer:

A.  A process that listens for incoming database connections.                

Answer:

B.  A file that is used to supply host, protocol and database information for incoming requests.

Answer:

C.  A file that is used to hide the details about what is needed to connect to a remote database.

Answer:

C.  A file that is used to hide the details about what is needed to connect to a remote database.

Correct Answer:

The correct answer is C.  A file that is used to hide the details about what is needed to connect to a remote database. 

Explanation:

The correct answer is C.  A file that is used to hide the details about what is needed to connect to a remote database.  The purpose of the tnsnames.ora file is best described as: A is incorrect because the listener process, not the listener.ora file listeners for connections.  B is incorrect because the tnsnames.ora file is used for OUTGOING requests, not incoming requests.  D is incorrect because the tnsnames.ora file is not a process.  The tnsnames.ora file is a file that is used to hide the details about what is needed to connect to a remote database.  The tnsnames.ora is a file that “pairs” the service name with the host name, the protocol, and the database name.

Question:

2.  If we are exploring a new Oracle*Net computer and we do not know if it is configured to act as an Oracle server, what file would we look for?       

Answer:

A.  tnsnames.ora

Answer:

B.  sqlnet.ora

Answer:

C.  listener.ora

Answer:

D.  protocol.ora

Correct Answer:

C.  listener.ora

Explanation:

The corrrect answer is C.  listener.ora. If we are exploring a new Oracle*Net computer and we do not know if it is configured to act as an Oracle server, what file would we look for?  A, B, and C are incorrect because these files are only used by Net clients.  An Oracle Server must have a listener process defined in order to be considered a Oracle*Net server.

Question:

3.  What best describes a database link?

Answer:

A.  A software component that assists in establishing connectivity with remote servers.  

Answer:

B.  An internal Oracle component that adds a USER ID and password to a TNS service name.

Answer:

C.  A component that makes the physical connections to the Oracle database, establishing a server process.

Answer:

D.  A tool to define the Oracle*Net environmental files.

Correct Answer:

B.  An internal Oracle component that adds a USER ID and password to a TNS service name.

Explanation:

The correct answer is B.  An internal Oracle component that adds a USER ID and password to a TNS service name. What best describes a database link?  A is incorrect because a database link is not software, it is an entry in the Oracle dictionary.  C is incorrect because database links to not make database connections, and this is done by the listener process.  D is incorrect because database links do not define environments.  Database links are internal database components that are stored in the Oracle dictionary.  They consist of the link name, the TNS name, the user ID and the password.

Question:

4.  The main shortcoming of SQL*Net version 1 is that:           

Answer:

A.  It did not have the ability to establish communications between multiple protocols.

Answer:

B.  It did not possess a listener process.

Answer:

C.  It did not have the ability to use connect strings

Correct Answer:

A.  It did not have the ability to establish communications between multiple protocols.

Explanation:

The correct answer is A.  It did not have the ability to establish communications between multiple protocols. The main shortcoming of SQL*Net version 1 is that:  B is incorrect because SQL*Net v 1 uses a listener called ORASRV.  C is incorrect because SQL*Net v 1 does use connect strings.  One of the features of SQL*Net version 2 is the ability to support multi-protocol “communities”.

Question:

5.  Which of the following components is NOT used by the Oracle listener?

Answer:

A.  listener.ora

Answer:

B.  tnsnames.ora

Answer:

C.  database link information

Answer:

D.  Dispatcher process

Correct Answer:

B.  tnsnames.ora

Explanation:

The correct answer is B tnsnames.ora. Which of the following components is NOT used by the Oracle listener?  A is incorrect because the listener.ora is used by the listener at start-up time.  C is incorrect because database link information is used by the listener to get the TNS service name.  D is incorrect because the dispatcher processes are used by the listener to channel incoming database requests.  The tnsnames.ora file is ONLY used by the remote client, and not the receiving server.

Question:

Which is not true about the tnsnames.ora file?

Answer:

The tnsnames.ora file provides the network-specific details about the remote database

Answer:

The tnsnames.ora file should use the host name, and not the actual remote server IP address

Answer:

The tnsnames.ora file contains everything that is need to connect to the remote database

Answer:

The tnsnames.ora file should contain port number of the remote server

Correct Answer:

C

Explanation:

The tnsnames.ora file does not contain the USER ID or password.  That must be supplied manually, or through a database link

 

Question:

Which of the following components controls the connection to the remote database?

Answer:

The tnsnames.ora file

Answer:

The database link

Answer:

The TNS listener

Answer:

The protocol.ora file

Correct Answer:

C

Explanation:

The listener establishes the connection to the remote database and create the initial hookup.

 

Question:

What is not contained in a database link?

Answer:

The remote USER ID

Answer:

The host name of the remote server

Answer:

The TNS service name

Answer:

The remote password

Correct Answer:

B

Explanation:

The host name of the remote server is in the tnsnames.ora file, not in the database link.

 

Question:

With is not true about a Oracle*Net connection?

Answer:

The Oracle*Net client establishes the server process for the request

Answer:

The service name is used to perform the look-up in the tnsnames.ora file

Answer:

Database links and Oracle*Net are both required for remote SQL connections

Answer:

The protocol.ora file contains cross-protocol information

Correct Answer:

A

Explanation:

The remote listener, not the client, establishes the request.

 

Question:

Which is not a part of a Oracle*Net client install?

Answer:

Starting the TNS listener process

Answer:

Installing the Oracle*Net client software

Answer:

Configuring the tnsnames.ora file

Correct Answer:

A

Explanation:

The listener process exists only on the server, not on the client.

 

Question:

Which of the following characteristics of Oracle*Net is false?

Answer:

Resource consumption in Oracle*Net is greatest for the requesting client processor

Answer:

The protocol.ora file allows for inter-protocol communications

Answer:

The listener process exists only on Oracle servers

Answer:

For a distributed query, database links must exist only on the client database

Correct Answer:

A

Explanation:

Almost 100% of the processing work is done on the remote server, not on the requesting client.

Question:

The remote database name is kept in which Oracle parameter file?

Answer:

Sqlnet.ora

Answer:

Tnsnames.ora

Answer:

Protocol.ora

Answer:

None:  It is kept in the database link

Correct Answer:

Tnsnames.ora

Explanation:

The tnsnames.ora file contains the port number, the database name, the protocol, and the host name.

Question:

Which of the following is not always contained in the tnsnames.ora file?

Answer:

Port number

Answer:

Host name

Answer:

IP address

Answer:

protocol

Correct Answer:

IP address

Explanation:

The IP address might be present in the tnsnames.ora file, but most Remote DBA’s use the host name instead, to you do not have frequent changes to the tnsnames.ora file.

Question:

How do you hide the fact that a table is being used at a remote database?

Answer:

Create a database synonym

Answer:

Create an alias in the tnsnames.ora file

Answer:

Provide a dedicated listener process on the remote server

Answer:

Make the service name the same as the database name in the tnsnames.ora file

Correct Answer:

A

Explanation:

Location transparency is achieved by creating a synonym for the remote table name:

Create public synonym customer for customer@raleigh;

Question:

Which is not true about dedicated listener processes?

Answer:

The listener process can be seen with a UNIX command

Answer:

The Oracle*Net connections can be seen by querying the v$ views at the remote database

Answer:

The listener is required for all Oracle*Net clients

Answer:

The listener is started on each remote database server.

Correct Answer:

C

Explanation:

Only Oracle servers require a listener process

Question:

Which of the following are true about the tnsnames.ora file?

Answer:

The tnsnames.ora file is not required for Oracle servers

Answer:

Most PC clients create individual tnsnames.ora files

Answer:

The Remote DBA usually maintains a “master” tnsnames.ora file

Answer:

The tnsnames.ora file contains the database name for the remote database     

Correct Answer:

A & C      

Explanation:

Only Oracle clients require a tnsnames.ora file, and the Remote DBA normally maintains a master tnsnames.ora file for use throughout the corporation.

?

Question:

Which is not true about Dead client detection?

Answer:

The dead client detection is specified in the sqlnet.ora file.

Answer:

Dead client detection polls the server a pre-determined intervals.

Answer:

Dead connection poll times are specified with the expire_time parameter

Answer:

Dead connections are terminated on the client and the server

Correct Answer:

D

Explanation:

Since the connection is dead, the Oracle server process that was initiated by the client may continue to run.

Question:

Which of the following is NOT a valid type of listener?

Answer:

A listener that is polling on 3 addresses for 3 different protocols

Answer:

A listener that passes requests to a multi-threaded dispatcher.

Answer:

A listener that makes a direct connection to the Oracle database.

Answer:

A listener that allows SNMP connections from a mainframe         

Correct Answer:

C

Explanation:

Listeners do not make direct connections to the database.  They bequeath the connections.

 

Question:

Which command is used to start a SQL*Net version 1 listener?

Answer:

tcpctl start     

Answer:

tcpctl start listener

Answer:

lsnrctl start

Answer:

Lsnrctl start listener

Correct Answer:

A

Explanation:

This is the correct command for SQL*Net version 1

 

Question:

What is the main disadvantage to using Oracle*Net assistant?

Answer:

It is not practical for large Oracle networks because manually created parameter files cannot always be processed.

Answer:

It is easily to manually edit the parameter files.

Answer:

The Oracle*Net assistant does not have the flexibility of manual editing.

Answer:

The Oracle*Net assistant wizards are not very intuitive

Correct Answer:

A

Explanation:

Some manually created tnsnames.ora and listener.ora files cannot be read by Oracle*Net assistant.

 

Question:

If you have very high connection volumes, what is the best approach for configuring the listener?

Answer:

Create multiple listeners on the server

Answer:

Create a multi-protocol listener

Answer:

Create the listener with additional service handlers

Answer:

Create a multi-threaded server for each database.

Correct Answer:

D

Explanation:

The MTS is the best way to handle high volumes of data

 

Question:

What command is used to see the available listener control commands?

Answer:

tcpctl help

Answer:

lsnrctl syntax

Answer:

lsnrctl help

Answer:

lsnrctl ?

Correct Answer:

C

Explanation:

The lsnrctl help command will show the available listener commands

 

Question:

Which is NOT true about a Oracle*Net listener?

Answer:

The listener contains an entry for each database on the host.

Answer:

The listener process will start automatically when the database is started

Answer:

The listener runs as an independent process on the server

Answer:

The listener can be “bounced” without effecting existing connections

Correct Answer:

B

Explanation:

The listener must be started as a separate process with the “lsnrctl start” command.

 

Question:

Which is NOT true about Oracle*Net multi-protocol support?

Answer:

Multi-protocol support requires defining a multi-threaded server for each database.

Answer:

Oracle*Net protocols are defined in the listener.ora file

Answer:

The Oracle*Net connection manager can be used in lieu of multi-protocols in the listener.ora file.

Answer:

The Oracle*Net listener can support protocols from PC’s, mainframes, and virtually every type of remote protocol.

Correct Answer:

A

Explanation:

The MTS is not required for multi-protocol support.

Question:

In what directory would you find the Oracle*Net executable files?

Answer:

C:\orawin\execlib

Answer:

C:\win32\bin

Answer:

C:\orant\Oracle*Net0\network\admin

Answer:

C:\orant\bin

Correct Answer:

D

Explanation:

The Oracle*Net executables are located in the “bin” directory

 

Question:

The PC that you have been given is running Windows NT with Net7 and does not have Oracle*Net assistant installed.  You need to add a new remote database description.  What file would you edit to do this?

Answer:

c:\orant\Oracle*Net0\admin\tnsnames.ora

Answer:

c:\orant\Oracle*Net0\network\admin\tnsnames.ora

Answer:

c:\orant\network\admin\tnsnames.ora

Answer:

c:\orant\Oracle*Net0\admin\sqlnet.ora

Correct Answer:

D

Explanation:

This is the location of the tnsnames.ora

 

Question:

What type of Oracle shop is most likely to use the Oracle*Net assistant?

Answer:

A large Oracle shops with thousands of PC’s.

Answer:

A small Oracle shop with a small number of client PC’s.

Answer:

A small Oracle shop with highly-technical end-users.

Answer:

A large Oracle shop with dozens of remote databases.

Correct Answer:

C

Explanation:

Oracle*Net assistant is not an end-user tool, and requires some knowledge of TNS.  It is also unsuited to large Oracle shops.

Question:

If you fail in an attempt to ping a remote server by host name, what is the best course of action?

Answer:

Get a systems administrator to check the services file on your PC.

Answer:

Try to ping the server using the IP address of the remote computer

Answer:

Try connecting with SQL*Plus

Answer:

See if the listener is running on the remote server

Correct Answer:

B

Explanation:

If you cannot ping by host name, see if you can ping with the IP address.  If that fails, you have a domain name server problem, if not you have a problem with your services file.

Question:

Which of the following statements is true?

Answer:

It is possible to connect to an Oracle8 database with Oracle7 client software.

Answer:

It is always a good idea to use a shared tnsnames.ora file on a networked disk.

Answer:

The best way to test a TNS problem is with the ping utility.

Answer:

You should always install the Oracle*Net assistant on a PC Oracle client.

Correct Answer:

A

Explanation:

The Oracle client software is totally independent and backward-compatible.

Question:

What is the best method for propagating a tnsnames.ora file to PCs?

Answer:

Use a third-party software package to distribute the file

Answer:

Send all users an e-mail with the file whenever it changes

Answer:

Share the tnsnames.ora file on a PC network disk

Answer:

All of the above are acceptable

Correct Answer:

D

Explanation:

There are many approaches to managing the tnsnames.ora file

Question:

Which of the following files will never appear in the /network/admin directory of a PC client?

Answer:

Listener.ora

Answer:

Topology.ora

Answer:

Sqlnet.ora

Answer:

Tnsnames.ora

Correct Answer:

A

Explanation:

A PC client will never have a listener.ora file unless it is an NT server with an Oracle database.

Question:

What is not true about SQL*Net Easy?

Answer:

It will perform a test of the connectivity at the end of the session.

Answer:

It will interrogate the server to get the proper port number

Answer:

It will allow you to provide a service name that is different from the database name

Answer:

It will allow you to scroll back if you make a mistake

Correct Answer:

B

Explanation:

You need to know the port number when you add the database name.

Question:

What is the best choice for installing Oracle*Net clients on thousands of PCs?

Answer:

The Oracle Remote DBA should perform all Oracle installs.

Answer:

A non-Oracle technician can be trained to install the clients

Answer:

Oracle client software should only be installed by a system administrator

Answer:

The LAN administrator should install all Oracle client software

Correct Answer:

B

Explanation:

It is not necessary for the Oracle Remote DBA to perform all Oracle client install, and non-Oracle technicians can be trained to perform this repetitive task.

Question:

1.  Which of the following sites would most likely to use Oracle Names?

Answer:

A small shop with frequent database domain changes

Answer:

A large shop with frequent database domain changes

Answer:

A small shop with infrequent database domain changes

Answer:

A large shop with infrequent database domain changes

Correct Answer:

A

Explanation:

Oracle Names is best for small shops that have frequent new or changed database domains.

 

Question:

2. How does Oracle address the “single point of failure” issue with Oracle Names?

Answer:

By allowing the manual propagation of the tnsnames.ora file

Answer:

By supporting the automatic propagation of the tnsnames.ora file

Answer:

By allowing for multiple Names Servers

Answer:

By maintaining constant polling connections

Correct Answer:

C

Explanation:

Multiple Names Servers relieves the single point of failure problem.

 

Question:

3.   What is the purpose of the names.ora file?

Answer:

To define the Names Server to all Oracle*Net clients

Answer:

To configure the Names database on the Oracle server

Answer:

To define all TNS connections to remote servers

Answer:

To define the database links to remote databases

Correct Answer:

B

Explanation:

The names.ora file determines the configuration of the Names database on the Names Server.

 

Question:

4.  Where does Oracle Names store database link information?

Answer:

In the names.ora file

Answer:

In the sqlnet.ora file

Answer:

The links are read dynamically from each remote database

Answer:

In the Names database

Correct Answer:

D

Explanation:

The Names database stores all TNS information, including IP addresses, ports, host names, protocols, database links, user ID’s and passwords.

 

Question:

5.  Which files are required on an Oracle Names client PC? (Choose all that apply)

Answer:

The tnsnames.ora file

Answer:

The sqlnet.ora file

Answer:

The listener.ora file

Answer:

The names.ora file

Correct Answer:

B

Explanation:

Only the sqlnet.ora file is required on a Names client PC.

Question:

1.  The command syntax of the namesctl utility has the most in common with which utility?

Answer:

The Oracle*Net assistant utility

Answer:

The SQL*Net Easy utility

Answer:

The lsnrctl utility

Answer:

The tcpctl utility

Correct Answer:

C

Explanation:

The command syntax between lsnrctl and namesctl is very similar.

Question:

2.  Which is not an issue when deciding whether to implement Oracle Names?

Answer:

The volatility of the database environment

Answer:

The number of database on each server

Answer:

The reliability requirements of the network

Answer:

The number of PC clients at the site

Correct Answer:

B

Explanation:

The number of database on each server is not a factor in deciding whether to use Oracle Names.

Question:

3.  Which statement is false about Oracle Names?

Answer:

Oracle Names is required for Oracle*Net implementation

Answer:

Oracle Names assists in the maintenance of the tnsnames.ora files

Answer:

Oracle Names will store database link information in a central location

Answer:

Oracle Names can be used to simplify Oracle*Net maintenance

Correct Answer:

A

Explanation:

Oracle Names is an optional product.

Question:

4.  Which of the following is not a step in the resolution of an Oracle Names request?

Answer:

Passing the service name to the Oracle Names Server

Answer:

Gathering the database link USER ID and password

Answer:

Getting the host address from the Names Server

Answer:

Resolving the protocol in the tnsnames.ora file

Correct Answer:

D

Explanation:

A tnsnames.ora file is not used with Oracle names.

Question:

1. Which OEM console window would be used to cancel a server process?

Answer:

 

A. Navigator window

Answer:

B. Job scheduling window

Answer:

C. Map window

Answer:

D. Event manager window

Correct Answer:

B. Job scheduling

Explanation:

The correct answer is B, job scheduling.  This is because the job scheduler allows interfaces with the remote operating system, including killing a task. Which OEM console window would be used to cancel a server process? A, and C, are clearly incorrect because they do not allow for O/S kill commands to be directly issued. D might have been a choice because the event manager could issue a kill command via SNMP, but B is a better answer because the job scheduled is designed for this function.

 

Question:

2. What OEM console window is used to display all of the tables for an Oracle user?

Answer:

 

A. Navigator window

Answer:

B. Job scheduler window

Answer:

C. Map window

Answer:

D. Event manager window

Correct Answer:

A. Navigator window    

Explanation:

The correct answer is A, navigator window because this window displays all of the databases, users, within each database, tables for each user, and attributes for all table. 

What OEM console window is used to display all of the tables for an Oracle user? B, C, and D are incorrect because they do not display Oracle table information.

 

Question:

3. The OEM console navigator is very similar to what other Oracle GUI tool?

Answer:

A. Oracle*Net Easy

Answer:

B. Schema Manager

Answer:

C. Tablespace manager

Answer:

D. Data manager

Correct Answer:

B. Schema manager

Explanation:

The correct answer is B, schema manager, because both schema manager and the navigator allow for the hierarchical display of databases, users table, and table attributes. The OEM console navigator is very similar to what other Oracle GUI tool?  A is incorrect because Oracle*Net Easy is used to add service names to the tnsnames.ora file.  C is incorrect because tablespace manager is used to display sequential blocks within a list if tablespaces.  D is incorrect because data manager is used to add files to a tablespace.

 

Question:

4.  Which window of the OEM console would be used to display the size of a remote database SGA?

Answer:

A. Navigator window

Answer:

B. Job scheduler window

Answer:

C. Map window

Answer:

D. Event manager window

Correct Answer:

C. Map window

Explanation:

The correct answer is C, map window because double clicking on a database icon in the map window will display all of the relevant SGA sizes.  Which window of the OEM console would be used to display the size of a remote database SGA? A, B, and D are incorrect because they do not display SGA information.

Question:

What is the downside to defining too many dispatchers?

Answer:

Incoming connections will have to wait for the listener.

Answer:

There will be unnecessary extra server processes.

Answer:

There will be excessive connect times for dedicated connections

Correct Answer:

B

Explanation:

The correct answer is B, there will be unnecessary extra server processes.  This is because extra UNIX PID’s will be allocated for each dispatcher.  A and C are incorrect because extra dispatchers will not effect connection times.

 

Question:

What is false about the mts_dispatcher init.ora parameter?

Answer:

You can define multiple protocols for each dispatcher.

Answer:

You can define many dispatcher processes with this parameter.

Answer:

You can define the target protocol for the dispatcher with this parameter.

Correct Answer:

A

Explanation:

The correct answer is A, You can define multiple protocols for each dispatcher. This is necause a dispatcher may only support a single protocol.  What is false about the mts_dispatcher init.ora parameter? B and C are incorrect because they are proper uses for the mts_dispatcher parameter.

 

Question:

What is false about the MTS?

Answer:

All SQL*Net version 1 connections will continue to use a dedicated connection.

Answer:

The MTS will place an additional burden on the Oracle shared pool.

Answer:

The MTS requires that you define at least one dispatcher.

Answer:

You cannot use a dedicated connection if the MTS is defined.

Correct Answer:

D

Explanation:

The correct answer is D, You cannot use a dedicated connection if the MTS is defined.  This is because you can explicitly request a dedicated connection in your Oracle*Net connect string. What is false about the MTS?  A, B. and C are incorrect because they are valid MTS statements.

 

Question:

Which of the following operations is not permitted through an MTS connection?

Answer:

Creating an Oracle table.

Answer:

Stopping an Oracle database.

Answer:

Querying the v$dispatcher view.

Answer:

Changing the init.ora file

Correct Answer:

B

Explanation:

The correct answer is B, Stopping an Oracle database.  This is because you cannot connect to Server Manager via an MTS connection. Which of the following operations is not permitted through an MTS connection?  A is incorrect because you can do any DDL through the MTS.  C is incorrect because the dictionary does not care how the connection is established.  D is incorrect because Oracle connectivity is not required to change the init.ora file.

Question:

Which parameter is used to define connection pooling?

Answer:

mts_servers

Answer:

mts_dispatchers

Answer:

mts_listener_address

Answer:

mts_pool

Correct Answer:

B

Explanation:

The correct answer is B, mts_dispatchers. Which parameter is used to define connection pooling? A, C, and D are incorrect because they are not used to configure connection pooling.

Question:

What is the procedure used to compute the “busy rate” for an MTS?

Answer:

Query the v$queue view.

Answer:

Query the v$dispatcher view.

Answer:

Run the equation for busy rate.

Answer:

Count the high-water mark for connected processes.

Correct Answer:

B

Explanation:

The correct answer is B, Query the v$queue view. What is the procedure used to compute the “busy rate” for an MTS?

Question:

How can you get the “average wait time per transaction” from the MTS?

Answer:

The v$queue view

Answer:

The v$dispatcher view

Answer:

The v$sga view

Answer:

The listener.log

Correct Answer:

A

Explanation:

The correct answer is A, the v$queue view. How can you get the “average wait time per transaction” from the MTS?  B, C, and D are incorrect because they do not contain wait time information.

Question:

Which is not a task in listener load balancing?

Answer:

Adjusting shared servers for each MTS.

Answer:

Adjusting the shared_pool_size

Answer:

Adjusting the number of listener processes on the server.

Answer:

Adjusting the number of dispatchers for each MTS.

Correct Answer:

B

Explanation:

The correct answer is B, adjusting the shared_pool_size. Which is not a task in listener load balancing?  A, C and D are incorrect because they are all relevant tasks when adjusting the listeners.

Question:

What is false about shared server process configuration?

Answer:

Shared server processes will be automatically allocated when needed.

Answer:

You should set mts_shared_servers to a high initial value.

Answer:

Shared server processes will be de-allocated when they are not needed.

Answer:

Shared server processes communicate with the dispatcher processes.

Correct Answer:

B

Explanation:

The correct answer is B, You should set mts_shared_servers to a high initial value.  This is because Oracle automatically allocates shared servers as needed, and a high initial allocation will waste resources. What is false about shared server process configuration?  A, C, and D are incorrect because they are valid statements about the shared server.

Question:

Which is not a valid parameter for the cman.ora rules section?

Answer:

ACT

Answer:

DST

Answer:

SRV

Answer:

ORA

Correct Answer:

D

Explanation:

The correct answer is D, ORA because ORA is not a valid cman_rules directive. Which is not a valid parameter for the cman.ora rules section?  A, B, and C are valid because they are valid directives for the cman_rules section of the cman.ora file.

 

Question:

What does the SRV rules parameter of the cman.ora file specify?

Answer:

The TNS service name

Answer:

The remote server name

Answer:

The location of the tnsnames.ora file

Answer:

The location of the cman.ora file.

Correct Answer:

B

Explanation:

The correct answer is B, the remote server name.  This is because the SRV sub-parameter of the cman_rules section is used to specify the name of a remote server. What does the SRV rules parameter of the cman.ora file specify?  A, C, and D are incorrect because they are not effected by the SRV paramater.

 

Question:

What is not a valid section of the cman.ora file?

Answer:

cman_rules

Answer:

cman

Answer:

cman_connection

Answer:

cman_profile

Correct Answer:

D

Explanation:

The correct answer is D, cman_profile because it is not a valid cman.ora section name. What is not a valid section of the cman.ora file?  A, B, and C are incorrect because they are valid cman.ora sections.

 

Question:

If you wish to reject a connection from a specified host, what cman.ora sub-parameter would be used?

Answer:

ORA

Answer:

ACT

Answer:

DST

Answer:

 

SRV

Correct Answer:

B

Explanation:

The correct answer is B, ACT.  This is because the ACT sub-parameter of the cman_rules section of the cman.ora file is used to reject connections. If you wish to reject a connection from a specified host, what cman.ora sub-parameter would be used?  A, C, and D are incorrect because they do not control host rejection.

Question:

Which of the following statements is false regarding CMAN?

Answer:

The CMAN utility does not support multiple protocols.

Answer:

The CMAN utility can be used together with a traditional Oracle*Net listener.

Answer:

The CMAN utility can selectively accept remote connections from specific servers.

Answer:

The CMAN utility can be used to concentrate connections into a multi-threaded server.

Correct Answer:

A

Explanation:

The correct answer is A, The CMAN utility does not support multiple protocols.  This is because the CMAN utility does indeed support many protocols. Which of the following statements is false regarding CMAN?  B, C, and D are incorrect because they are true statements about CMAN.

?

Question:

Which is not a benefit of the Connection Manager?

Answer:

Multiprotocol support

Answer:

Data encryption

Answer:

Connection concentration

Answer:

Network access control

Correct Answer:

B

Explanation:

The correct answer is B, data encryption because encryption is not a CMAN function. Which is not a benefit of the Connection Manager?   A, C, and D are correct because they are valid CMAN features.

Question:

The connection concentration feature has the most in common with what other Oracle product feature?

Answer:

The MTS connection pooling feature.

Answer:

The MTS multiple dispatcher feature.

Answer:

The SQL*Net multi-protocol feature.

Answer:

The Oracle*Net tnsnames.ora POOL option.

Correct Answer:

A

Explanation:

The correct answer is A, The MTS connection pooling feature.  This is because the MTS connection pooling routes requests to a shared server just like the CMAN utility. The connection concentration feature has the most in common with what other Oracle product feature?  B, C, and D are incorrect because they have nothing to do with connection pooling. 

Question:

What best describes the purpose of the CMAN administrator process?

Answer:

It is a process that is responsible for maintaining address information in the Oracle Names Server for the Oracle*Net clients.

Answer:

It is a process that manages the connections to the multi-threaded servers on each database.

Answer:

It is a process that implements connection concentration for each database instance.

Answer:

It is a process that listens for incoming connections.

Correct Answer:

A

Explanation:

The correct answer is A, it is a process that is responsible for maintaining address information in the Oracle Names Server for the Oracle*Net clients. What best describes the purpose of the CMAN administrator process?  B, C, and D are incorrect because they are not valid functions of the CMAN administrator.

Question:

What is the first thing that should be done when a end-user cannot connect to a server?

Answer:

Check the local tnsnames.ora file

Answer:

Look-up the error number provided to the end-user

Answer:

Try to ping the server.

Answer:

Check the listener

Correct Answer:

B

Explanation:

The correct answer is B, look-up the error number provided to the end-user. What is the first thing that should be done when a end-user cannot connect to a server?  A, C, and D are incorrect because they are secondary steps in problem resolution.

Question:

What statement is most correct about trace files?

Answer:

Trace files are automatically generated and are very useful for diagnosing common connection problems.

Answer:

Trace files are relatively small and can be kept as a record of Oracle*Net connections.

Answer:

Trace files are very useful ONLY if Oracle auditing is also used.

Answer:

Trace files are large and space consuming and should only be used in rare cases.

Correct Answer:

D

Explanation:

The correct answer is D, trace files are large and space consuming and should only be used in rare cases. What statement is most correct about trace files?  A, B, and C are incorrect because they do not correctly describe trace files.

Question:

You receive a report from dozens of end-users, all complaining that they cannot connect to the server.  What log file should you check first?

Answer:

sqlnet.log

Answer:

listener.log

Answer:

tnsnames.log

Answer:

alert.log

Correct Answer:

B

Explanation:

The correct answer is B, listener.log. You receive a report from dozens of end-users, all complaining that they cannot connect to the server.  What log file should you check first?  A, C. and D are incorrect because they do not address the listener, which is generally the sole cause of large-scale problems.

Question:

What trace component can be started without making the end-users exit and re-connect to the server?

Answer:

listener trace

Answer:

server trace

Answer:

sqlnet trace

Answer:

names trace

Correct Answer:

A

Explanation:

The correct answer is A, listener trace with “lsnrctl trace”. What trace component can be started without making the end-users exit and re-connect to the server?  B. C, and D are incorrect because they involve re-connecting to the database.

Question:

Which is not a valid trace level for Oracle?

Answer:

USER

 

Answer:

ADMIN

Answer:

OFF

Answer:

TRACE

Correct Answer:

D

Explanation:

The correct answer is D, TRACE. Which is not a valid trace level for Oracle?  A, B, and C are incorrect because they are valid level parameters for Oracle tracing.

Question:

 

Which level of tracing will provide the highest level of detail about a connection?

Answer:

USER

Answer:

ADMIN

Answer:

OFF

Answer:

TRACE

Correct Answer:

D

Explanation:

The correct answer is B, ADMIN. Which level of tracing will provide the highest level of detail about a connection?  A, C, and D are incorrect because they are lower-detail

Question:

You have forgotten the location of your listener log files.  What is the best way to determine their location?

Answer:

Server manager – show parameters dump

Answer:

Run tnsping

Answer:

Run lsnrctl stat

Answer:

Check tnsnames.ora

Correct Answer:

C

Explanation:

The correct answer is C, lsnrctl stat. You have forgotten the location of your listener log files.  What is the best way to determine their location?  A, B, and D are incorrect because they are not the best way to see the location of your listener.log file.

 

 

Remote DBA Service
 

Oracle Tuning Book

 

Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

 

 

 

 

 

 

 

 

 

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.