首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
44
问题
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://jikaoti.com/ti/ewO7FFFM
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
Supposeyouwanttoapplyforajobinacompanyasanofficesecretary.Writeanapplicationemailto1)introduceyourself
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
DrRichardBergland,abrainresearcherattheHarvardMedicalSchool,haswrittenapapersuggestingthathumanbrainisbasica
TheoutbreakofswinefluthatwasfirstdetectedinMexicowasdeclaredaglobalepidemiconJune11,2009.Itisthefirstwo
设置过滤器时,应先选择database菜单中的()选项。A.setupB.browseC.appendD.copyto
程序文件执行过程中要使用调试窗口,应该选择()。A.program菜单中的“trace”选项B.database菜单中的“trace”选项C.windows菜单中的“trace”选项D.debug菜单中的“trace”选项
随机试题
患者女,54岁,主诉心前区不适,胸闷气短15min来诊,诊疗过程中病人突然意识丧失,颈动脉摸不到搏动,应立即对病人采取哪项急救措施()
以下属沉淀反应的是
正常足月儿生后可抱至母亲处给予吸吮的时间是
下列哪项不是静脉肾盂造影的禁忌证
下列关于肩关节的说法,错误的是
关于四气,下面哪些是正确的
下列金融工具中,属于直接性金融工具的有( )。
市场细分是基于()进行的划分。
在采用完工百分比法确认收入时,本年确认的收入=劳务总收入×本年年末劳务的完成程度。()
56.Youworkforaforeigncompany.Nowyouwanttoaskforashortperiodofleave.WriteanemailtoyourbossMr.Smithtote
最新回复
(
0
)