Buy Questpond's video subscriptions on
huge discount
.
Online: 3421
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 ...
As part of a new enterprise project, you're designing a new table to store financial transactions. This table could eventually store millions of rows and so storage space is very important. One of the columns in the table will store either a 1 or 0 value. Which data type would be most appropriate?
Posted by
Bandi
on 7/30/2014 | Category:
Sql Server Interview questions
| Views: 2259 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
bit
tinyint
numeric
float
All Above
bit data type is useful to store TRUE/FALSE ( flag type of data) and consumes less storage
Show Correct Answer
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
DML triggers are used to enforce business rules wh ...
Next > :
A DML trigger is an action programmed to execute w ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
A DML trigger is an action programmed to execute when a data manipulat ...
Which of the following would be a correct way to call the stored proce ...
Which of the following conversions is NOT allowed either implicitly or ...
Which of the following is FALSE regarding FOREIGN KEYS in SQL Server 2 ...
You're designing a new table that will hold information about medi ...
The !> operator is a comparison operator that compares two expressi ...
You're designing a new query that will eventually be used by a new ...
You're designing a new SQL Server 2012 query for the HR department ...
Latest Interview Questions
By default,Asp.Net stores SessionIDs in which mechanism?
In order to prevent a browser from caching a page which of the stateme ...
We have defined one page_load event in aspx page and the same is defin ...
How to display a computer code in html
What is the FEATURES or PURPOSE of Raise Error?
Can a Clustered Index ALSO be a Unique Index?
Which statement is used for defining a Cursor?
Which Process is used for Maintaining State Server Session in Asp.Net ...
More ...