SQL Interview Questions -Set3 – User friendly Tech help

Lets explore more on SQL interview questions.
nKeep sharing and Keep learning.


Do follow us for more updates on  Fb,G+,Twitter.



  1. Why we use Triggers in SQL? Explain with real time example.
  2. n

  3. Can we use pre triggers in SQL?
  4. n

  5. We have Table A AS 10 MB space and Table B as 10 MB space, what would be the size of View created by joining both the tables.
  6. n

  7. How to improve performance in SQL query execution.
  8. n

  9. Is view called a physical object?
  10. n

  11. How many rows would be shown in the result for query Select * from Table A , Table B.
    nWhere Table A have 10 rows and Table B have 20 rows
  12. n

  13. Column Bool in Table A, have values 1,0,1,1,0,1,0,1 write a query to replace all 0 with 5 and all ‘1’ with 10n

    Hint:-Update Table A SET Bool = CASE when Bool > 0 THEN 10 ELSE 5 END


  14. n

  15. Table A , have column named First_Name, write a query to concatenate “LongName” at the end incase name is more than 10 alphabets long.
    nHint:-select len(FIRST_NAME) from employee
  16. n

  17. Advantages of using SP(Stored procedures)?
    nHint:-Stored procedure can reduced network traffic and latency, boosting application performance.Stored procedure execution plans can be reused, staying cached in SQL Server’s memory, reducing server overhead.Stored procedures help promote code reuse.Stored procedures can encapsulate logic. You can change stored procedure code without affecting clients.n

    Stored procedures provide better security to your data.


  18. n

  19. What is a cursor and why would you use it?
  20. n

  21. How do you auto number rows in SQL Server?
    nUsing Identity Column
  22. n

Was this article helpful?

Similar Posts