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
- 8895 Views
- I also Faced
- E-Mail Answers
Answer Posted / manub22
1.There cannot be more than 1 Primary Keys for a given table?
2.Difference between Cluster Index and non-Clustered Index, check this link: http://sqlwithmanoj.com/2011/03/02/clustered-vs-nonclustered-indexes-and-data-sorting/
3.Yes, we use query like this "Select * from Table1, Table2;". This will give a Cross Join (or cartesian-product) results from both the tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you insert values in multiple rows using one Insert statement?
What is set nocount on and what is set nocount off?
Explain the properties of a relational table?
How do you check sql server is up and running?
What is standby servers? Explain types of standby servers.
How many types of the database links?
What is the purpose of optimization?
What are the advantages dts has over bcp?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is data source object?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
How does normalization work?
What are the steps to process a single select statement?
Are all views updatable ?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
