SQL Server 2008 Interview Questions

Leave a comment (1) Go to comments

Question 1 : Which query hint will force query to execute on single CPU?

  1. MAXDOP
  2. SINCPU
  3. CPU = 1
  4. CPU(1)

Question 2 : How many new collation were introduced in SQL Server 2008?

  1. 20
  2. 18
  3. 80
  4. 10

Question 3 : Which of the engine feature SSIS can take advantage of in SQL Server 2008?

  1. Merge Statement
  2. Multi Server Management
  3. Both a and b
  4. None of the above

Question 4 : What is the default size of the VARCHAR datatypes? (e.g. DECLARE @myChar CHAR)

  1. 10
  2. 20
  3. 30
  4. 40

Question 5 : Which of the following is new feature of SQL Server 2008 Reporting Services?

  1. Matrics Grid
  2. Report Rendering Architecture
  3. Scale-out Analysis
  4. None of the above

Question 6 : Data Tier Application is also known as -

  1. DAC
  2. DTA
  3. DT
  4. None of the above

Question 7 : TOP clause can be used with following statement?

  1. SELECT
  2. INSERT
  3. DELETE
  4. All of the above

Question 8 : How many columns a table can have if it contains SPARSE Columns?


  1. 30
  2. 3000
  3. 30000
  4. None of the above

Question 9 : Which catalogue view gives performance bottleneck?

  1. sys.tables
  2. sys.dm_os_wait_stats
  3. sys.perfmonitor_cat
  4. None of the above

Question 10 : What is the precision of TIME datatype inside SQL Server 2008?

  1. 1 nanosecond
  2. 10 nanosecond
  3. 100 nanoseconds
  4. 1000 nanoseconds

Question 11 : Which datatype allows to store more than 2GB?

  1. VARCHAR(MAX)
  2. NVARCHAR(2GB)
  3. Filestream
  4. All of the above

Question 12 : Which of these datatypes can be compressed inside SQL Server?

  1. FLOAT, MONEY, TIMESTAMP
  2. INT, DATE, TIME
  3. Both a and b
  4. None of the above

Question 13 :  Which version of the SQL Server supports ISO datetype?

  1. SQL Server 2000
  2. SQL Server 2005
  3. SQL Server 2008
  4. None of the above

Question 14 :  Which of the following syntax is invalid in SQL Server 2008 compatibility?

  1. SET @x += 2
  2. SET @x =* 2
  3. SET @x = 2
  4. SET @x = 2+2

Question 15 : Which of the following join hint cannot be specified with inner join?

  1. Loop
  2. Merge
  3. Hash
  4. All the above

Answers Key

Question Answer
1 MAXDOP
2 80
3 Merge
4 1
5 Report Rendering Architecture
6 DAC
7 Select
8 30,000
9 sys.dm_os_wait_stats
10 100 nanoseconds
11 Filestream
12 Both a and b
13 SQL Server 2005
14 SET @x += 2
15 Merge
EOF - SQL Server 2008 Interview Questions, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

1 Comments.

  1. A very good site for SQL server interview questions organised by topic. If you feel you need to brush up interview questions related to specific topics, this website will be of great use. God bless the person who has contributed to this site. Very useful.

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.