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

Why use “in” clause in sql server?

1117

Write an sql query to find the names of employees start with ‘a’?

1 1818

When would you use it?

1039

What is the difference between ‘having’ clause and a ‘where’ clause?

1083

How to add code to the existing article (using improve article)?

1162

Explain about link server in sql server?

1104

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 2101

What is the difference between delete and truncate statements?

1124

Explain foreign key in sql server?

1070

What is a field in a table?

1069

What are a scheduled jobs or what is a scheduled tasks?

944

List the different types of joins?

1055

What is the difference between char and varchar2 datatype in sql?

1113

What are entities and relationships?

1020

What is the difference between dropping a database and taking a database offline?

1216

Un-Answered Questions { SQL Server }

How to update multiple rows with one update statement in ms sql server?

1259

What is the rdl file?

141

Explain about the command-line tool SQLCMD?

1140

explain different levels of normalization? : Sql server database administration

1048

What is RAID? What are the different types of RAID configurations?

1178

How to test odbc dsn connection settings?

1078

What do you mean by tablesample?

1123

What is the difference between dbcc indexdefrag and dbcc reindex?

1030

Explain what is row_number function?

1080

How to call stored procedure using http soap?

1123

1 01 101 01010

2097

How do I start sql server?

1026

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1071

What is a primary key?

996

role of sql sever 2005 in database rather than any other database

1984

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