SQLConfiguration SQLConfiguration


Table Column Attributes  «Prev  Next»

Datatypes, Length, Precision, Scale, and Nulls - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 

1. What is the relationship between the amount of disk space required between a unicode and non-unicode datatype?
Please select the best answer.
  A. Answer: Unicode takes twice as much space as non-unicode.
  B. Non-unicode takes twice as much space as unicode.
  C. Unicode takes four times as much space as non-unicode.
  D. Non-unicode takes four times as much space as unicode.

2. For column EmployeeID, you try to specify a datatype of Int with a length of 4, but you receive an error. Other columns do not give you an error. What is the possible reason for this error?
Please select the best answer.
  A. EmployeeID is an invalid column name.
  B. EmployeeIDs cannot have an Int datatype.
  C. You do not have correct permissions on the table.
  D. You cannot specify a length with an Int datatype.

3. Which of the following is equivalent to null?
Please select the best answer.
  A. 0
  B. An empty string
  C. The absence of a value
  D. The word “NULL”

Correct answers:

Your Score: 0