Load balancing
Instance failover
Database failover
Connect-time failover
Transparent Application Failover (TAF)
第1题:
下面给出一个tnsnames.oratest1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sevel.haunting.com)(Port=1521)))(CONNECT_DATE=(service_name=sevel))test=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=serv2.haunting.com)(Port=1521)))(CONNECT—DATE=(sid-testdb))以下说法错误的是()。
第2题:
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command: RESTORE CONTROLFILE FROM AUTOBACKUP; Which of the following statements is true?()
第3题:
下面给出一个tnsnames.oraNAMES.DIRECTORY_PATH=(TNSNAMES,….)NAMES.DEFAULT_DOMAIN=server.Comtnsnames.ora文件:test=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=testserver)(PORT=1521)))(CONNECT—DATA=(SERVICE—NAME=orcl.testserver.com)))用该网络服务名连接时会出错,下列说法中错误的是()。
第4题:
The following are the details of your database: Instance name:test Host name:tech1.us.oracle.com IP address:145.33.230.186 Enterprise Manager Console HTTP Port number:5500 You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control?()
第5题:
You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb Which three statements are correct regarding the connection string?()
第6题:
The three tasks shown have been completed in order to configure a naming method: Task 1: Installed on server and client: Oracle Net Services, TCP/IP, TCP/IP protocol adaptor Task 2: Started default listener on port 1521 Task 3: Added global database name to the listener.ora file. Which naming method was configured?()
第7题:
Your database is not configured for session failover. Your tnsnames.ora file contains the following details: test.us.oracle.com= (DESCRIPTION= (ADDRESS_LIST= (LOAD_BALANCE=off) (FAILOVER=ON) (ADDRESS= (PROTOCOL=tcp)(HOST=test1-server)(PORT=1521)) (ADDRESS= (PROTOCOL=tcp)(HOST=test2-server)(PORT=1521))) (CONNECT_DATA= (SERVICE_NAME=test.us.oracle.com))) Which feature is enabled in this case?()
第8题:
TNSLSNR
LISTENER
LOCAL_LISTENER
DEFAULT_LSRN
第9题:
host naming method
local naming method
directory naming method
external naming method
第10题:
The command restores only the missing control file.
The command restores all the control files.
The command fails because the database is running.
This is the correct way to address this problem.
This is not the correct way to address this problem.
第11题:
Restart the Workstation service on your computer.
Change all of your TCP port exceptions to UDP port exceptions.
Ensure parental controls are not configured to block file sharing.
Clear the Block all incoming connections check box in Windows Firewall.
第12题:
examine the trace file and kill the session that caused the deadlock
examine the trace file and kill both the sessions responsible for the deadlock
examine the trace file for details and ask the user who caused the deadlock to roll back the transaction
examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database
examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
第13题:
Interface ge-0/0/2.0 of your router is attached to the Internet and is configured with an IP address and network mask of 71.33.252.17/24. A host with IP address 10.20.20.1 is running an HTTP service on TCP port 8080. This host isattached to the ge-0/0/0.0 interface of your router. You must use interface-based static NAT to make the HTTP service on the host reachable from the Internet. On which IP address and TCP port can Internet hosts reach the HTTP service?()
第14题:
You have just run this syntax to start the listener from the Listener Control utility: LSNRCTL>START 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?()
第15题:
The sysdumpdev command can be used to configure remote dump devices. Which of the following conditions is NOT used for a remote dump device configuration?()
第16题:
Your tnsnames.ora file has the following entry for the service alias ORCL: ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.156.24.216) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.oracle.com) ) ) The TNSPING command executes successfully when tested with ORCL but you are not able to connect to the database instance with the following command: SQL> CONNECT scott/tiger@orcl What could be the reason for this?()
第17题:
You plan to use static database registration for a new listener when you create it. What could be the two reasons for this?()
第18题:
Your alert log file has the following information: Tue May 25 17:43:38 2004 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc. What would you do to ensure that database is still running correctly?()
第19题:
You are the administrator of Company.com’s Windows 2000 Network. Your routed TCP/IP network consists of 10 Windows 2000 Server computers and 75 Windows 2000 Professional computers. All computers are in the Company.com domain. Your network uses TCP/IP as the only network protocol. You are installing 10 new Windows 2000 Professional computers. You want to enable the new computers to use host names to connect to shared resources on the network. You configure a TCP/IP address, a gateway address and a subnet mask on each new computer. You want to complete the configuration to allow the computers to communicate on the network. What should you do?()
第20题:
The local and the remote host must have Transmission Control Protocol/Internet Protocol (TCP/IP) installed and configured.
The remote host must support NFS.
The remote host must have an NFS exported directory defined such that the local host has read and write permissions to the dump file on the remote host.
The remote host can be the same as the local host.
第21题:
Load balancing
Instance failover
Database failover
Connect-time failover
Transparent Application Failover (TAF)
第22题:
The listener is not running at the server.
The TNS_ADMIN environmental variable is set to a wrong value.
The orcl.oracle.com database service is not registered with the listener.
The DEFAULT_DOMAIN parameter is set to a wrong value in the SQLNET.ORA file.
第23题:
http://145.33.230.186:5500/em
http://www.145.33.230.186:5500/em
http://tech1.us.oracle.com:5500/em
http://test.145.33.230.186:5500/em
http://test.tech1.us.oracle.com:5500
http://www.tech1.us.oracle.com:5500/em
http://test.tech1.us.oracle.com:5500/em
第24题:
IP address 10.10.10.1 and TCP port 8080
IP address 71.33.252.17 and TCP port 80
IP address 71.33.251.19 and TCP port 80
IP address 71.33.252.19 and TCP port 8080