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
- 7327 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 are the important architecture components of SSRS?
Explain activity monitors
What is extended stored procedures?
How does stuff differ from the replace function?
How adventureworkslt tables are related?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is command parameter in ssrs?
What is difference between inner join and full join?
Explain system scalar functions?
What is difference between commit and rollback when used in transactions?
What are the differences between DDL, DML and DCL in SQL?
What is the full form of ddl?
How to insert multiple rows with a subquery?
What is faster join or union?
How to test a dml trigger in ms sql server?
