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
- 9013 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
What specific conditions database should meet, before you can bulk copy data into it using bcp?
Can binary strings be used in arithmetical operations?
Explain hostprotectionattribute in sql server 2005?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What is inner join? Explain with an example?
How to get a list all databases on the sql server?
What are the differences between web role and worker role?
Do you know how to implement service broker?
What are some examples of schemas?
Explain indexed views?
What are the elements of dbms?
Can coalesce return null?
Can you import Microsoft Excel data to SSRS?
How to change the ownership of a schema in ms sql server?
Can you explain the disadvantages/limitation of the cursor?
