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 11017

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

HCL,

2 5188

wht's the differece between sqlserver05 and sqlserver2000

3 5923

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

HCL, Virtusa,

7 14580

what is meant by deafult in sql server?

2 5875

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

Virtusa,

16 31121

any one can explain Self mapping Delegation Remote Credentials

1 5409

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

6 19714

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

Accenture,

2 7900

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

Accenture,

2 8242

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 12593

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

Accenture, Polaris,

2 10367

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?

2129

how to delete duplicate rows from table

CSC,

9 14355

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

CSC,

2 10991

Un-Answered Questions { SQL Server }

What are the steps you will take to improve the performance of a poor performing query?

1026

What are the differences between local and global temporary tables?

1141

What is the use of sql profiler in sql server 2012?

947

How to read data in a table with "select" statements?

1030

What are the steps to process a single select statement?

994

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2414

Can you explain what is the use of custom fields in report?

1106

In which files does sql server actually store data?

955

What is isolation levels?

1088

What are the restrictions while creating batches in sql server?

1122

Do you know concepts and capabilities of sql server?

1117

What methods do you follow to protect from sql injection attack?

1075

How can you manage sql azure security?

105

what is blocking? : Sql server database administration

1092

Describe the left outer join & right outer join. : sql server database administration

1042

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