单选题You want to consolidate some of the databases onto existing SQL Server computers until additional hardware can be purchased.You need to identify which of the servers， in its current configuration， can support additional databases. You need to ensure th

题目
单选题
You want to consolidate some of the databases onto existing SQL Server computers until additional hardware can be purchased.You need to identify which of the servers， in its current configuration， can support additional databases. You need to ensure that your solution fulfills the company’s securiy requirements while allowing for future database growth requirements. Which server and database combination can be used？（）
A

SQL3 with the OnlineReadOnly and HR databases

B

SQL4 with the TravelOnline and Storefront databases

C

SQL2 with the Storefront and TravelOnline databases

D

SQL2 with the Storefront and HR databases

相似考题

1.Some of you may have finished unitone, _______, you can move onto unit two.A、if you mayB、if you doC、if notD、if so

2.Do you want some milk? ()此题为判断题(对，错)。

3.You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）A. MERGEB. INSERTC. UPDATED. ADDE. ENTERF. You cannot enter the phone numbers for the existing employee records.

4.You will find as you read this book that you just can't keep some of these stories to ___. You will want to share them with a friend.A、itselfB、yourselfC、himselfD、themselves

更多“You want to consolidate some of the databases onto existing ”相关问题

  • 第1题：

    You want to install Windows 2000 Professional on 20 new PXE compliant computers, which do not have operating systems installed. You create a RIS image and load the image onto the RIS server and then start the new computers. You find that the new computers cannot connect to the RIS server. You verify that existing client computers on the network can connect to network servers.

    What should you do? (SELECT AND PLACE)


    正确答案：<m x1="543" x2="603" y1="191" y2="261" ss="0" a="0"></m><m x1="639" x2="702" y1="189" y2="261" ss="0" a="1"></m><m x1="544" x2="604" y1="294" y2="367" ss="0" a="2"></m><m x1="644" x2="706" y1="291" y2="367" ss="0" a="3"></m><m x1="613" x2="684" y1="28" y2="98" ss="1" a="0"></m><c start="3" stop="0"></c>
    <m x1="543" x2="603" y1="191" y2="261" ss="0" a="0"></m><m x1="639" x2="702" y1="189" y2="261" ss="0" a="1"></m><m x1="544" x2="604" y1="294" y2="367" ss="0" a="2"></m><m x1="644" x2="706" y1="291" y2="367" ss="0" a="3"></m><m x1="613" x2="684" y1="28" y2="98" ss="1" a="0"></m><c start="3" stop="0"></c> 解析：
    RIS has the following requirements: (1) DNS server, (2) DHCP server and (3) Active Directory (Windows 2000 Domain Controller)
    The exhibit shows the presence of Active Directory and DNS, but a lack of a DHCP server. We must therefore add a DHCP server.

    Incorrect Answers:
    RIS does not use either Global Catalog servers or WINS servers.

  • 第2题：

    You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.

    However, the existing SQL server computers in your office are configured to use the

    SQL_Latin1_General_CP1_CI_AS collation.

    You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.

    What should you do?

    A．Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.

    B．Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.

    C．Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.

    D．Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.


    正确答案：B
    解析：Explanation:CollationscontrolthephysicalstorageofcharacterstringsinSQLServer2000byspecifyingthebitpatternsthatrepresenteachcharacterandtherulesbywhichcharactersaresortedandcompared.WhereasearlierversionsofSQLServersupportedonlyonecollationforeachinstanceofSQLServer,SQLServer2000allowsobjectsthathavedifferentcollationstobestoredinasingledatabase.WecanthusrestorethedatabasetoanexistingSQLServer2000computerwithouthavingtochangethecollationofthatdatabase.IncorrectAnswers:A:TherebuildmutilityrebuildsthemasterdatabaseandcanbeusedtochangethecollationsettingsofaninstanceofSQLServer2000,ortofixacorruptedmasterdatabase.Rebuildingthemasterdatabaseinvolvesremovesalldatabaseobjectsanddata,re-createthedatabaseobjectsandreloadthedata,orreattachthedataandlogfilesusingsp_attach_dbwhentherebuildiscomplete.C:CollationscontrolthephysicalstorageofcharacterstringsinSQLServer2000byspecifyingthebitpatternsthatrepresenteachcharacterandtherulesbywhichcharactersaresortedandcompared.WhereasearlierversionsofSQLServersupportedonlyonecollationforeachinstanceofSQLServer,SQLServer2000allowsobjectsthathavedifferentcollationstobestoredinasingledatabase.ItisthusnotnecessarytoinstallanewinstanceofSQLServer2000inordertorestorethedata.WecaninsteadrestorethedatabasetoanexistingSQLServer2000computerwithouthavingtochangethecollationofthatdatabase.D:CollationscontrolthephysicalstorageofcharacterstringsinSQLServer2000byspecifyingthebitpatternsthatrepresenteachcharacterandtherulesbywhichcharactersaresortedandcompared.WhereasearlierversionsofSQLServersupportedonlyonecollationforeachinstanceofSQLServer,SQLServer2000allowsobjectsthathavedifferentcollationstobestoredinasingledatabase.ItisthusnotnecessarytoinstallanewinstanceofSQLServer2000onanewcomputerinordertorestorethedata.WecaninsteadrestorethedatabasetoanexistingSQLServer2000computerwithouthavingtochangethecollationofthatdatabase.

  • 第3题：

    Do you want some______（蔬菜）soup?


    正确答案：
    12. vegetable

  • 第4题：

    What do you want, Mary?（）

    ANo, I want some water.

    BYes, I plan to go shopping.

    CI'd like some red wine, please. 

    DNo, I don't eat.


    C
    略

  • 第5题：

    You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMAN>CHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?（）

    • A、The backup is deleted.
    • B、The backup is marked unavailable.
    • C、The backup overrides the backup retention policy.
    • D、the backup becomes eligible for deletion according to the existing retention policy

    正确答案:D

  • 第6题：

    If an existing script is uploaded to the CRS, what does it ask?（）

    • A、Do you want to debug the script?  
    • B、Do you want to refresh the script?  
    • C、Do you want to save the application?  
    • D、Do you want to return to Script Management? 

    正确答案:B

  • 第7题：

    In which scenario will you use the Flashback Version Query feature？（）

    • A、 when you want to restore a table that has been dropped from the Recycle Bin
    • B、 when you want to identify the transaction ID of the transaction that deleted some important records from a table
    • C、 when you want to recover the schema of a dropped user
    • D、when you want to restore a dropped tablespace

    正确答案:B

  • 第8题：

    You have just added three new hard disks to your Windows 2000 Professional computer. You want to configure all of the disks as two drives. You want the two drives to be as equal in size as possible. You want to configure the non-system drive for the best optimal performance.  What should you do?（）

    • A、Extend the system volume onto disk1. Create a single, stripe volume from disk2 and disk3.
    • B、Extend the system volume onto disk2. Create a single, stripe volume from disk1 and disk2
    • C、Extend the system volume onto disk1. Create a single, spanned volume from disk2 and disk3. 
    • D、Extend the system volume onto disk1. Create a single, spanned volume from disk1 and disk2.
    • E、Create a single, stripe volume from disk1, disk2, and disk3. 
    • F、Create a single spanned volume from disk1, disk2, and disk3. 

    正确答案:A

  • 第9题：

    单选题
    If you want to be quiet and have some relaxing walks, you may pay a visit to _____.
    A

    Dollymont and Donabate

    B

    Donabate and Malahide

    C

    Dollymont and Killiney

    D

    Killinev and Malahide


    正确答案： A
    解析：
    文章第一段最后一句提到“…Its shoreline is well recommended for a few quiet and unworried walks along the beach”，文章第三段第一句提到“it is equally grand for relaxing walks”Dollymont和Killiney适合轻松、安静地散步。故选C。

  • 第10题：

    单选题
    You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）
    A

    Place each database in a separate instance running on SQL2.

    B

    Place each database in a separate instance running on SQL3.

    C

    Place both databases in a single instance running on SQL2.

    D

    Place both databases in a single instance running on SQL3.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    What do you want, Mary?（）
    A

    No, I want some water.

    B

    Yes, I plan to go shopping.

    C

    I'd like some red wine, please. 

    D

    No, I don't eat.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    If you want to eat some seafood, you can go to ______.
    A

    Willie Mae’s

    B

    Natasha’s Kitchen

    C

    Eiffel society

    D

    Hoshun restaurant


    正确答案： D
    解析：
    根据题干可知，如果你想吃一些海鲜的话，只能到Natasha’s Kitchen，故选B项。

  • 第13题：

    You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.

    You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.

    How should you configure SQL1?

    A．Use the ALTER DATABASE statement to change the collation of the databases on SQL1.

    B．Add SQL2 as remote server.

    C．Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.

    D．Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2.


    正确答案：C
    解析：Explanation:WeshouldsetupSQL2asalinkedserver.Thiswouldenabletoissuedistributedqueriestoit.WeshouldalsoselectRemoteCollationoptiontousethecollationontheremoteserver.Note:SQLServer2000allowsthecreationoflinkstoOLEDBdatasourcescalledlinkedservers.AfteralinkhasbeencreateditispossibletoreferencerowsetsfromtheOLEDBdatasourcesastablesinTransact-SQLstatementsandpasscommandstotheOLEDBdatasourcesandincludetheresultingrowsetsastablesinTransact-SQLstatements.Eachdistributedquerycanreferencemultiplelinkedserversandcanperform.eitherupdateorreadoperationsagainsteachindividuallinkedserver.Asingledistributedquerycanperform.readoperationsagainstsomelinkedserversandupdateoperationsagainstotherlinkedservers.Thelinkedserveroptionsdefinedbyusingthesp_serveroptionstoredprocedurecontrolhowSQLServerusescollationsfromlinkedservers.WhentheUseRemoteCollationoptionissettoTRUE,itspecifiesthatthecollationofremotecolumnsisusedforSQLServerdatasources,andthecollationspecifiedinCollationNameisusedfordatasourcesotherthanSQLServer.WhenFALSE,distributedqueriesalwaysusethedefaultcollationofthelocalserverinstance,andCollationNameandthecollationofremotecolumnsareignored.IftheUseRemoteCollationoptionissettoTRUE,wecanspecifythenameofthecollationusedbytheremotedatasourceintheCollationNameoption.Thecollationmust,however,besupportedbySQLServer.ThisoptionshouldbeusedwhenaccessinganOLEDBdatasourceotherthanSQLServer,butwhosecollationmatchesoneoftheSQLServercollationsIncorrectAnswers:A:TheCOLLATEclauseoftheALTERDATABASEstatementcanbeusedtochangethecollationusedbythedatabase.However,thissolutionisinappropriateastheSQL2servercontainsseveraldatabases,eachofwhichusesadifferentcollation.Wewouldthusnotbeabletospecifyallthecollations.B:Remoteserversaresetupinpairswithbothserversconfiguredtorecognizeeachotherasremoteservers.TheconfigurationoptionsforbothserversshouldbesetsothateachinstanceofSQLServerallowsremoteuserstoexecuteprocedurecalls.However,supportforremoteserversisprovidedforbackwardcompatibilityonly.ApplicationsthatmustexecuteproceduresagainstremoteinstancesofSQLServer2000shoulduselinkedserversinstead.D:InthisscenariowecannotspecifythecollationnameasSQL2containsseveraldatabases,eachofwhichuseadifferentcollation.

  • 第14题：

    You want to use the Web to let Eternal users or your customers look at corporate information. But you want to keep installation at the user end(66)and you don't want just anyone to get(67)your databases.

    That may be where an application server enters the picture. For more user machine independent, these t software packages, typically written in the(68)programming language.

    for use on Windows NT-based systems, act as go-betweens linking browser-equipped end users to the databases that(69)the information they need to(70)。

    A．simple

    B．simply

    C．single

    D．singly


    正确答案：A

  • 第15题：

    What can I do for you, sir?（）

    ACan you lend me some money?

    BNothing.

    CI want a pair of shoes.

    DWhatever


    C
    略

  • 第16题：

    What do you want, Mary?（）

    • A、No, I want some water.
    • B、Yes, I plan to go shopping.
    • C、I'd like some red wine, please. 
    • D、No, I don't eat.

    正确答案:C

  • 第17题：

    You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）

    • A、MERGE
    • B、INSERT
    • C、UPDATE
    • D、ADD
    • E、ENTER
    • F、You cannot enter the phone numbers for the existing employee records.

    正确答案:C

  • 第18题：

    In which scenario will you use the Flashback Transaction Query feature？（）

    • A、 when you want to restore an important table that is dropped from the Recycle Bin
    • B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
    • C、when you want to restore a dropped user’s schema
    • D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

    正确答案:B

  • 第19题：

    You are an administrator of ETECHSOL.COM domain.  You want to install Win2000 Professional on 20 new PXE compliant computers that do not have any operating systems installed on them.  You create a RIS image and load the image onto the RIS server and then start the new computers. You find that the new computers cannot connect to the RIS server. You verify that existing client computers on the network can connect to network servers also.  What should you do? （）

    • A、 Create an Active Directory on a server.
    • B、 Setup a server to act as a DHCP server.
    • C、 Install a Remote Access Server.
    • D、 Enable TCP/IP on the client computers.

    正确答案:B

  • 第20题：

    单选题
    In which scenario will you use the Flashback Version Query feature？（）
    A

     when you want to restore a table that has been dropped from the Recycle Bin

    B

     when you want to identify the transaction ID of the transaction that deleted some important records from a table

    C

     when you want to recover the schema of a dropped user

    D

    when you want to restore a dropped tablespace


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option.  After some days， you want to change the status of the database backup and you issued the following command：   RMAN>CHANGE BACKUPSET 231 NOKEEP；   What is the implication of this command？（）
    A

     The backup is deleted.

    B

     The backup is marked unavailable.

    C

     The backup overrides the backup retention policy.

    D

     the backup becomes eligible for deletion according to the existing retention policy.


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）
    A

    MERGE

    B

    INSERT

    C

    UPDATE

    D

    ADD

    E

    ENTER

    F

    You cannot enter the phone numbers for the existing employee records.


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    In which scenario will you use the Flashback Transaction Query feature？（）
    A

     when you want to restore an important table that is dropped from the Recycle Bin

    B

     when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction

    C

    when you want to restore a dropped user’s schema

    D

     when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period


    正确答案： A
    解析： 暂无解析

相关内容