SQL Server Interview Questions
Questions Answers Views Company eMail

What is the difference between left and right outer join?

618

Explain the commands in sql server?

627

Write an sql query for deleting duplicate rows?

636

What is difference between clustered index and non clustered index?

712

Write query to return all rows sql?

692

What is difference between foreign key and unique key?

653

State the difference between union and union all?

605

What do you understand by recursive stored procedures?

656

What are a database and a data warehouse?

653

What do you understand by the denormalisation?

637

What is an index in sql?

640

Name few of the dcl commands in sql?

636

What is join and name different type of joins?

666

Is there any difference between the primary key and unique key?

668

Name the different type of indexes in sql?

634


Un-Answered Questions { SQL Server }

How many types of stored procedures are there in sql server?

648


What is sql server used for?

631


How to rebuild master databse?

759


What specific conditions database should meet, before you can bulk copy data into it using bcp?

636


how many clustered indexes can be created on a table? : Sql server database administration

658






What does top operator do?

652


What is isnull() operator?

681


How to find table changes in sql server?

752


Why we need to use secondry database file? though, we can do same work using primary database file also.

5963


What are the different types of data sources in ssrs?

155


how you can list all the tables in a database?

630


What is the difference between createstatement and preparedstatement?

583


How can sql server instances be hidden? : sql server security

676


How to transfer an existing table from one schema to another schema in ms sql server?

592


How to make remote connection in database?

676