This preview shows page 1. Sign up to view the full content.
Unformatted text preview: _.dbf
F. arch_%t_%s_%r.arc Actualtests.com - The Power of Knowing 1Z0-042 Answer: F
You manually create an additional listener process, L1, for databases PROD,
PAYDB and FINDB. While starting up the listener process, you get the following
LSNRCTL> start l1
Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.1.0.2.0 - Production
System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log
Error listening on:
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
Listener failed to start. See the error message(s) above...
What action would you take to overcome this error without disrupting any existing
A. stop and restart the listener process
B. set the TNS_ADMIN environmental variable
C. stop all running listener processes and restart the listener process
D. change the port number to an unused port number and restart the listener process
E. change the IP address to host machine name in the LISTENER.ORA file and restart
the listener process
The customer and order tables are often used in joins, thereby resulting in complex
queries. You created views to simplify the writing of queries. These views are stored
A. user tables
B. view segment
C. table segment
D. data dictionary
E. object segment
F. performance tables
Actualtests.com - The Power of Knowing 1Z0-042 QUESTION 155:
Users in your PROD database complain about the slow response of the transactions.
While investigating the reason, you find that the transactions are waiting for the
undo segments to be available, and undo retention has been set to zero. What would
you do to overcome this problem?
A. increase the undo retention
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09