You are creating the ColorId column for a table named Colour. This column can not hold more than 200 colors.
You wanted to minimize the number of bytes consumed by the column when stored in the database. which data type you should use for this purpose ?

 Posted by Rajkatie on 12/31/2012 | Category: Sql Server Interview questions | Views: 5966 | Points: 40
Select from following answers:
  1. tinyint
  2. smallint
  3. int
  4. All Above

Show Correct Answer


Source: Measureup.com | | Alert Moderator 

Comments or Responses

Login to post response