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
- 7728 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 transactional replication?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
Difference between connected and disconnected database in .net with sql server?
What is ddl and dml commands?
What is RAID? What are the different types of RAID configurations?
What is the maximum rows in sql server table?
How to get @@error and @@rowcount at the same time?
write an SQL query to list the employees who joined in the month of January?
how you can get the list of largest tables in a database? : Sql server administration
Explain the database you used in your final year project?
When multiple after triggers are attached to sql table, how to control the order of execution?
Define constraints and give an example of their use?
Can you get second highest salary from the table?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
System variable and temporary variables
