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
- 8972 Views
- I also Faced
- E-Mail Answers
Answer Posted / kishore
1.No.In a table only one primary key.we have to use the
behavior of primary key i.e in a colon to set unique key and
not null.
2.Cluster index is the leaf node directly consist a values.
and non cluster index is the leaf node consists address of
value at same task or heap.
3.No
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What is the parse query button used for?
What are different types of subquery?
Why transaction is important?
Explain difference between control flow and data flow?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
How to use clusters?
What is a sql join?
What is sql server schema compare? How we can compare two database schemas?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How much memory that we are using in Logshipping Concept?
Differentiate between a local and a global temporary table?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
How would you go about developing a ssrs report?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
How to find the list of fixed hard drive and free space on server?
