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

多选题You plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）AMore than one database is to be registered with the listener.BThe users will connect the database by using the host naming met

题目
多选题
You plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）
A

More than one database is to be registered with the listener.

B

The users will connect the database by using the host naming method.

C

The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.

D

The database that is to be registered with the listener is configured in shared server mode.

E

The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

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

第1题：

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.

第2题：

You work as a database administrator for Certkiller .com. You are using three database， Certkiller DB01， Certkiller DB02， and Certkiller DB03， on different host machines in your development environment. The database serverconfiguration， such as IP address and listener port number， change frequently due to development requirements， and you havethe task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）

  • A、Host naming
  • B、Local naming
  • C、Easy Connect
  • D、External naming
  • E、directory naming

正确答案:E

第3题：

Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()

A. You can use RMAN stored scripts

B. Recovery is faster if data is stored in catalog in addition to the control file

C. You can store backup information of all registered databases in one place

D. Database backups are automatically deleted when they are older than the specified time period


参考答案：A, C

第4题：

You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）

  • A、Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.
  • B、Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’
  • C、Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）
  • D、Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport

正确答案:C

第5题：

You plan to use static database registration for a new listener when you create it.What could be the two reasons for this？（）

  • A、More than one database is to be registered with the listener.
  • B、The users will connect the database by using the host naming method.
  • C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
  • D、The database that is to be registered with the listener is configured in shared server mode.
  • E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

正确答案:C,E

第6题：

You are working on a new Oracle Database 11g server， where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.Some of the requirements set for your database creation task are： 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management （ASM） for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database（）

  • A、4 and 6
  • B、2，3，4，and 6
  • C、1，2，4，5，and 6
  • D、1，2，3，4，5，and 6

正确答案:C

第7题：

Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）

  • A、 You can use RMAN stored scripts.
  • B、 Recovery is faster if data is stored in catalog in addition to the control file.
  • C、 You can store backup Information of all registered databases in one place.
  • D、 Database backups are automatically deleted when they are older than the specified time period.

正确答案:A,C

第8题：

Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).()(Choose two.)

A. You can use RMAN stored scripts

B. Recovery is faster if data is stored in catalog in addition to the control file

C. You can store backup information of all registered databases in one place

D. Database backups are automatically deleted when they are older than the specified time period


参考答案：A, C

第9题：

You need to design a configuration for Exchange Server storage that meets the business and technical requirements. What should you do？（）

  • A、Create a single storage group. Create one database for all users
  • B、Create two storage groups. In each storage group， create one database. Place mailboxes for remote users in one storage group database， and place all other mailboxes in the other storage group database
  • C、Create two storage groups. In each storage group， create one database. Place executive mailboxes in one storage group database， and place all other mailboxes in the other storage group database
  • D、Create two storage groups. In one storage group， create a database， and place all mailboxes for remote users and executives in the database. In the other storage group， create a database for all other mailboxes

正确答案:C

第10题：

If you create your database using Oracle Managed Files （OMF）， what is true？（）

  • A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 
  • B、You must define directories for two online redo log groups and three copies of the control file. 
  • C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 
  • D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

正确答案:D

更多相关问题
相关内容