首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains a database named Contracts. The server is configure
You are the administrator of a SQL Server 2000 computer. The server contains a database named Contracts. The server is configure
admin
2009-05-19
11
问题
You are the administrator of a SQL Server 2000 computer. The server contains a database named Contracts. The server is configured as shown in the server configuration exhibit.
The database files are configured as shown in the database properties exhibit.
The database developers have been creating new tables and indexes without specifying a filegroup.
The primary filegroup is reaching its maximum capacity.
You want the developers to continue adding new objects, but you do not want then to change the way they create objects. You do not want to run out of disk space. You also want to minimize the time it takes to administer the database.
What should you do?
选项
A、Back up the existing objects on the PRIMARY filegroup. Drop them from the database. Re-create them on the SECONDARY filegroup.
B、Set the file growth on the PRIMARY filegroup to UNLIMITED.
C、Set the PRIMARY filegroup so that it is read-only.
D、Set the SECONDARY filegroup as the default filegroup.
答案
D
解析
Explanation: By setting the secondary filegroup to the default filegroup, user data will be added to this filegroup and the database would be allowed to grow.
Note: In SQL Server 2000 a database is mapped to a set of operating-system files, which stores all data and objects in the database, such as tables, stored procedures, triggers, and views.
In addition to the log file, there are two operating-system files: the primary data file, which contains the startup information for the database and is used to store data, and the secondary data file, which contains all of the data that is not part of the primary data file. If the primary file can hold all of the data in the database, databases do not need to have secondary data files but every database must have one primary data file.
Some databases may be large enough to need multiple secondary data files or to use secondary files on separate disk drives to spread data across multiple disks. These files can be placed into different filegroups. This allows files to be grouped together for administrative and data allocation/placement purposes. The filegroup that contains the primary file is the PRIMARY filegroup.
This filegroup contains the primary data file and any other files that are not put into another filegroup. User-defined filegroups are called SECONDARY filegroups and are any filegroups that are specifically created by the user when first creating or later altering the database. One filegroup is designated as the DEFAULT filegroup.
When objects are created in the database without specifying to which filegroup they belong, they are assigned to the DEFAULT filegroup. By default, the PRIMARY filegroup is designated the DEFAULT filegroup. The DEFAULT filegroup can be changed using the ALTER DATABASE statement. This allows any objects that do not have a filegroup specified when they are created are allocated to the data files in the new DEFAULT filegroup.
However, allocation for the system objects and tables remains within the PRIMARY filegroup, not the new DEFAULT filegroup.
Incorrect Answers:
A: The database startup information and the system objects and tables must remain in the PRIMARY filegroup. These database objects cannot be moved to a SECONDARY filegroup.
B: The FILEGROWTH property can only be specified for operating-system files, i.e., primary or secondary data files. The FILEGROWTH property cannot be specified for a filegroup.
C: SQL Server 2000 allows filegroups to be marked as read-only. A filegroup marked read-only cannot be modified. Any user-defined filegroup, i.e., SECONDARY filegroup can be marked as read-only. However, the PRIMARY filegroup cannot be marked as read-only as it contains the system objects and tables. Theses include the tempdb and deleted database tables.
转载请注明原文地址:https://kaotiyun.com/show/cuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
Writealettertoacompanydecliningajoboffer.Inyourletter,youshouldappreciatethejoboffer,andstateyourreason(s)
Supposeyouarethepersonnelmanagerofacompanyandyou’vedecidedtheapplicantnamedZhangWeiisthebestcandidateforth
BarackObamaspentmuchtimeonthecampaigntrailproposingadramaticvisiontochangenotonlytheUnitedStatesforthebett
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
NextmonthBritonswillhaveyetmoresmartphonestochoosefrom,whendevicesfromWiko,atwo-year-oldFrenchcompany,goons
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
随机试题
旅游活动是一项相对单一的审美活动。()
首先考虑的诊断是若为营养性缺铁性贫血,错误的治疗原则为
关于胸部标线的描述,错误的是
根据《泵站施工规范》SL234—1999,泵站施工中,机、泵座二期混凝土,应保证设计标准强度达到()以上,才能继续加载安装。
库存现金的清查采用()。
课程的过程模式的思想最初可以追溯到()
下列说法不正确的是()。
南朝寒人地位提高的主要表现是()。①寒人典掌机要②寒人执掌兵权③寒人出任地方典签④寒人出任地方中正官⑤寒人社会地位超过了士族
springcouplets
Thefrontmatterofabookconsistsofthetitle,subtitle,tableofcontents,andpreface.Butthe【C1】______ofreaderswhopay
最新回复
(
0
)