does physical index sort data

Question Posted / guest

does physical index sort data..

Answer / dharmesh tandel

yes

Is This Answer Correct ?

4 Yes

0 No

More SQL Server Interview Questions

What is the difference between cross join and Full outer join?

what do you understand by change data capture?

what is blocking? : Sql server database administration

How you can minimize the deadlock situation?

What is the difference between constraints and triggers?

What does this statement do @@rowcount?

What are magic tables in sql server?

Explain primary key and foreign key constraints?

What are the different methods available under sqlcommand class to access the data?

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

Explain where clause?

We need to perform what steps in the following order to work with a cursor?

For more SQL Server Interview Questions Click Here