how many joins we can write if at all we have n no of
tables
- 5 Answers
- 15215 Views
- Tanla Solutions, TS, I also Faced
- E-Mail Answers
Answer Posted / soni
To join n no. of tables ,we required n-1 join conditions
| Is This Answer Correct ? | 31 Yes | 3 No |
Post New Answer View All Answers
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is the size of transaction log file?
How to insert a new row into a table with "insert into" statements in ms sql server?
What does executeupdate return?
Why use update_statistics command in sql server?
What do you mean by an execution plan? Why is it used?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What are different types of constraints?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
Explain isolation levels that sql server supports?
Write SQL queries on Self Join and Inner Join.
Tell me about the approaches which you used to counter the DI problems.
How to execute function in stored procedure sql server?
What is a collation?
What are the types of normalization?
