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
- 9230 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramya
1)No We can't have more than 1 primary key. Even if you try
to save it will pop an error message and nothing will be stored.
2)Clustered Index is attached with Unique. A table can have
1 and only 1 Clustered Index and it will be mostly created
on the Primary Key of the Table.
Non Clustered can be up to 254(not sure about the
number)created for a single table.
3)You can definitely select from 2 tables but all the
columns will be merged. Please check how you want the data
from those 2 tables
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What do you understand by the data quality services in sql server?
What is onf in normalization form?
What do you mean by 'normalization'?
What is report snapshot in ssrs?
What are the lambda triggers?
Can you explain what are commit and rollback in sql?
What is coalesce and check constraint in sql server?
What is extent? Types of extents?
Explain the properties of sub-query in sql server?
How can we determine what objects a user-defined function depends upon?
How to loop through the result set with @@fetch_status?
What is public role in sql server?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
List the different types of joins?
What is an active database?
