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 guidelines should be followed to help minimize deadlocks?
How column data types are determined in a view?
List the different normalization forms?
What is the significance of null value and why should we avoid permitting null values?
What is a not null constraint?
Does a full backup include transaction log?
Explain what is row_number function?
What is dbcc? Give few examples.
How to override dml statements with triggers?
What is difference between standardization and normalization?
How do you run a trace?
What is the use of set nocount on/off statement?
What is database replication?
How to download and install the scaled-down database adventureworkslt?
Tell me about normalization in DBMS.
