1.Difference between truncate and delete?
2. Difference between temp table and CTE and temp varibles?
3.Types of joins in sql?
4.What is the left join and left outer join?
5.Write an sql join query for below input
Table A:
ID
1
2
2
Null
Table B
ID
2
2
7
8
Null
6.How to optimize sql stored procedure?
7.What is the difference between primary key and foreign key?
8.What is merge and how it help for incremental load?
9.Types of views in sql?
10.What are types of indexs?
11.What column index?
No comments:
Post a Comment