Home » SQL Interview Q & A

SQL Interview Q & A

A Series of SQL Server basics to advanced level SQL Interview questions and answers that are commonly asked in interivew.




SQL Server QUIZ

SQL QUIZ

 

SQL Server Interview Questions and Answers

SQL Interview Q & A

  1. How to Get the definitions of Stored procedures, user defined functions and triggers in SQL ?
  2. What is SQL SERVER user defined table type and table valued parameters ?
  3. SQL Query to get the list of files in a folder in SQL?
  4. Truncate vs Delete statements in SQL Server?
  5. How to access a data of table from another database in SQL Server?
  6. How to check if user table or temp table exists in database?
  7. How to display Cumulative Total in SQL ?
  8. What is Correlated Subquery in SQL ?
  9. NULL vs BLANK in SQL ?
  10. How to implement custom sorting in SQL ?
  11. Primary Key VS Composite Key ?
  12. What is SQL Server Sequence ?
  13. What is Foreign key in SQL server, how to add Foreign key in an existing table ?
  14. What is SQL drop table command, does it support rollback ?
  15. What is unique key constraint in SQL Server ?
  16. What is TRY..CATCH block and How to Handle T- SQL Code error using TRY.. CATCH Block?
  17. What is SQL pivot, and what is the use of pivoting a table ?
  18. What is triggers in SQL ?
  19. What is Merge Statement in SQL and use of Merge in SQL ?
  20. How to create jobs in Sql Server ?
  21. What is SQL Server table type and table valued parameter ?
  22. What is Views in SQL Server?
  23. What is SQL Server temporary tables?
  24. What is GROUPING SETS in SQL?
  25. What is CUBE in SQL ?
  26. What is IIF() Logical Function is SQL ?
  27. What is Choose() logical function in SQL?
  28. How to identify blocking processes/long running queries in SQL server ?
  29. What is SQL Server Computed Columns ?
  30. How to find out identity column without using column name ?
  31. How to configure SQL Server Database Mail ?
  32. How to troubleshoot SQL Server Database Mail?
  33. What is synonms in SQL Server and its role ?
  34. How to insert explicit values into identity column ?
  35. How to send a SQL Server Query result in text format using database e-mail?
  36. What is NEWSEQUENTIALID() function in SQL Server, what is the difference between NEWSEQUENTIALID() and NEWID() ?
  37. How to get the sizes of all databases on a SQL Server ?
  38. How to display currency symbol for different different cultures in SQL Server?
  39. How to concatenate rows of strings into one string with a specified separator?
  40. How to find Nth highest salary in SQL Server ?
  41. How to display detailed truncation error in SQL Server ?
  42. How to Split Comma Separated string values into columns? 
  43. How to Display calendar dates for any n numbers of years in SQL Server?
  44. SQL Server VARCHAR VS NVARCHAR
  45. SQL Server CHAR VS NCHAR?
  46. What is the difference between SQL Server Stored Procedures and User Defined Functions (UDF)?
  47. FOR JSON clause in SQL Server?
  48. What is LogOn trigger in SQL Server?
  49. How to get all the tables in database those are having primary key constraints ?
  50. How to create a dynamic column in pivot ?
  51. How to unpivot the table data in SQL Server ?
  52. Query to get the students who scored higher than 80 marks and sort result based on last three characters of name and StudID in ascending  ?
  53. Print prime number separated by comma till n numbers in SQL?
  54. What is cascading referential integrity in SQL Server?
  55. SQL CROSS APPLY vs OUTER APPLY, and how they differ from Joins?
  56. How to get the last accessed time for tables in SQL Server?
  57. How to Copy or delete files from directory in SQL Server?
  58. How to change the column collation to Case Sensitive?
  59. How to auto execute any stored procedure on SQL Server Services startup ?
  60. How to Encrypt a Stored Procedure in SQL Server?