首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
80
问题
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,
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
Writealettertooneofyourfriends,apologizingtohim/herforyourmakinghis/hercomputerstopworking.Youshouldwrite
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
设置网络打印机,不允许每个连接到该计算机的用户都使用该网络打印机,只允许用户Administrators和Powerusers使用本地打印机。
随机试题
下列均是补中益气汤主治病证的临床表现,除外()
A、卫生部门B、中医药管理部门C、发展和改革委员会D、工业和信息化管理部门E、公安部门承担中药材生产扶持项目管理的是
按被评估设备现时的完全重置成本(重置全价)扣减其各项损耗价值来确定被评估设备价值的方法是( )。
导游员在制订活动日程时,要()。
有一个五位数,左边的三位数比右边的两位数的4倍还多4,如果把右边两位数移到最前面,新的五位数比原来的2倍还多11122,则原来的五位数是:
2012年全国医疗卫生机构诊疗人次相比上年增长了()。
林教授的结论基于以下哪项假设?
中国坚定不移地奉行独立自主的和平外交政策,走和平发展道路,是因为()
求∫x2arctanxdx.
【21】【36】
最新回复
(
0
)