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
Explain what are the authentication modes in sql server?
Do you know the different ddl commands in sql?
Is truncate autocommit?
What does truncate do?
Do you think BCNF is better than 2NF & 3NF? Why?
What is create command?
When you should use a low fill factor?
What is check constraint in sql server?
Explain what are the basic functions for master, msdb, model, tempdb databases?
what kind of lan types do you know? : Sql server database administration
What is bcp? When does it used?
Can you explain what is indexed view? How to create it?
What is the command used to check locks in microsoft sql server?
Explain the difference between cross join and full outer join?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
