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 10914

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

HCL,

2 5087

wht's the differece between sqlserver05 and sqlserver2000

3 5792

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

HCL, Virtusa,

7 14347

what is meant by deafult in sql server?

2 5753

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

Virtusa,

16 30573

any one can explain Self mapping Delegation Remote Credentials

1 5333

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

6 19522

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

Accenture,

2 7795

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

Accenture,

2 8120

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 12415

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

Accenture, Polaris,

2 10236

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?

2076

how to delete duplicate rows from table

CSC,

9 14062

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

CSC,

2 10860

Un-Answered Questions { SQL Server }

Is sql server free?

915

How to list all user names in a database?

1056

Mention the different types of replication in sql server.

1024

How to create a local temporary stored procedure?

998

What are the disadvantages of primary key and foreign key in SQL?

1116

How to create indexed view?

1045

What is acid properties?

1097

What is the use of keyword with encryption.

1028

Explain indexed views?

981

Explain transaction server consistency?

973

What is database replication?

1140

What is conditional split?

1070

Does group by or order by come first?

958

Explain about extended stored procedure?

938

Please explain what is “asynchronous” communication in sql server service broker?

935

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