Describe how filegroups are used in a database.

What will be an ideal response?


Data files are placed into filegroups for storage management. Each database must have a primary filegroup with at least one data file. However, a database may have more than one data file in a filegroup; the database is able to use all the data files concurrently, which can improve performance. If using more than one data file within a filegroup, the data files should all be the same size as the database attempts to fill them equally.

Computer Science & Information Technology

You might also like to view...

Which of the following statements is false?

a. A reference to an object is required to invoke an object’s methods. b. A primitive-type variable does not refer to an object. c. Reference-type instance variables are initialized by default to the value void. d. A primitive-type variable cannot be used to invoke a method.

Computer Science & Information Technology

As the height of the Detail section increases, the amount of data displayed in the report:

A) increases. B) decreases. C) stays the same. D) either A or B.

Computer Science & Information Technology

You can use the ____ link in the Mail Merge task pane to add an address to the letter in the location of the insertion point.

A. Address B. Location C. Address block D. Recipient

Computer Science & Information Technology

When using Ethernet, ControlNet, or Data Highway Plus, what are four pieces to the communications path?

What will be an ideal response?

Computer Science & Information Technology