101 Most Frequently Asked Interview Questions of Oracle

10:26:00    

101 Most Frequently Asked Interview Questions of Oracle

Objective of the post 101 Most Frequently Asked Interview Questions of Oracle  is to provide beginners as well as professionals a ready reckoner of Oracle. What are 101 Most Frequently Asked Interview Questions of Oracle? We have tried to enlist here 101 Most Frequently Asked Interview Questions of Oracle.

There may be more questions other than these. We will try to add them from time to time. We request readers of this post to suggest more latest questions of Oracle-SQL, PL/SQL,which are popular in interviews. 

101 FAQ of ORACLE

  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 ?

  • pl/sql interview questions and answers for freshers 
  • oracle faq interview questions
  • 101 Most Frequently Asked Interview Questions of Oracle