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 1453

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

ADITI,

1036

How efficient you are in oracle and SQL server?

CGI,

1086

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

Tech Mahindra,

991

What do you understand by SQL*Net?

Tech Mahindra,

956

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

IBM,

1078

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

IBM,

933

When to use Inner join & when to use subquery?

IBM,

1079

how many type of indexing in database?

IBM,

934

Difference between rowid and rownum in SQL?

Virtusa,

1 1752

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

Tavant Technologies, Virtusa,

1 2597

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

Amazon,

879

what is the difference between Delete and Truncate command in SQL

BirlaSoft,

1084

What Is Rdbms?

Accenture,

1082

How can you tell if a database object is invalid?

MCN Solutions,

1013

Un-Answered Questions { SQL Server }

What are “lock” hints?

998

What are the advantages of having an index on the sql server?

872

Explain some stored procedure creating best practices or guidelines?

869

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

942

Do you know nested transaction?

904

Can you please explain the difference between function and stored procedure?

958

How to create database with physical files specified in ms sql server?

951

How do you know if sql server is running on your local system?

974

Can you index views?

851

What is self join in sql server joins?

961

Can we install sql server 2016 on windows 7?

1071

What is index fragmentation in ms sql server?

1022

How to use copy and concatenate commands in SQL?

1063

Explain log shipping and mention its advantages.

988

what is normalization? : Sql server database administration

1019

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