1.Can we use DML statement in view

2.Can we update primary key, what will happen with the foreign key

3.Is there any solution to update view base on multiple table

4.Difference between return value and output parameter in SP

5.How do you see transaction isolation feature 

6.What is In-Memory Tables in SQL

7.Column store index, DIfference between row store and column store index

8.Is there any difference between normal delete and delete in column store? Is there any difference 

9.Segmentation and fragmentation

10.Have you work on partition table

11.let us go through practical example.(Please go through the image).Write view, for each employee for each row look for the next record and then reduce 1 day that will be effective_upto_date.

12.How do you do requirement gathering, what are steps you will do

13.What kind of delivery method do you use,  Waterfall or Agile ?

14. How do you do impact analysis? if you have 1000 tables , 100 Sp , 50 packages , several reports and other objectsHow do you assess all these impacts for e.g emp id now has int and now client say i want to change as alphanumeric.

EMP table:

Emp_id, Name

1, XYZ

2, PQR

Null,Other

Salary Table :

ID,Salary 

1, 14000

3, 20000

Null, null

Output : Inner join :Left Join :Right Join :Full join :Cross join :

15.How do you train your subordinate, suppose new joinee come, how do you help them as you are a senior resource.