Buy Questpond's video subscriptions on
huge discount
.
Online: 3739
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
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
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
tinyint
smallint
int
All Above
tinyint data type uses 1 bytes.
Smallint data type uses 2 bytes.
int data type uses 4 bytes.
Show Correct Answer
Source:
Measureup.com | |
Alert Moderator
Bookmark It
< Previous :
How many columns you can created with View?
Next > :
Which built-in function you can use for converting ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
Which built-in function you can use for converting string data type to ...
Your created a trigger report the number of rows in the Deleted table ...
Which of the following mathematical functions would you use to return ...
You write block of Transact-SQL code in try/catch block. You need to d ...
What is Web Storage?
You are developing a contact form which include information about the ...
In which order style sheet can applied in your web page ,when web desi ...
How many different way you can insert CSS into a web page ?
Latest Interview Questions
What is Abstract Class and interfaces?
Which namespace has the functions to manage the notification?
Which function can be used to consume a REST service from a HTML5 metr ...
What is API provided by WinRT to implement the open authentication ?
Which namespace has the function to implement the open authentication ...
To consume a c# library class in a HTML5 metro style application what ...
What is the way tofind how a HTML5 metro style application has been ac ...
Which object is used make a asynchronous call in a HTML5 metro style a ...
More ...