SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What is the diff between Dynamic queries and static queries

CGG, ICS Integrated Computer Solutions,

1 10909

Hi..here i would like to know the Backup and Restore models?

HCL,

2 5061

wht's the differece between sqlserver05 and sqlserver2000

3 5782

how to find number of columns in a table in sql server 2000 and 2005 also

HCL, Virtusa,

7 14328

what is meant by deafult in sql server?

2 5740

how to find number of columns in a table in sql server 2000 and 2005 also

Virtusa,

16 30511

any one can explain Self mapping Delegation Remote Credentials

1 5329

What is the difference between views and stored procedures? Can we have input parameters for views?

6 19505

Which databases are part of SQL server default installation? Explain the usage of each?

Accenture,

2 7786

What all db objects can be found in MSDB database of a SQL Server instance?

Accenture,

2 8112

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

Accenture,

3 12402

What is Query Execution Plan? How does it help optimize or tune a database driven application?

Accenture, Polaris,

2 10229

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2072

how to delete duplicate rows from table

CSC,

9 14044

What is the diff between Static Queries and Dynamic queries give me some examples

CSC,

2 10845

Un-Answered Questions { SQL Server }

How do you debug a procedure in sql server?

934

How to use "begin ... End" statement structures in ms sql server?

1033

What kind of problems occurs if we do not implement proper locking strategy?

1395

What is the sql case statement used for?

1090

Explain the types of indexes.

1205

What is RMS migrations?

2128

What are trace flags?

1026

What is the use of @@spid?

995

Can a table have 2 primary keys?

979

What is meant by Active-Passive and Active-Active clustering setup?

1165

What do you understand by replication in sql server? Mention the different types of replication in sql server.

939

Why I can not enter 0.001 second in date and time literals in ms sql server?

1054

Can you pass expressions to function parameters?

1099

How do I connect to sql server database?

1006

What is the difference between grant and with grant while giving permissions to the user?

953

For More Un-Answered { SQL Server } Questions Click Here