首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 database. You import a table of geographic information from a Microsoft access da
You are the administrator of a SQL Server 2000 database. You import a table of geographic information from a Microsoft access da
admin
2009-05-19
98
问题
You are the administrator of a SQL Server 2000 database. You import a table of geographic information from a Microsoft access database into a SQL Server 2000 database. The table has 12,000 rows. Each row averages 5,000 bytes. The table contains lockup data that does not change.
You want to minimize the size of the data file and the time required to back up the data. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)
A. Create a 60-MB data file named geography.ndf
B. Create a 95-MB data file named geography.ndf
C. Create a 60-MB data file named geography.mdf
D. Create a 95-MB data file named geography.mdf
E. Place the table in the PRIMARY filegroup.
F. Place the table in a new filegroup named LOCATION.
选项
答案
B,F
解析
Explanation: As SQL Server 2000 supports backing up or restoring individual files or file groups within a database, it is possible to reduce back up time by creating a separate data file table so that only that table will be backed up. This separate data file will have to be a secondary data file because a database can only have one primary data file, which is identified by the .mdf extension, it is the starting point of the database and locates all the other files in the database. Secondary data files are identified by the .ndf extension and comprise all of the data files except the primary data file. A database need not have a secondary data file and it is also possible to create multiple secondary data files on database.
Rows are stored in data pages. Rows cannot cross different data pages. The size of data page in SQL Server 2000 (or SQL 7.0) is 8,192 bytes. We can only store one row in every data page in this scenario. Thus, to estimate the size of the tale we would need to multiply the number of rows, 12,000 in this scenario, by 8,192 bytes. This will give us a table size of 98,304,000 bytes. As computer data storage is calculated using the binary rather than the decimal system, there is 1,024 bytes per Kb and 1,024 Kb per MB, rather than 1,000 bytes per Kb and 1,000 Kb per MB, we thus require a database size of at least 93.75 MB.
Incorrect Answers:
A: The data size of this table is insufficient as a minimum size of 93.75 MB is required.
C: The data size of this table is insufficient as a minimum size of 93.75 MB is required. Furthermore, the .mdf file extension indicate in this solution implies that the data file will be placed in the primary filegroup. It would thus not be possible to backup the data file pertaining to the table only.
D: The .mdf file extension indicate in this solution implies that the data file will be placed in the primary filegroup. It would thus not be possible to backup the data file pertaining to the table only.
E: As SQL Server 2000 supports backing up or restoring individual files or file groups within a database, it is possible to reduce back up time by creating a separate data file table so that only that table will be backed up. This separate data file will have to be a secondary data file because a database can only have one primary data file, which is identified by the .mdf extension, it is the starting point of the database and locates all the other files in the database.
转载请注明原文地址:https://kaotiyun.com/show/tuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
Climatechangeissupposedtounfoldslowly,overdecades.Butthatisnottrueupinthegreatwhitenorth,asthoseattending
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
随机试题
下列古注属于义疏类注释类型的是()
患者男性,28岁,下颌第一恒磨牙咬合不适1周,感患牙伸长,初时紧咬牙可缓解不适,昨天开始不敢咬牙并出现自发痛,无放射痛,口腔检查下颌第一恒磨牙远中颌面深龋及髓,探(-),可疑叩痛,牙齿不松动,龈(-),根尖区压痛(+)根据上述材料,最可能的诊断为
集体合同或专项集体合同签订或变更后,应当自双方首席代表签字之日起()内,由用人单位一方将文本一式三份报送劳动保障行政部门审查。
经检验检疫机关( ),签发《植物检疫证书》及《入境货物通关》,准予入境。
“备案号”栏:()。“商品名称,规格型号”栏:()。
注明“现金”字样的银行本票不得背书转让。()
散客由于批量少、总人数多的特征,形成了()的特点。
从1978年到1992年,历经14年的探索和实践,中国特色社会主义道路有了明确方向。这里的“方向”指()。
在国家政权中,军队与警察是最主要的支柱。()
阅读下列说明,回答问题1至问题3,将解答填入答题纸的对应栏内。[说明]某市级政府部门拟采购便携式笔记本,采购预算30万元;专业定制的数据采集设备,预算90万元;软件应用系统,开发预算110万元。现就上述内容的招标方式向监理单位进行咨询。[事件1]监理
最新回复
(
0
)