Answer Posted / vikram
Clustered index hold data at the leaf node.
non clustered hold data location (pointer) at the leaf node.
when we create primary key Clustered index automatically
created
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is normalization 1nf 2nf 3nf?
What is the difference between functions and scalar functions?
What type of Index will get created after executing the above statement?
What is data mart? : sql server analysis services, ssas
How to use user defined functions in expressions?
What is a deadlock and what is a live lock?
How do you delete a trigger?
Explain nested trigger in sql?
How can you stop stored procedures from recompiling?
What are subqueries in sql server?
What is molap and its advantage? : sql server analysis services, ssas
What happens if you are trying to access a schema not owned by you?
Explain the various types of concurrency problem?
What will be the maximum number of index per table?
What extended events?
