SQL Server Interview Questions
Questions Answers Views Company eMail

What is identity?

542

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

558

What are synonyms?

518

What is the default order of an order by clause?

573

What are the authentication modes in sql server? How can it be changed?

587

What is acid properties?

578

Can we perform backup restore operation on tempdb?

556

What is pivot and unpivot?

630

What is dirty page?

558

What is extent? Types of extents?

583

What is the default value of an integer data type in sql server 2005?

577

What are the different editions available in sql server 2000?

582

Can a synonym name of a table be used instead of a table name in a select statement?

570

How do I determine how many instances of sql server are installed on a computer?

527

What does the on update no action do?

582


Un-Answered Questions { SQL Server }

Mention the differences between having and where clause.

546


How to link tables in sql server?

466


Define synonym?

724


What are group functions in query statements in ms sql server?

543


Explain how does the report manager work in ssrs?

489






Can we hide the definition of a stored procedure from a use?

644


What are the different normalization forms?

604


What is collation sensitivity?

541


How to declare a cursor with "declare ... Cursor" in ms sql server?

559


Tell me what is fill factor?

547


What are the types of user defined functions in sql server?

490


Can we use custom code in ssrs?

575


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1972


What stored by the master?

537


Explain how dts is used to extract, transform and consolidate data?

568