SQL INTERVIEW QUESTIONS questions

  • 1. Difference between varchar and varchar2 data types?
  • 2. In which language Oracle has been developed?
  • 3. What is RAW datatype?
  • 4. What is the use of NVL function?
  • 5. Whether any commands are used for Months calculation? If so, What are they?
  • 6. What are nested tables?
  • 7. What is COALESCE function?
  • 8. What is BLOB datatype?
  • 9. How do we represent comments in Oracle?
  • 10. What is DML?
  • 12. How do we display rows from the table without duplicates?
  • 13. What is the usage of Merge Statement?
  • 14. What is NULL value in oracle?
  • 15. What is USING Clause and give example?
  • 16. What is key preserved table?
  • 17. What is WITH CHECK OPTION?
  • 18. What is the use of Aggregate functions in Oracle?
  • 19. What do you mean by GROUP BY Clause?
  • 20. What is a sub query and what are the different types of subqueries?
  • 21.What is cross join?
  • 22. What are temporal data types in Oracle?
  • 23. How do we create privileges in Oracle?
  • 24. What is VArray?
  • 25. How do we get field details of a table?
  • 26. What is the difference between rename and alias?
  • 27. What is a View?
  • 28. What is a cursor variable?
  • 29. What are cursor attributes?
  • 30. What are SET operators?
  • 31. How can we delete duplicate rows in a table?
  • 32. What are the attributes of Cursor?
  • 33. Can we store pictures in the database and if so, how it can be done?
  • 34. What is an integrity constraint?
  • 35. What is an ALERT?
  • 36. What is hash cluster?
  • 37. What are the various constraints used in Oracle?
  • 38. What is difference between SUBSTR and INSTR?
  • 39. What is the parameter mode that can be passed to a procedure?
  • 40. What are the different Oracle Database objects?
  • 41. What are the differences between LOV and List Item?
  • 42. What are privileges and Grants?
  • 43. What is the difference between $ORACLE_BASE and $ORACLE_HOME?
  • 44. What is the fastest query method to fetch data from the table?
  • 45. What is the maximum number of triggers that can be applied to a single table?
  • 46. How to display row numbers with the records?
  • 47. How can we view last record added to a table?
  • 48. What is the data type of DUAL table?
  • 49. What is difference between Cartesian Join and Cross Join?
  • 50. How to display employee records who gets more salary than the average salary in the department?
  • 51.What is the difference between UNIQUE and PRIMARY KEY?
  • 52.Which command displays the SQL command in the SQL buffer, and then executes it?