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
- 7726 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasanna
1.We cant see more than one primary key for the table,
however we could create composite index using clustered
index in a table.
2.Clustered index - Order the data in the physical order.
Non clustered index does not order the data
3.We can select both the table using that script which u
mentioned.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are different types of table joins?
Does sql server use java?
What are constraints?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Does sql server 2016 have ssms?
What is nested transaction?
What is an etl file?
Can an automatic recovery be initiated by a user?
what are database files and filegroups? : Sql server database administration
What do you mean by data manipulation language?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
what is raid? : Sql server database administration
Ms sql server index?
What are the differences between sql server and mysql.
Do you know the isolation level that sql server support?
