1.can we set the more than 1 primary keys for a table?
2.please give me the difference between Cluster Index and
non-Clustered Index
3.can we use query like this "Select * from Table1,Table2;"
- 8 Answers
- 7725 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhusudan bowenpalli
1. No.
2.when create primary key on a table clustered index
automatically created.1 clustered index is possible for a
table.
when we create a unique key on table Non clustered index
automatically created. 253 non clustered indexes are
possible for a table.
3. yes (its not recommended)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do database indexes work?
After removing a table from database, what other related objects have to be dropped explicitly?
What are cascading parameters in ssrs reports?
How to update values in a table with update statements in ms sql server?
Explain primary key and foreign key constraints?
Explain database normalization?
can SSRS reports Cache results?
How to define output parameters in stored procedures?
What are “lock” hints?
What is nonclustered index with included columns ?
What is user-defined inline table-valued function?
What are the different sql server versions?
what are user defined datatypes? : Sql server database administration
Which sql server table is used to hold the stored procedure scripts?
What do you mean by cardinality?
