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 1630

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

ADITI,

1183

How efficient you are in oracle and SQL server?

CGI,

1214

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

Tech Mahindra,

1069

What do you understand by SQL*Net?

Tech Mahindra,

1076

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

IBM,

1181

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

IBM,

1045

When to use Inner join & when to use subquery?

IBM,

1231

how many type of indexing in database?

IBM,

1016

Difference between rowid and rownum in SQL?

Virtusa,

1 1949

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

Tavant Technologies, Virtusa,

1 2772

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

Amazon,

988

what is the difference between Delete and Truncate command in SQL

BirlaSoft,

1194

What Is Rdbms?

Accenture,

1229

How can you tell if a database object is invalid?

MCN Solutions,

1111

Un-Answered Questions { SQL Server }

What is table-valued sub query?

1024

New concepts of sql server 2005 use in your project.

2399

What is the difference between migration and upgradation in sql server?

1132

What are different types of data sources?

1078

What is truncate table?

996

How can you append an identity column to a temporary table?

1028

Relational calculus is what type of language?

1090

Define right outer join in sql server joins?

1104

Describe in brief system database.

1062

Explain relational data?

963

What are the restrictions that views have to follow? : SQL Server Architecture

1056

Explain about local stored procedure?

1025

What are the disadvantages of merge replication?

1507

What are different types of table joins?

1050

Explain nested join?

1028

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