Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8888 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
Explain nested trigger in sql?
What is store procedure?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Which autogrowth database setting is good?
What is the difference between Stored Procedures and triggers?
How to turn on the mssql api module in php?
What are relationships and mention different types of relationships in the dbms
Which is faster statement or preparedstatement?
What is merge statement?
How do you create a clustered index?
Some queries related to SQL
What is reportserver and reportservertempdb ?
explain different types of backups avaialabe in sql server? : Sql server database administration
what information is maintained within the msdb database? : Sql server administration
Explain the usage of floor function in sql server.
