SQL Server Interview Questions
Questions Answers Views Company eMail

Can we do dml on views?

748

Can you index views?

692

Does view occupy space?

715

What is difference between materialized view and view?

709

How do you create a clustered index?

736

How do you drop an index?

698

How does clustered and non clustered index work?

695

What are the types of indexing?

852

What is an index in a database?

723

What is the need for indexing?

683

What are the lambda triggers?

670

Can you leave a union at any time?

793

Does union all remove duplicates?

825

What does it mean to be in union?

689

Why union all is faster than union?

695


Un-Answered Questions { SQL Server }

Can coalesce return null?

751


What is a linked server in sql server?

781


Can you get second highest salary from the table?

740


Can we return Data from 4(more than 1) tables in stored procedure?

827


What are the types of resultset?

727


Does index slows down insert statements?

764


What is the recursive stored procedure in sql server?

732


What are different backups available in sql server?

775


Does table partitioning improve performance?

718


Explain about Joins?

781


How to delete an existing database user?

766


What is a ddl statement?

703


How many types of database relationship in sql server?

773


what is a deadlock? : Sql server database administration

704


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

949