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
- 7724 Views
- I also Faced
- E-Mail Answers
Answer Posted / koushik roy
1. A table can only have one primary key.
2. Answer #1 is right. To add it, primary key is clustered
index and when we index a column (non-primary key) it is
non-clustered index.
3. Yes this will act almost as OUTER join
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What do you mean by normalisation?
Benefits of Stored Procedures?
What is the standby server?
What is the ‘fillfactor’?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What is shrink log file?
What are the restrictions that views have to follow?
What options are available to audit login activity? : sql server security
How to view the error log for any specific instance? : sql server database administration
What is raid, and how it can influence database performance?
When is update_statistics command used?
What are sub reports and how to create them?
What is the data type of time?
what is a self join? Explain it with an example? : Sql server database administration
What are the ways available in sql server to execute sql statements?
