RealPage interview question

How do you secure Web API. How will you improve the application performance. Explain SOLID Priciples. How & Where it is used in your application. Explain Design Patterns you have implemented in your application. What are Triggers. Whats its use. What are Magic tables. Difference between Temp table and table variable. What is CTE. How will you optimize a stored proc. How will you implement paging, filtering and sorting in stored proc.