Q1. You have a requirement for a user-defined data type that must be in every new database you build. The easiest way to add the data type is:

  1. Use a SQL script that you run after creating each database.
  2. Add the data type to the Model system database.
  3. Add the data type to the Master system database.
  4. Add the data type to a user-defined database, and copy the user-defined database each time you build a new database.

Q2. To restore a database to a SQL Server 7.0 system, you will generally:

  1. Rebuild the Primary file or filegroup as it was originally built, then restore the database.
  2. Rebuild all the database files and filegroups in their original order, then restore the database.
  3. Rebuild all the devices and databases in their original order, then restore the database.
  4. Restore the database without rebuilding files.

Q3. You want to place a table and its indexes on different physical disks. You can do so by (select all correct answers):

  1. Creating a Primary file for the tables and a Secondary file for the indexes.
  2. Creating the tables in the Primary filegroup and creating a Secondary filegroup for the indexes.
  3. Placing the index on the same file as the transaction log, which is on a separate physical disk from the table.
  4. Creating a Secondary filegroup for this table and another Secondary filegroup for the indexes.

Q4. You need to store large image files in your database. The primary file for your database is on a disk that has only 100MB left, but you have a large disk array on which you could store images. You can use this disk array to store the images by (select the best answer):

  1. Storing the image files on the disk array with pointers to their file locations in the database.
  2. Making the disk array part of the Primary filegroup and letting the database expand onto it. The images are then stored in the Primary filegroup.
  3. Making the disk array a Secondary filegroup and designating it for text and image data with the TEXTIMAGE_ON filegroup option of the CREATE TABLE statement.
  4. Making the disk array a Secondary filegroup and placing the image data in a separate table on this filegroup.