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
- 8709 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
How to use user defined functions in expressions?
How to insert multiple rows with one insert statement in ms sql server?
Can you explain what are various ways to enhance the ssrs report?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Can you create a logon trigger in sql server 2005 express edition?
What purpose does the model database server?
What is a performance monitor?
What are secondary xml indexes?
What is pessimistic concurrency?
What are some examples of schemas?
Explain “row_number()” in sql server with an example?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
what are the disadvantages of cursors? : Sql server database administration
How much does sql server 2016 cost?
Can You Use Data Mining Models In Ssrs?
