Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vinoth
Yes,Its Possible.Eg( Select Eid,Did,Ename from Employee)
.Create table with primary key column(Eid).This time
Primary key column ACT As a CLUSTERDE INDEX for Default.
Suppose User directly create Did COLUMN with CLUSTEREDINDEX
at this time Primary key column act as a NONCLUSTEREDINDEX.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the aggregate and scalar functions?
How do database indexes work?
Please explain what is “asynchronous” communication in sql server service broker?
List the advantages of using stored procedures?
Write a code to select distinct records without using the DISTINCT keyword.
What is store procedure? How do they work? When do you use?
What is a dataset and what are the different types of datasets?
Are null values the same as that of zero or a blank space?
Explain the microsoft sql server delete command? : SQL Server Architecture
Explain use of expression builder.
What is cursors? And what are the different types of cursor?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What is the difference between online clustering and Offline clustering?
What are the different Topologies in which Replication can be configured?
Can an automatic recovery be initiated by a user?
