1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

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

 525

What is the difference between local and global temporary tables?

 575

What is bcp? When does it use?

 505

What is the osql utility?

 531

Explain the steps needed to create a scheduled job?

 518

What are the types of joins in sql?

 551

What are orphan records?

 542

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

 565

List all the types of user-defined functions?

 514

Why use “nolock” in sql server?

 550

Explain primary key in sql server?

 561

What is the filtered index?

 551

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

 487

How will you go about resolving deadlocks?

 536

What is the difference between osql and query analyzer?

 539

Un-Answered Questions { SQL Server }

How will you hide an attribute? : sql server analysis services, ssas

511

How to create a testing table with test data in ms sql server?

546

How to send email from database?

568

What do I need to start working with sql studio? : sql server management studio

581

What is an entity-relationship diagram (erd)?

579




what is the difference between a primary key and a unique key? : Sql server database administration

523

What are the types of normalization?

542

How to get the definition of a view out of the sql server?

493

How do you rename a table in sql server?

486

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

546

Do you know what are acid properties?

561

How do I open port 1433?

511

What is not null constraint?

611

What is a covering index?

521

How to create a new login name in ms sql server?

542

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