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;"
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
Tell me what do we need queues in sql service broker?
Explain Reporting Life Cycle?
What is user-defined function?
Tell me what is de-normalization and what are some of the examples of it?
How can i Relate Tables in SSIS
Can you name some of the dml commands in sql?
Can two tables have the same primary key?
Which trace flags are enabled in sql server?
Explain the dbcc pintable command when would you use it?
What is the log shipping?
Does sql server 2016 have ssms?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Which rendering formats are affected by the pagesize properties?
What is resource governor?
Why do we need different type of parameter?