Interested to Buy Any Domain ? << Click Here >> for more details...
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 the new security features added in sql server 2014? : sql server security
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Explain the difference between HTTP and HTTPS in database?
How to how to convert numeric expression data types using the convert() function??
What is the difference between nvl and nvl2?
How to execute a sql statement using mssql_query()?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
How to delete an existing database user?
How can a user-defined datatype be created?
What is the contrast between sql and mysql?
How can you set the threshold at which sql server will generate keysets asynchronously?
What is dml command?
Is BCNF better than 2NF & 3NF? Why?
What is default constraint?
