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
- 8896 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
Tell me what is the difference between locking and multi-versioning?
How do you send email on SQL Server?
What is the ‘fillfactor’?
What is store procedure? How do they work?
What are different types of join?
How important do you consider cursors or while loops for a transactional database?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
what are the critical issues you have resloved in your company
What is cursors?
If no size is defined while creating the database, what size will the database have?
Define full outer join in sql server joins?
What is a trigger in sql server?
What is not null constraint?
how to control the amount of free space in your index pages? : Sql server database administration
What is difference between global temporary tables and local temporary tables?
