SQL Server Interview Questions
Questions Answers Views Company eMail

Can we do dml on views?

526

Can you index views?

478

Does view occupy space?

485

What is difference between materialized view and view?

458

How do you create a clustered index?

495

How do you drop an index?

472

How does clustered and non clustered index work?

487

What are the types of indexing?

562

What is an index in a database?

511

What is the need for indexing?

478

What are the lambda triggers?

458

Can you leave a union at any time?

499

Does union all remove duplicates?

582

What does it mean to be in union?

487

Why union all is faster than union?

478


Un-Answered Questions { SQL Server }

List the different index configurations possible for a table?

481


In which sql server version report builder introduced?

103


I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

641


What are sql servers used for?

479


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

517






Why olap is used?

540


Explain identity in sql server?

536


Can I use sql azure as a backup with log shipping or database mirroring?

136


how can you attach more than 20 ldf files in sql server

1541


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

574


What do you mean by subquery?

558


What are views used for?

591


Explain rdbms?

579


What does it mean if @@cursor_row returns a negative number?

546


What is spid in sql server profiler?

500