Workshop

The following workshop is composed of a series of quiz questions and practical exercises. The quiz questions are designed to test your overall understanding of the current material. The practical exercises are intended to afford you the opportunity to apply the concepts discussed during the current hour, as well as build upon the knowledge acquired in previous hours of study. Please take time to complete the quiz questions and exercises before continuing. You may refer to Appendix C, "Answers to Quizzes and Exercises," for answers.

Quiz

1:True or false: An individual's Social Security number can be any of the following data types: constant-length character, varying-length character, numeric.
2:True or false: The scale of a numeric value is the total length allowed for values.
3:Do all implementations use the same data types?
4:What are the precision and scale of the following?

DECIMAL(4,2)

DECIMAL(10,2)

DECIMAL(14,1)

5:Which numbers could be inserted into a column whose data type is DECIMAL(4,1)?

  1. 16.2

  2. 116.2

  3. 16.21

  4. 1116.2

  5. 1116.21

Exercises

1:Take the following column titles, assign them to a data type, and decide on the proper length.

  1. ssn

  2. state

  3. city

  4. phone_number

  5. zip

  6. last_name

  7. first_name

  8. middle_name

  9. salary

  10. hourly_pay_rate

  11. date_hired

2:Take the same column titles and decide whether they should be NULL or NOT NULL, realizing that in some cases where a column would normally be NOT NULL, the column could be NULL or vice-versa, depending on the application.

  1. ssn

  2. state

  3. city

  4. phone_number

  5. zip

  6. last_name

  7. first_name

  8. middle_name

  9. salary

  10. hourly_pay_rate

  11. date_hired

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset