Neohype Software Engineer interview questions

1) Diff Between Drop,Delete and Delate 2) Diff Between Union and Union all 3) Diff Between Rank() and Row_Number() 4) What is Triggers and there types 5) what is constrains 6) what is Index and there type 7) Diff Between sp and function 8) what is web api 9) Diff bet web api and rest aip and some scenarios base questions