违法和不良信息举报 联系客服
免费注册 登录

单选题What is the new Oracle Shared Server?（）A An improved version of multithreaded server configuration. B A connection pooling configuration where several clients are connected to the same server process. C Two more database servers, which share data by me

题目
单选题
What is the new Oracle Shared Server?（）
A

An improved version of multithreaded server configuration. 

B

A connection pooling configuration where several clients are connected to the same server process. 

C

Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected. 

D

A configuration of Real Application Cluster where the client connection is routed to the least busy instance. 

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.

The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.

How should you configure the database?

A．Configure the database on the two servers as a SQL Server 2000 cluster.

B．Configure the database on one server, and then configure a standby database on the second server.

C．Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.

D．Configure the database as a federated database, and then partition half the data on each server.


正确答案：A
解析：Explanation: SQL Server 2000 failover clustering provides high availability support by allowing us to configure one failover cluster to automatically, with no manual configuration, fail over to any other node in the failover cluster configuration. In this way, we minimize system downtime and provide high server availability during an operating system failure or a planned upgrade. Before SQL Server 2000 failover clustering can be set up, we must install Windows NT 4.0, Enterprise Edition, Windows 2000 Advanced Server or Windows 2000 Datacenter Server, and the Microsoft Cluster Service (MSCS).

In this scenario a cluster would be preferred to a standby server because it would be available immediately. A standby server on the other would require manual configuration and more time to become online.

Incorrect Answers:
B: A standby server would require you to reconfigure clients to allow it to connect to the standby server when the main server goes down. It would require at least several minutes of manual administration before the standby server would be operational. But the scenario requires that no reconfiguration of the client computers should be necessary. Therefore we should use a SQL Server 2000 cluster not a standby server.

Note: A standby server is a second server that contains a copy of the databases on the primary server and that can be brought online in the event of a primary server failure or due to scheduled maintenance on the primary server. This allows users to continue working with databases when the primary server becomes unavailable. When the primary server becomes available again, any changes to the standby server's copies of databases must be restored back to the primary server.

C: The Microsoft Distributed Transaction Coordinator coordinates distributed transactions, but would not increase availability.

Note: The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the transaction.

An installation of SQL Server 2000 can participate in a distributed transaction by calling stored procedures on remote servers running SQL Server, automatically or explicitly promoting the local transaction to a distributed transaction and enlist remote servers in the transaction, and making distributed updates that update data on multiple OLE DB data sources. If these OLE DB data sources support the OLE DB distributed transaction interface, SQL Server 2000 can also enlist them in the distributed transaction. The MS DTC service coordinates the proper completion of the distributed transaction to ensure that either all of the updates on all the servers are made permanent, or, in the case of errors, all erased.

D: With Federated SQL Server 2000 servers, SQL Server 2000 databases can be spread across a group of autonomous database servers. These are capable of supporting the processing growth requirements of the largest Web sites and enterprise data-processing systems built with Microsoft Windows DNA, which divides the processing units of a data processing system into logical tiers. This however does not improve availability.

第2题：

What is the new Oracle Shared Server?（）

  • A、An improved version of multithreaded server configuration. 
  • B、A connection pooling configuration where several clients are connected to the same server process. 
  • C、Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected. 
  • D、A configuration of Real Application Cluster where the client connection is routed to the least busy instance. 

正确答案:A

第3题：

You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.

What should you do?

A．Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.

B．Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.

C．Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.

D．Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.


