What is a filegroup? Name the two main types of filegroups.

What will be an ideal response?


A filegroup is a collection of one or more physical data files within a SQL Server database. The two main types of filegroups are primary filegroup and user-defined filegroup.

Computer Science & Information Technology

You might also like to view...

Multi-dimensional arrays that contain arrays of different lengths in any one dimension are called _________________.

a) ragged arrays b) static arrays c) two-dimensional arrays d) constant arrays e) overloaded arrays

Computer Science & Information Technology

A witness for the prosecution is introducing a tape recording that clearly implicates the person on trial in a crime. While the information is factual and accurate, and there is no doubt about where the recording came from, it is hightly prejudicial to the suspect. On what grounds can the counsel for the defense get this evidence removed?

a. The evidence is not authentic since it is prejudicial in nature. b. The tape recording is declared inadmissible since it is hearsay. c. Due to its prejudicial nature, the evidence is determined by the judge to be incompetent. d. The tape recording falls under the classification of privileged information and is thereby not admissible.

Computer Science & Information Technology

When you remove all the tiles in a group, Windows also deletes the group ____________________.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

What utility, as a CentOS system administrator, are you most likely to use to monitor process activity in real time?

A. System Monitor B. Task Manager C. Resource Monitor D. Process Manager

Computer Science & Information Technology