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
- 9228 Views
- I also Faced
- E-Mail Answers
Answer Posted / anilreddy
1)No,but in single primary key we can select upto 16 columns
2)Clustered index can be only one,Nonclustered indexes can be 249
3)Yes,we can write cross join will be applied
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many partitions a clustered index has by default in sql server 2012?
Can we insert data if clustered index is disabled?
What are the common performance issues in sql server?
Do you know what is a linked server in sql server?
How can you tell if a database object is invalid?
What is update locks?
What are recommended options to be used while using db mirroring? : sql server database administration
What are the different types of lock modes in sql server 2000?
Can a function call a stored procedure in sql server?
Can we insert data into view sql server?
What is an execution plan? How would you view the execution plan?
List some case manipulation functions in sql?
What is primary key, unique key, and foreign key?
How many database files are there in sql server 2000?what are they?
What is parameterized reports in ssrs ?
