Basic and Advance databases programming :: SQL server 2008 Job Interview Questions and Answers

SQL server 2008 frequently Asked Questions by expert members with experience in SQL server 2008. These interview questions and answers on SQL server 2008 will help you strengthen your technical skills, prepare for the interviews and quickly revise the concepts. So get preparation for the SQL server 2008 job interview

1 Do you know PowerShell included in SQL Server 2008?
2 What is IntelliSense in sql server 2008?
3 Explain filtered indexes in sql server 2008?
4 Can you explain Table Value Parameters (TVP) in sql server 2008?
5 Do you know Plan freezing in sql server 2008?
6 Do you know Resource governor in sql server 2008?
7 What is Compression - row-level and page-level compression in sql server 2008?
8 Explain benefits of SQL Server 2008 introduces automatic auditing?
9 Explain Compound Operators in sql server 2008?
10 Tell me inline variable assignment in sql server 2008 with an example?
11 What is Declarative Management Framework (DMF) in SQL Server 2008?
12 Do you know Encryption of entire databases without the need for application changes in sql server 2008?
13 What is External Key Management in sql server 2008?
14 Do you know Enhanced database mirroring in sql server 2008?
15 What is Hot Add CPU in sql server 2008?
16 What is Extended events in sql server 2008?
17 What is sql server 2008 backup compression?
18 What is filestream storage of sql server 2008?
19 What is policy based administration feature of SQL Server 2008?
20 Explain Sparse Columns of sql server 2008?
21 Explain TIME data type, datetime2, datetimeoffset data type in sql server 2008?
22 Explain how to store and query Spatial Data?
23 What are spatial data types - geometry and geography in sql server 2008?
24 What is MERGE in sql server 2008?
25 What is Change Data Capture (CDC) feature in sql server 2008?
26 What is Entity Data Services in sql server 2008, Explain Line Of Business (LOB) framework and Entity Query Language (eSQL)?