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()?

 535

What is the difference between local and global temporary tables?

 592

What is bcp? When does it use?

 515

What is the osql utility?

 542

Explain the steps needed to create a scheduled job?

 525

What are the types of joins in sql?

 563

What are orphan records?

 552

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

 582

List all the types of user-defined functions?

 527

Why use “nolock” in sql server?

 565

Explain primary key in sql server?

 573

What is the filtered index?

 565

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

 498

How will you go about resolving deadlocks?

 560

What is the difference between osql and query analyzer?

 547

Un-Answered Questions { SQL Server }

What are the types of resultset?

538

what is a join and explain different types of joins? : Sql server database administration

542

What’s the distinction between dropping a info and taking a info offline?

600

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

480

Can foreign key be duplicate?

633




Please differentiate between a local and a global temporary table?

574

What are the two modes of authentication in sql server?

526

What is b tree index?

520

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

598

What is use of attributehierarchyenabled? : sql server analysis services, ssas

616

How do I edit a stored procedure in sql server?

514

Tell me what is the stuff and how does it differ from the replace function?

542

What is public role in sql server?

540

What is read uncmmited?

585

What is primary key and example?

508

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