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

Is Sql non procedural query language?

Verifone,

1 1553

Write a SQL command to insert and update only a particular field?

ADITI,

1106

How efficient you are in oracle and SQL server?

CGI,

1148

What are the steps to follow to configure SQL*Net?

Tech Mahindra,

1031

What do you understand by SQL*Net?

Tech Mahindra,

1022

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

IBM,

1135

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

IBM,

988

When to use Inner join & when to use subquery?

IBM,

1155

how many type of indexing in database?

IBM,

975

Difference between rowid and rownum in SQL?

Virtusa,

1 1850

How can you swap values between two rows in a table using single- SQL statement?

Tavant Technologies, Virtusa,

1 2694

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

Amazon,

919

what is the difference between Delete and Truncate command in SQL

BirlaSoft,

1146

What Is Rdbms?

Accenture,

1150

How can you tell if a database object is invalid?

MCN Solutions,

1072

Un-Answered Questions { SQL Server }

Explain the advantages of merge replication?

947

How to perform key word search in tables?

957

What is the most common trace flags used with sql server?

1040

What are the types of lock supported by ?

1042

What are the different authentication modes in sql server?

1107

What is a covered index?

933

What is SQL Server?

1204

What are scheduled tasks in sql server?

1076

How to store and query spatial data?

985

Explain the difference between cross join and full outer join?

977

Where is my database stored on the hard disk in ms sql server?

1057

Distinguish between nested subquery and correlated subquery?

1038

Explain the collation?

1103

Define tempdb database?

991

how to take backup bcp out for a column in table in sql server?

2102

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