Enable instance failover
Configure shared server
Enable database failover
Enable connect-time failover
Enable Transparent Application Failover (TAF)
第1题:
You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this?()
第2题:
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?()
第3题:
You work as a database administrator for Certkiller .com. In your organization, you have four databases, Certkiller DB01, Certkiller DB02, Certkiller DB03, and Certkiller DB04, which are located in Berlin, Frankfurt,Rammstein, and Munich respectively, and which were created using Database Configuration Assistant (DBCA). You want to perform administrative tasks on these databases that include startup and shutdown, taking regular backups, and so on, fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task?()
第4题:
You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error: ERROR: ORA-12154:TNS:couldnot resolve service name Which network configuration files would you look into to resolve this error?()
第5题:
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?()
第6题:
You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error: ERROR: ORA-12154:TNS:couldnot resolve service name Which network configuration files would you look into to resolve this error?()
第7题:
ADDRESS_LIST
SID_NAME
LISTENER
SERVICE_LIST
第8题:
It would attempt to start the default listener
It would start the most recently created listener.
It would display an error with a message asking for the listener name to be specified.
It would show you a list of listeners and prompts for the listener name that you want to start.
第9题:
whether the password is set in the listener or a file or not
the number of client connections the service handler has refused
the information will be displayed whether the instance can accept connections or not
the protocol addresses on which the listener is configured to listen
第10题:
It gets it from the parameter file.
The listener prompts for details on startup.
The listener gathers information from the control file.
The instance automatically registers with the default listener.
The listener gets this information through thelistener.orafile.
第11题:
Enable instance failover
Configure shared server
Enable database failover
Enable connect-time failover
Enable Transparent Application Failover (TAF)
第12题:
It would attempt to start the default listener
It would start the most recently created listener.
It would display an error with a message asking for the listener name to be specified.
It would show you a list of listeners and prompts for the listener name that you want to start.
第13题:
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?()
第14题:
You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types?()
第15题:
You work as a database administrator for Certkiller .com. 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. lsnrctl>START What statement is true?()
第16题:
You are maintaining the database of a company. The listener process, listener1, is configured for remote access. You have issued the following command: LSNRCTL>STATUS listener1 Which information will NOT be displayed when you issue the above command?()
第17题:
You work as a database administrator for Certkiller .com. Your listener process, L1,is currently listening to three databases:CertK INDB04,Certkiller DB05 and Certkiller DB06. Using Database Configuration Assistant (DBCA) you create one more database,Certkiller 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, Certkiller DB07, with the L1 listener process?()
第18题:
by using the STATUS command of the Listener control utility
by using the STATUS L1 command of the Listener control utility
by using the SHOW RULES command of the Listener control utility
by using the SET PASSWORD command of the Listener control utility
by searching for the PASSWORD_LISTENER entry in the listener.ora file
第19题:
snmp.ora
names.ora
spfile.ora
sqlnet.ora
listener.ora
tnsnames.ora
第20题:
Host naming
Local naming
Easy Connect
External naming
directory naming
第21题:
Enable instance failover
Configure shared server
Enable database failover
Enable connect-time failover
Enable Transparent Application Failover (TAF)
第22题:
It gets it from the parameter file.
The listener prompts for details on startup.
The listener gathers information from the control file.
The instance automatically registers with the default listener.
The listener gets this information through thelistener.orafile.
第23题:
by using the STATUS command of the Listener control utility
by using the STATUS L1 command of the Listener control utility
by using the SHOW RULES command of the Listener control utility
by using the SET PASSWORD command of the Listener control utility
by searching for the PASSWORD_LISTENER entry in the listener.ora file
第24题:
Information about each Oracle Net connection.
Information about each entry in theLinstener.orafile
Information about the changed done in the database
Information about the different listeners in your system
Information about all thenondatabasefiles required to operate the database