当前位置:1Z0-042题库

问题:

[单选]

You manually create an additional listener process,L1,for databases PROD, 
PAYDB and FINDB. While starting up the listener process,you get the following error message: 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:
(ADDRESS=(PROTOCOL=TCP)(HOST=144.23.230.185)(port=8899)) 
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 database communications?()

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 proce

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced?() Scott can create a synonym for the EMP_DEPT_LOC_VU bus using the command: CREATE PRIVATE SYNONYM EDL_VU FOR mary.EMP DEPT_LOC_VU; then he can prefix the columns with this synonymn.。 Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.。 Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE LOCAL SYNONYM EDL_VU FOR mary.EMP DEPT_LOC_VU; then he can prefix the columns with this synonym.。 Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU ON mary(EMP_DEPT_LOC_VU); then he can prefix the columns with this synonym.。 Scott cannot create a synonym because synonyms can be created only for tables.。 Scott cannot create any synonym for Mary's view. Mary should create a private synonym for the view and grant SELECT privilege on that synonym to Scott.。 常见的调压措施有哪些? Which two tasks can be performed when WLST is in OFFLINE mode?() modifying the configuration of an online domain。 modifying the configuration of an offline domain。 viewing runtime performance data in ONLINE mode。 viewing runtime performance data in OFFLINE mode。 creating and extending domai。 You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays, to tape.  Which two statements are true about differential incremental backups() The backup performed on Sundays contains all the blocks that have ever been used in the database.。 The backup performed on Sundays contains all the blocks that have changed since the last level 1backup. 。 The backup performed on each working day contains all the blocks that have changed since the lastlevel 0 backup.。 The backup performed on Monday contains all the blocks that have changed since the level 0 backup,and every other working day contains all the blocks that have changed since the level 1 backup.。 中篱类树种有

You manually create an additional listener process,L1,for databases PROD, 
PAYDB and FINDB. While starting up the listener process,you get the following error message: 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:
(ADDRESS=(PROTOCOL=TCP)(HOST=144.23.230.185)(port=8899)) 
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 database communications?()

参考答案:

  参考解析

本题暂无解析

在线 客服