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 10830

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

HCL,

2 4963

wht's the differece between sqlserver05 and sqlserver2000

3 5675

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

HCL, Virtusa,

7 14136

what is meant by deafult in sql server?

2 5634

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

Virtusa,

16 30048

any one can explain Self mapping Delegation Remote Credentials

1 5266

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

6 19297

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

Accenture,

2 7702

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

Accenture,

2 8020

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 12287

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

Accenture, Polaris,

2 10124

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?

2033

how to delete duplicate rows from table

CSC,

9 13793

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

CSC,

2 10742

Un-Answered Questions { SQL Server }

How extra digits are handled with numeric data type literals?

921

How to delete existing rows in a table?

1086

How can you check the version of sql server?

1052

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1061

What are filegroups in sql server?

1020

What is partitioned view?

862

What is best institute to Learn DotNET And SQL in chennai?

2124

What is sql language?

1043

How to use go command in "sqlcmd"?

1135

How to see the event list of an existing trigger using sys.trigger_events?

1039

What will be the maximum number of indexes per table?

919

can we have a nested transaction? : Sql server database administration

1005

Do you know the different ddl commands in sql?

1006

How to grant a permission in ms sql server using "grant execute" statements?

1034

What are user-defined functions (udfs) in sql server?

943

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