首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
85
问题
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
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
[A]Butworkisunderwaytogetcomputerstocapturehumanlifeandrememberitaspeopledo—recallingbitsofexperiencethata
Asthemini-blogisbecomingincreasinglypopularamongnetizens,italsobecomescommontocreaterumors.Youaresupposedtow
OfferingHelpWritealetterofabout100wordsbasedonthefollowingsituation:YourroommateKenismovingtoanother
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
Notlongago,chiefexecutiveofficers(CEOS)werelandedasheroes,leadersofthebraveneweconomy.BillGatesandJackWelchw
Refertotheexhibit.AnetworkassociatehasconfiguredOSPFwiththecommand:City(config-router)#network192.168.12.640.0.0
随机试题
A.30分钟B.1小时C.2小时D.12小时E.24小时采用15%过氧乙酸对病家房间空气进行熏蒸消毒,作用时间应不包括
诊断葡萄胎最有价值的是
脊髓灰质炎病毒的感染方式是
诊断各类型肺炎,最主要的依据是
在《中华人民共和国国家标准(GB/T4754-2002)》中,将社会经济活动划分为( )。
教师在教学中违反教育法规的情形主要有哪三种?应承担怎样的法律责任?
国务院办公厅关于公开发布天气预报有关问题的指示中国气象局:你中国气象局《关于加强发布公众天气预报归口管理的报告》(国气发[2008年]13号)收悉。
(2012年上海.A卷.94)在督查工作中,协助领导搞好预案和各项准备工作,收集各类情况、搞好综合分析研究,提出落实的措施,为修正和完善决策提出意见和建议,这种督查工作方法称为()。
把下面的六个图形分为两类,使每一类图形都有各自的共同特征或规律,分类正确的一项是:
在SQLServer2008的某数据库中,设U1用户是R1角色中的成员,现已授予R1角色对T表具有SELECT和DENYUPDATE权限,同时授予了U1用户对T表具有INSERT和UPDATE权限,则U1用户最终对T表具有的权限是()。
最新回复
(
0
)