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
- 7328 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
explain extended properties
What is repeatable read?
What purpose does the model database server?
How do you run a trace?
How are the unique and primary key constraints different?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
Write SQL queries on Self Join and Inner Join.
How many types of cursor type are there?
Can we delete data from a view?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is self contained sub query?
how to overcome kernel isssues
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What are the new features of sql server 2012 reporting service?
