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 1185

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

ADITI,

817

How efficient you are in oracle and SQL server?

CGI,

823

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

Tech Mahindra,

798

What do you understand by SQL*Net?

Tech Mahindra,

797

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

IBM,

794

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

IBM,

771

When to use Inner join & when to use subquery?

IBM,

777

how many type of indexing in database?

IBM,

754

Difference between rowid and rownum in SQL?

Virtusa,

1 1366

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

Tavant Technologies, Virtusa,

1 2230

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

Amazon,

723

what is the difference between Delete and Truncate command in SQL

BirlaSoft,

839

What Is Rdbms?

Accenture,

852

How can you tell if a database object is invalid?

MCN Solutions,

807

Un-Answered Questions { SQL Server }

How to get a list of columns in a view using the "sp_help" stored procedure?

817

What is single-user mode?

717

Does order by actually change the order of the data in the tables or does it just change the output?

935

What is the difference between indexing and hashing?

782

What is user-defined function?

747

What is sql view?

759

Can you explain what is indexed view? How to create it?

726

What stored by the msdb?

791

What is a unique key constraint?

751

How to download and install microsoft sql server management studio express?

775

How to set database to be single_user in ms sql server?

802

Working with TLogs

1614

What is the difference between dataadapter and datareader?

754

How to convert numeric values to integers in ms sql server?

728

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

872

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