网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You have two listener processes， named L1 and L2. Both the listener processes are currently functional. While viewing the listener.ora file on your database server， you find the following entry： PASSWORDS_L1 = （1sanfrjp43） What would be the impact of this setting？（）
A
The listener process named L1 will disconnect the unauthorized users.
B
The listener process named L1 will be prevented from being started by unauthorized users.
C
The listener process named L1 will be prevented from being stopped by unauthorized users.
D
The listener process named L1 will be prevented from being reloaded by unauthorized users.
E
The listener process named L1 will be prevented from accepting connections from unauthorized users.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You have two listener processes， named L1 and L2. Both the listener processes are currently functional. While viewing the listener.ora file on your database server， you find the following entry： PASSWORDS_L1 = （1sanfrjp43） What would be the impact of this setting？（）A The listener process named L1 will disconnect the unauthorized users.B The listener process named L1 will be prevented from being started by unauthorized users. C The listener process named L1 will be prevented from being stopped by unauthorized users. D The listener process named L1 will be prevented from being reloaded by unauthorized users.E The listener process named L1 will be prevented from accepting connections from unauthorized users.” 相关考题
考题
You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance： SQL ALTER SYSTEM SWITCH LOGFILE； Which two tasks are performed when the statement is executed？ （）A、 The DBWn process writes to the datafile.B、 Changes in the background process are recorded.C、 The log file is updated with the current SCN number.D、 The System Change Number （SCN） is recorded in the control file.E、 The changes to the listener configuration in the listener.ora file are recorded.
考题
You have just run this syntax to start the listener from the Listener Control utility： LSNRCTLSTART Starting /mstgelai/oracle/bin/tnslsnr： please wait… System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/log/listener.log Listening on： （DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=stc-sun01-server）（PORT=1521））） Connecting to… The command completed successfully What is the name of the Listener you started？（）A、TNSLSNRB、LISTENERC、LOCAL_LISTENERD、DEFAULT_LSRN
考题
You executed the following command in the lsnrctl utility to stop the listener： lsnrctl STOP L1 What is the effect of this command if L1 is the only listener configured for your database？（）A、It terminates all user sessions.B、It prevents users from logging in to the database remotely.C、It halts the server until all user transactions are completed.D、The server hangs， so users will receive an error asking them to login again.E、Connected users would get an error with the message "End of communication channel".
考题
You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error： ERROR： ORA-12541：TNS：no_listener You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener. lsnrctlSTART What statement is true？（）A、It would attempt to start the default listenerB、It would start the most recently created listener.C、It would display an error with a message asking for the listener name to be specified.D、It would show you a list of listeners and prompts for the listener name that you want to start.
考题
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）A、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer
考题
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 processB、set the TNS_ADMIN environmental variableC、stop all running listener processes and restart the listener processD、change the port number to an unused port number and restart the listener processE、change the IP address to host machine name in the LISTENER.ORA file and restart the listener process
考题
Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control， which two options would you select to balance the connection load across all the listener processes？（）A、Use only the first address.B、Try one address，selected at random.C、Try each address，in order，until one succeeds.D、Try each address，randomly，until one succeeds.
考题
You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）A、 by using the STATUS command of the Listener control utilityB、 by using the STATUS L1 command of the Listener control utilityC、 by using the SHOW RULES command of the Listener control utilityD、 by using the SET PASSWORD command of the Listener control utilityE、 by searching for the PASSWORD_LISTENER entry in the listener.ora file
考题
You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）A、Information about each Oracle Net connection.B、Information about each entry in theLinstener.orafileC、Information about the changed done in the databaseD、Information about the different listeners in your systemE、Information about all thenondatabasefiles required to operate the database
考题
You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective？（）A、 Use the CHANGE_PASSWORD command of the Listener control utility.B、 Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.C、 Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.D、 Manually modify the listener.ora file to include the password for the listener and restart the listener.
考题
Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed information about the listener， database， and the configuration of the application. How would you avoid this scenario？（）A、lock the listenerB、hide the listenerC、create multiple listenersD、run listener on a remote clientE、set a password for the listenerF、store listener.ora in a non-default location
考题
You are maintaining the database of a company. The listener process， listener1， is configured for remote access. You have issued the following command： LSNRCTLSTATUS listener1 Which information will NOT be displayed when you issue the above command？（） A、 whether the password is set in the listener or a file or notB、 the number of client connections the service handler has refusedC、 the information will be displayed whether the instance can accept connections or notD、 the protocol addresses on which the listener is configured to listen
考题
You work as a database administrator for Supportcenter.cn. Your listener process， L1， is currently listening to three databases： CertK INDB04， SupportCenter DB05 and SupportCenter DB06. Using Database Configuration Assistant （DBCA） you create one more database， SupportCenter DB07， and enable dynamic registration. Which two commands of Listener Control Utility （lsnrct1） would you use to determine whether the dynamic registration occurred for the database， SupportCenter DB07， with the L1 listener process？（）A、SHOW L1B、SPAWN L1C、STATUS L1D、SERVICES L1E、STATUS LISTENERF、SERVICES LISTENERG、SHOWcurrent_listener
考题
You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process. Which command of Listener control utility （LSNRCTL） would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications？（）A、STARTB、RELOADC、RESTARTD、REFRESHE、START L1F、RELOAD L1G、RESTART L1H、REFRESH L1
考题
单选题You have just run this syntax to start the listener from the Listener Control utility： LSNRCTLSTART Starting /mstgelai/oracle/bin/tnslsnr： please wait… System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/log/listener.log Listening on： （DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=stc-sun01-server）（PORT=1521））） Connecting to… The command completed successfully What is the name of the Listener you started？（）A
TNSLSNRB
LISTENERC
LOCAL_LISTENERD
DEFAULT_LSRN
考题
单选题Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）A
Oracle Net ManagerB
Listener Control utilityC
Database Configuration AssistantD
Oracle Net Configuration Assistant
考题
单选题You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error： ERROR： ORA-12541：TNS：no_listener You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener. lsnrctlSTART What statement is true？（）A
It would attempt to start the default listenerB
It would start the most recently created listener.C
It would display an error with a message asking for the listener name to be specified.D
It would show you a list of listeners and prompts for the listener name that you want to start.
考题
单选题You are maintaining the database of a company. The listener process， listener1， is configured for remote access. You have issued the following command： LSNRCTLSTATUS listener1 Which information will NOT be displayed when you issue the above command？（）A
whether the password is set in the listener or a file or notB
the number of client connections the service handler has refusedC
the information will be displayed whether the instance can accept connections or notD
the protocol addresses on which the listener is configured to listen
考题
单选题You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process. Which command of Listener control utility （LSNRCTL） would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications？（）A
STARTB
RELOADC
RESTARTD
REFRESHE
START L1F
RELOAD L1G
RESTART L1H
REFRESH L1
考题
单选题Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed information about the listener， database， and the configuration of the application. How would you avoid this scenario？（）A
lock the listenerB
hide the listenerC
create multiple listenersD
run listener on a remote clientE
set a password for the listenerF
store listener.ora in a non-default location
考题
多选题Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）AarchivalBlog writerCdatabase writerDsystem monitorEprocess monitorFchange tracking writer
考题
单选题You were recently hired by an organization as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）A
by using the STATUS command of the Listener control utilityB
by using the STATUS L1 command of the Listener control utilityC
by using the SHOW RULES command of the Listener control utilityD
by using the SET PASSWORD command of the Listener control utilityE
by searching for the PASSWORD_LISTENER entry in the listener.ora file
考题
单选题You executed the following command in the lsnrctl utility to stop the listener： lsnrctl STOP L1 What is the effect of this command if L1 is the only listener configured for your database？（）A
It terminates all user sessions.B
It prevents users from logging in to the database remotely.C
It halts the server until all user transactions are completed.D
The server hangs， so users will receive an error asking them to login again.E
Connected users would get an error with the message End of communication channel.
考题
多选题You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance： SQL ALTER SYSTEM SWITCH LOGFILE； Which two tasks are performed when the statement is executed？ （）AThe DBWn process writes to the datafile.BChanges in the background process are recorded.CThe log file is updated with the current SCN number.DThe System Change Number （SCN） is recorded in the control file.EThe changes to the listener configuration in the listener.ora file are recorded.
考题
单选题You have two listener processes， named L1 and L2. Both the listener processes are currently functional. While viewing the listener.ora file on your database server， you find the following entry： PASSWORDS_L1 = （1sanfrjp43） What would be the impact of this setting？（）A
The listener process named L1 will disconnect the unauthorized users.B
The listener process named L1 will be prevented from being started by unauthorized users. C
The listener process named L1 will be prevented from being stopped by unauthorized users. D
The listener process named L1 will be prevented from being reloaded by unauthorized users.E
The listener process named L1 will be prevented from accepting connections from unauthorized users.
考题
单选题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 processB
set the TNS_ADMIN environmental variableC
stop all running listener processes and restart the listener processD
change the port number to an unused port number and restart the listener processE
change the IP address to host machine name in the LISTENER.ORA file and restart the listener process
考题
单选题You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective？（）A
Use the CHANGE_PASSWORD command of the Listener control utility.B
Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.C
Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.D
Manually modify the listener.ora file to include the password for the listener and restart the listener.
考题
单选题You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）A
Information about each Oracle Net connection.B
Information about each entry in theLinstener.orafileC
Information about the changed done in the databaseD
Information about the different listeners in your systemE
Information about all thenondatabasefiles required to operate the database
热门标签
最新试卷