Answer Posted / colin
A small error kuldeep..if left table has 10 rows n right
table has 8 rows..then a cross join wud return 80 rows
(10*8)..besides dis ur totally ryt.. Cross joins are also
called cartesian product..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is filter index?
How many databases can we create in a single server?
Explain stored procedure?
Explain the disadvantages/limitation of the cursor?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What are the different Topologies in which Replication can be configured?
Describe how to use linked server?
Explain steps of normalization?
What is sql server locking?
What is service broker?
What is the stored procedure?
How can you check the level of fragmentation on a table?
What is catalog views?
Explain the different types of joins?
