SQL Server Database Creation   «Prev  Next»

SQL Server Column Attributes - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Victoria is defining a table. Her company has 75,000 employees. What datatype must she use to define the EmployeeID column to use the least amount of disk storage, but allow for the identity to be set for the column?
Please select the best answer.
  A. decimal
  B. text
  C. money
  D. int

2. Winston notices that an application using the database he designed is rounding some of the data that users type in. The users are entering numeric data. What is the most likely reason for this to happen?
Please select the best answer.
  A. The scale is set too low.
  B. The varchar datatype does not allow for enough characters to be typed.
  C. The datatype is a rowversion (timestamp) column.
  D. The datatype is a Uniqueidentifier.

3. You wish to create a table containing columns A, B, C, and D. You define columns B and D to allow NULL values. You define columns A and B as being the primary key. What will happen when you issue the Transact-SQL statement to create the table?
Please select the best answer.
  A. The table will be created as directed.
  B. The table will be created as directed, but without the primary key.
  C. The table will not be created and will result in error.
  D. The table will not be created unless all columns make up the primary key.

4. You have defined a column as a tinyint datatype. You have also set the identity flag on the column with a seed value of 1 and an increment value of 100. How many rows will you be able to insert into the table?
Please select the best answer.
  A. 100
  B. 1
  C. 3
  D. 255

5. What is significant about a GUID?
Please select the best answer.
  A. It takes the same amount of space as a char(5) datatype.
  B. It is designed to be unique across every database and every table in the world.
  C. It is guaranteed to be unique within your database only.
  D. It takes the same amount of space as an int datatype.

6. Harry notices that his tables are going to contain a lot of phone number data. He does not want to specify the datatypes, flags, and attributes for each of the phone numbers. What is the best way he can speed the process of defining the phone number columns?
Please select the best answer.
  A. He can create a user-defined datatype, called "phonenum."
  B. He can cut and paste these attributes for columns.
  C. There is nothing he can do. He must type in the datatypes, flags, and attributes for each column.
  D. He can use the number datatype.

7. What SQL Server function would you use to generate a new GUID value for a Uniqueidentifier column?
Please select the best answer.
  A. NEWGUID
  B. NEWID
  C. NEWIDENT
  D. NEWGLOBAL