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;"
Answer Posted / debi
1.no we can't set more than one primary key for a table
3. yes we can write a query like select 8 from table1,table2
this is generally used in case of cartesian product
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is acid properties?
Differentiate between ms sql server reporting services vs crystal reports?
What are the fixed server level roles? : sql server security
What causes index fragmentation?
What is triggers and its types?
What are the difference between clustered and a non-clustered index?
What is difference statement and preparedstatement?
Can you please explain the difference between function and stored procedure?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What is difference in performance between insert top (n) into table and using top with insert?
What is cursors?
Can sql servers linked to other servers like oracle?
How to change the password of a login name in ms sql server?
What do you mean by tablesample?
Explain in brief how sql server enhances scalability of the database system?