2. 计算机
  3. 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

admin2009-05-19  43
问题 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://www.kaotiyun.com/show/cuhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)