SQL Server Interview Questions
Questions Answers Views Company eMail

What is the difference between coalesce() & isnull()?

505

What is the difference between local and global temporary tables?

555

What is bcp? When does it use?

489

What is the osql utility?

510

Explain the steps needed to create a scheduled job?

500

What are the types of joins in sql?

535

What are orphan records?

515

What have included columns when we talk about sql server indexing?

550

List all the types of user-defined functions?

496

Why use “nolock” in sql server?

533

Explain primary key in sql server?

545

What is the filtered index?

526

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

473

How will you go about resolving deadlocks?

510

What is the difference between osql and query analyzer?

522


Un-Answered Questions { SQL Server }

What is a cursor, index in sql?

539


what is hash nonclustered index

510


Which autogrowth database setting is good?

588


what are the new features in SSRS?

100


what authentication modes does sql server support? : Sql server database administration

489






which backup strategy you are following at ur company

1698


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

572


Can we write a distributed query and get some data which is located on other server and oracle database?

727


What is an example of a foreign key?

483


What is 4nf in normalization form?

532


Define left outer join in sql server joins?

528


Do you know what is user defined datatypes and when you should go for them?

474


Explain following error properties?

530


What are the differences between DDL, DML and DCL in SQL?

731


What are built in functions?

546