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
- 9229 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 is NOT NULL Constraint in sql server 2012?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
How do you size a resultset?
What is policy management?
Explain cursor as data base object?
What Are the Main Features of SQL Azure?
Define full outer join?
Can you explain the disadvantages/limitation of the cursor?
What is repeatable read?
How many cores do I need for sql server 2016?
What are rest-style architecture's?
How much space does sql server 2016 take?
Explain filtered indexes benefits?
What are logical database components? : SQL Server Architecture
How to disable stored procedure sql server?
