Select chapter



Basics (2.papers)
Data Types (2.papers)
Table-designing (1.papers)
Queries-Commands (3.papers)
String functions (2.papers)
Subqueries (1.papers)
Joins (1.papers)
Constraints (1.papers)
Triggers (1.papers)
Hide

Sponsored Links


  

sql interview questions and answers

Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
4
What is the size of bigint in SQL Server?
  1. 2 byte
  2.  6 bytes
  3. 4bytes
  4. 8 bytes
Show Answer
Share Facebook gmail Twitter
5
What is the size of int in SQL Server?
  1. 1 byte
  2. 2 bytes
  3. 4 bytes
  4. 8 bytes
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
8
What is the use of bit datatype in SQL Server?
  1. bit data type can able to store either 0 or 1.
  2. bit data type can be used for storing true or false.
  3. Both the options are correct.
Show Answer
Share Facebook gmail Twitter
9
Which of the following datatypes are not supported in SQL Server?
1.float 2.real 3.double 4.decimal
  1. All are not supported.
  2. All are supported.
  3. Only double is not supported.
  4. Only float and decimal is not supported.
Show Answer
Share Facebook gmail Twitter
10
What is the difference between char and varchar data types ?
  1. char data type  supports max 8000 characters and varchar data type supports 231 characters .
  2. char data type is fixed size and varchar data type is varying size data type.
  3. both are same char is sql data type and varchar is SQL Server specific data type.
  4. None of the above.
Show Answer
Share Facebook gmail Twitter
11
What is the difference between varchar and nvarchar data types?
  1. varchar is a varying size data type where as nvarchar is a fixed size data type.
  2. varchar and nvarchar both are same. But only difference is nvarchar can store international characters like hindi, chinese, spanish etc.. 
  3. varchar can store maximum 800 characters but nvarchar can store infinite characters .
  4. None of the above.
Show Answer
Share Facebook gmail Twitter
12
What is the range of smalldatetime in SQL Server?
  1. January 1, 0001, through June 6, 2079
  2. January 1, 1900, through June 6, 2079
  3. January 1, 1900, through december 31, 9999
  4. None of the above.
Show Answer
Share Facebook gmail Twitter
13
What is the range of datetime in SQL Server?
  1. from January 1, 0001 to June 6, 2079
  2. from january 1, 1753 to December31,9999
  3. January 1, 1900, through december 31, 9999
  4. none of the above.
Show Answer
Share Facebook gmail Twitter
14
what is the range of datetime2 datatype ?
  1. from 1st January 0001 to June 6, 2079
  2. from January 1st 0001 to December31,9999
  3. from january 1st 1900 till June 6 2079
  4. none of the above.
Show Answer
Share Facebook gmail Twitter
15
Which of the following datatypes are new datatypes in SQL Server 2008 ?
1.datetime   2.datetime2    3.date    4.time
  1. all are new datatypes.
  2. date and time are new datatypes.
  3. datetime2, date and time datatypes are new datatypes.
  4. None of the data types are new datatypes.
Show Answer
Share Facebook gmail Twitter
16
What is the use of money datatype in SQL Server?
  1. money data type can store floating point values without any special characters.
  2. money data type can store only currency symbols but not numbers.
  3. money data type can store currency symbols as well as floating point numbers.
  4. None of the above.
Show Answer
Share Facebook gmail Twitter
17
What is the size of varchar (max) data type in SQL Server?
  1. 8000bytes
  2. 2<sup>31</sup> bytes
  3. 8 bytes
  4. Unlimited 
Show Answer
Share Facebook gmail Twitter
18
What is the size of money datatype in SQL Server?
  1. 2 bytes.
  2. 4 bytes.
  3. 6 bytes.
  4. 8 bytes.
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
20
What is the size of money and smallmoney data types in SQL Server?
  1. 2 bytes and 4 bytes.
  2. 4 bytes and 2bytes.
  3. 8bytes and 4 bytes.
  4. 16bytes and 8 bytes.
Show Answer
Share Facebook gmail Twitter
Read more papers :