正确答案：A
解析：Explanation:Detachingandattachingdatabasesissometimesausefultechniqueforquicklymovingadatabasefromonecomputertoanother.Tomoveadatabase,ordatabasefile,toanotherserverordiskthedatabasemustfirstbedetachedfromtheoriginalserverordisk;movedtotheotherserverordiskandthenattachedontheserverordisk.Inadditionthenewlocationofthemovedfile(s)mustbespecified.Thesp_detach_dbstoredprocedureisusedtodetachthedatabaseandcanrunUPDATESTATISTICSonalltablesbeforedetachingthedatabasewhilethesp_attach_dbstoredprocedureisusedtoattachthedatabaseinitsnewlocation.IncorrectAnswers:B:DTScanimportdatafromatextfileorfromanOLEDBdatasourcesuchasaMicrosoftAccess2000databaseintoSQLServer.ItcanalsoexportdatafromSQLServertoanOLEDBdatadestination.Itprovidesforhigh-speeddataloadingfromtextfilesintoSQLServertables.However,itisnotthefastestwaytomoveawholedatabasefromoneservertoanother.C:Beforeadatabasecanberestoredfromabackuptoanewlocation;thedatabasemustfirstberecreatedinthedestinationasthebackupholdsonlythedatafilesthatbelonginthevarioustables.Itdoesnotholdthetabledefinitions.Thisisnotthefastestmethodtomoveadatabase.D:TheDISKINITandDISKREFITcommandscannotbeusedtomoveadatabasefromoneservertoanother.Note:DISKINITandDISKREINITarefeaturesthatareusedinaSQLServer6.x.inSQLServer6.x,DISKINITisusedtocreatedatabaseortransactionlogdevicestostorethespecifieddatabaseortransactionlogwhenDISKINITfollowedeitheraCREATEDATABASEorALTERDATABASEstatementwhileDISKREINITisusedtorestoredeviceentriestoappropriatesystemtableswhenthedeviceentrywasmissingfromsysdevices.InSQLServer2000theCREATEDATABASEandALTERDATABASEstatementsallowforthecreationofseparatedataandlogfiles.BothCREATEDATABASEandALTERDATABASEcreateoperatingsystemfilesanddatabasesinasinglestep.ItisthusrecommendedthatallreferencestoDISKINITshouldberemovedinSQLServer2000andreplacedwithreferencestoeitherCREATEDATABASEorALTERDATABASE.

第4题：

The direct handoff connection method to an Oracle9i Shared Server involves fewer messages than in previous releases of the multithreaded architecture. Which type of message has been eliminated？（）

  • A、The initial request from the client to the listener.
  • B、Messages between the dispatcher and the shared server background processes.
  • C、A redirect message from the listener to the client during client connections.
  • D、Round-trip messages between the listener and the shared server background processes.

正确答案:C

第5题：

Companycom will be using the Virtual IO Server to share both FC and Ethernet adapters among multiple LPARs. The customer is using mostly web services in the LPARs. Which of the following should be considered?（）

  • A、Shared Ethernet Adapters and Virtual SCSI services require separate Virtual IO Servers.
  • B、Virtualized adapters require essentially the same Virtual IO Server resources regardless of adapter type.
  • C、Shared Ethernet Adapters require significantly more Virtual IO Server resources than Virtual SCSI services.
  • D、Virtual SCSI services require significantly more Virtual IO Server resources than Shared Ethernet Adapters.

正确答案:C

第6题：

Which of the following is the functional description of a server connected between two separate IP subnets？（）

  • A、 server as a bridge
  • B、 server as a router
  • C、 server as a switch
  • D、 server as a data link

正确答案:B

第7题：

A Windows server has rebooted by itself several times.There are several functioning non-Windows servers in the same rack that are connected to the same uninterruptible power supply（UPS）.Which of the following is the MOST likely cause of the reboots？（）

  • A、The UPS is malfunctioning.
  • B、The user traffic to the server is too high.
  • C、A BSOD is occurring.
  • D、The non-Windows servers cannot be located on the same UPS as the Windows server.

正确答案:C

第8题：

A new server was installed. Most clients are located in the same subnet as the server and can successfully access the server. Clients located on different subnets have been unable to access the server, but have no trouble accessing other servers on their subnet.Which of the following is the reason that these clients are unable to access the server?（）

A. DHCP has assigned the wrong addresses.

B. Incorrect default gateway on the server.

C. DNS entries were not created.

D. WINS server is not responding.


参考答案：B

第9题：

Which statement is true regarding Oracle Shared Server architecture？（）

  • A、A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher. 
  • B、Under the Oracle Shared Server architecture, client-user processes connect to shared user processes.
  • C、Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher. 
  • D、Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.

正确答案:D

第10题：

You want to migrate an application that was developed for OAS/OC4J to WebLogic. The application uses Oracle Streams Advanced Queuing (AQ). You configured a Foreign JMS Server and Data Source but you are not able to send messages to the AQ destination and see them reach the database. Which two things are missing in this configuration?（）

  • A、nothing, there may be a network connection issue
  • B、a Foreign JMS Connection Factory
  • C、a JMS Bridge to map the JNDI of the Local JMS Destination to the remote AQ destination
  • D、a mapping of the Foreign JMS Connection Factory to the Data Source where AQ is configured and installed
  • E、Oracle AQ Java EE Shared Libraries not deployed and referenced by your application

正确答案:C,E

更多相关问题
相关内容