sql data types interview questions and answers - skillgun
Which of the following datatypes are not supported in SQL Server 2005 ?
long data type is not supported in SQL Server.
What is the size of smallint in SQL Server?
What is the size of tinyint in SQL Server?
What is the size of bigint in SQL Server?
What is the size of int in SQL Server?
How many characters can be stored using char data type in SQL Server?
How many total characters are allowed in varchar data type ?
varchar data type is almost equivalent to a string data type in traditional programming languages. In SQL for storing data in a varchar type or char type or any other equivalent string types we must use single quotations.
What is the use of bit datatype in SQL Server?
bit data type can able to store either 0 or 1.
bit data type can be used for storing true or false.
Both the options are correct.
Which of the following datatypes are not supported in SQL Server?
1.float 2.real 3.double 4.decimal
All are not supported.
All are supported.
Only double is not supported.
Only float and decimal is not supported.
test the below given sql code you will get error in double declaration .
create table tb1
c1 decimal ,
What is the difference between char and varchar data types ?
char data type supports max 8000 characters and varchar data type supports 231 characters .
char data type is fixed size and varchar data type is varying size data type.
both are same char is sql data type and varchar is SQL Server specific data type.
None of the above.
What is the difference between varchar and nvarchar data types?
varchar is a varying size data type where as nvarchar is a fixed size data type.
varchar and nvarchar both are same. But only difference is nvarchar can store international characters like hindi, chinese, spanish etc..
varchar can store maximum 800 characters but nvarchar can store infinite characters .
What is the range of smalldatetime in SQL Server?
January 1, 0001, through June 6, 2079
January 1, 1900, through June 6, 2079
January 1, 1900, through december 31, 9999
What is the range of datetime in SQL Server?
from January 1, 0001 to June 6, 2079
from january 1, 1753 to December31,9999
none of the above.
what is the range of datetime2 datatype ?
from 1st January 0001 to June 6, 2079
from January 1st 0001 to December31,9999
from january 1st 1900 till June 6 2079
Which of the following datatypes are new datatypes in SQL Server 2008 ?
1.datetime 2.datetime2 3.date 4.time
all are new datatypes.
date and time are new datatypes.
datetime2, date and time datatypes are new datatypes.
None of the data types are new datatypes.
datetime2, date and time data types are new datatypes.
What is the use of money datatype in SQL Server?
money data type can store floating point values without any special characters.
money data type can store only currency symbols but not numbers.
money data type can store currency symbols as well as floating point numbers.
What is the size of varchar (max) data type in SQL Server?
What is the size of money datatype in SQL Server?
What is the size of smallmoney data type in SQL Server?
What is the size of money and smallmoney data types in SQL Server?
2 bytes and 4 bytes.
4 bytes and 2bytes.
8bytes and 4 bytes.
16bytes and 8 bytes.
Back To Top