首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory data
You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory data
admin
2009-05-19
75
问题
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: Collations control the physical storage of character strings in SQL Server 2000 by specifying the bit patterns that represent each character and the rules by which characters are sorted and compared. Whereas earlier versions of SQL Server supported only one collation for each instance of SQL Server, SQL Server 2000 allows objects that have different collations to be stored in a single database. We can thus restore the database to an existing SQL Server 2000 computer without having to change the collation of that database.
Incorrect Answers:
A: The rebuildm utility rebuilds the master database and can be used to change the collation settings of an instance of SQL Server 2000, or to fix a corrupted master database. Rebuilding the master database involves removes all database objects and data, re-create the database objects and reload the data, or reattach the data and log files using sp_attach_db when the rebuild is complete.
C: Collations control the physical storage of character strings in SQL Server 2000 by specifying the bit patterns that represent each character and the rules by which characters are sorted and compared. Whereas earlier versions of SQL Server supported only one collation for each instance of SQL Server, SQL Server 2000 allows objects that have different collations to be stored in a single database. It is thus not necessary to install a new instance of SQL Server 2000 in order to restore the data. We can instead restore the database to an existing SQL Server 2000 computer without having to change the collation of that database.
D: Collations control the physical storage of character strings in SQL Server 2000 by specifying the bit patterns that represent each character and the rules by which characters are sorted and compared. Whereas earlier versions of SQL Server supported only one collation for each instance of SQL Server, SQL Server 2000 allows objects that have different collations to be stored in a single database. It is thus not necessary to install a new instance of SQL Server 2000 on a new computer in order to restore the data. We can instead restore the database to an existing SQL Server 2000 computer without having to change the collation of that database.
转载请注明原文地址:https://kaotiyun.com/show/zuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
Inanyrealmoflife-whetheracademic,social,business,orpolitical-theonlywaytosucceedistotalkeapractical,rathe
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
Writeanessayof160-200wordsbasedonthefollowingdrawings.Inyouressay,youshould1)describethedrawingsbriefly,
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
设置网络打印机,不允许每个连接到该计算机的用户都使用该网络打印机,只允许用户Administrators和Powerusers使用本地打印机。
随机试题
下列选项中,不属于人格测量方法的是()。
全过程的质量管理包括了从市场调研、产品的()、生产(作业),到销售、服务等全部有关过程的质量管理。
三氯化铁-铁氰化钾反应的条件是
A.细胞内、外液等量减少B.细胞内液显著减少,细胞外液正常C.细胞内液显著减少,细胞外液轻度减少D.细胞外液显著减少,细胞内液正常E.细胞外液显著减少,细胞内液轻度减少高渗性脱水时,体液容量的变化特点是()
作者在其文学作品上署名,是一种()。
根据个人所得税的相关规定,下列说法正确的有()。
关于个人汽车贷款的原则,下列说法中错误的是()。
小学数学教材中的概念的表现形式有哪些?
阅读以下文段.回答下列问题:1928年,英国有一位名叫森金斯的科学家在实验中发现,一些金属经过高温处理或添加某些元素之后,会变得像面团和软糖一样柔软和易于加工。只要施加很小一点压力和拉力就可以延长几倍、几十倍以至几千倍。于是,便把这种现象称之为超塑现象,
DothefollowingstatementsagreewiththeinformationgiveninReadingPassage1?Inboxes7-13onyouranswersheet,writeT
最新回复
(
0
)