SQL INTERVIEW 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?