Top 101 Most Frequently Asked Interview Questions and Answers of SQLfor Freshers and Experienced

23:27:00    


Top 101 Most Frequently Asked Interview Questions and Answers of SQL for Freshers and Experienced 



Objective of the post Top 101 Most Frequently Asked Interview Questions and Answers of SQL for Freshers and Experienced is to provide beginners as well as professionals a ready reckon er of SQL. What are Top 101 Most Frequently Asked Interview Questions and Answers of SQL for Freshers and Experienced? We have tried to enlist here Top 101 Most Frequently Asked Interview Questions and Answers of SQL for Freshers and Experienced.


101 Frequently Asked Questions of SQL




  1. Define SQL?


  2. Why SQL is known as non procedural language?


  3. What are the components of SQL?


  4. Name any two data types of SQL?


  5. Which data type in SQL is used for date data type.?


  6. Which data type in SQL is used float or Real Numbers?


  7. What is main difference between char and varchar2 data type in SQL?


  8. Which command of SQL is used to create a table in SQL?


  9. Which command of SQL is used to delete structure of a table in SQL?


  10. Which command of SQL is used to alter the structure of a table in SQL?


  11. Write the syntax of Update command in SQL?


  12. Write the syntax of Insert command in SQL?


  13. Write the syntax of Delete command in SQL?


  14. Define Primary key Constraint in SQL?


  15. What is the purpose of Check Constraint in SQL?


  16. Define sub query?


  17. What is used in SQL to query?


  18. Define self join ?


  19. If where is compulsory in select clause ?


  20. How many rows can be appended in a table with a single insert command ?


  21. What is command to give rights to users in SQL?


  22. What is the purpose of revoke command ?


  23. Which clause of SQL is used to arrange the records of a table in ascending order.


  24. What is the purpose of Group by command


  25. Name any two methods for multiple table retrieval in SQL


  26. Define Views


  27. What is the significance of using Views in SQL


  28. What is the other name of Views in SQL


  29. What are the types of Views in SQL


  30. What is the limitations on Views in SQL


  31. Define Sequences


  32. What is the significance of using Sequences in SQL


  33. Define Pseudo Columns in SQL


  34. Define Synonyms


  35. Name any two character functions of SQL


  36. Name any two number functions of SQL


  37. Name any two date functions of SQL


  38. Name any one conversion function of SQL


  39. Name any two Group functions of SQL


  40. What is the purpose of SUM function in SQL


  41. What is the purpose of Count Function in SQL


  42. Name the character function for concatenating two strings in SQL


  43. Name the function to find string length in SQL


  44. Name the function for find the number of days between two dates


  45. Name the function to find square root of a number


  46. Define database triggers


  47. What are the types of triggers in SQL


  48. Define locking


  49. What is the use of where clause


  50. Define Indexes


  51. What are the types of Indexes in SQL


  52. Difference between inner and outer join in SQL


  53. What is the purpose of LIKE in SQL


  54. What is Range searching


  55. What is Pattern matching


  56. Name the function for extracting one string from other string in SQL


  57. Name the function to capitalize initial letter of  a string in SQL


  58. Which command is used to undo transactions in SQL


  59. What is the purpose of savepoints in SQL


  60. What is the full form of PL/SQL


  61. If PL/SQL is non procedural language ?


  62. State one difference between SQL and PL/SQL?


  63. Name any two data types of PL/SQL ?


  64. What is the use of   “%found” in PL/SQL ?


  65. What is the use of   “%notfound” in PL/SQL ?


  66. What is the use of  “%isopen” in PL/SQL ?


  67. What is the use of  “%rowcount” in PL/SQL ?


  68. What is the use of  “%type” in PL/SQL ?


  69. What is the use of  “%rowtype” in PL/SQL ?


  70. Name any two loops of PL/SQL  ?


  71. What is conditional control statement of PL/SQL ?


  72. Define exceptions ?


  73. Name any in built two exceptions of PL/SQL ?


  74. When “Too many rows” exception is raised ?


  75. When “No rows found” exception is raised ?


  76. When “Divide By Zero” exception is raised ?


  77. When “Invalid Cursor” exception is raised ?


  78. Define Procedures ?


  79. Define Functions ?


  80. Define Cursors ?


  81. What are the types of Cursors ?


  82. Name any two Explicit Cursor attributes ?


  83. Name any two Implicit Cursor attributes ?


  84. When “before delete trigger” get fired ?


  85. When “before update trigger” get fired ?


  86. When “after update trigger”  get fired ?


  87. When “after update trigger”  get fired ?


  88. What is the use of  “sql %found” in PL/SQL ?


  89. What is the use of   “sql%notfound” in PL/SQL ?


  90. What is the use of   “sql%isopen” in PL/SQL ?


  91. What is the use of  “sql%rowcount” in PL/SQL ?


  92. Define Packages ?


  93. Define Snapshots ?


  94. Any two advantages of Packages ?


  95. Any five reserve words of PL/SQL?


  96. What is the use of  “set server output on” in PL/SQL ?


  97. What is the use of  “dbms_output.put_line” in PL/SQL ?


  98. Name the command to delete a database trigger in PL/SQL ?


  99. What is the purpose of LPAD  function in SQL ?


  100. What is the purpose of LTRIM function in SQL ?


  101. What are bind variables ?