Oracle Recent Database DBMS Interview 2008 Questions - 2

Interview questions for Oracle database administrator

1. Differentiate between TRUNCATE and DELETE

2. What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?

3. Can you use a commit statement within a database trigger?

4. What is an UTL_FILE.What are different procedures and functions associated with it?

5. Difference between database triggers and form triggers?

6. What is OCI. What are its uses?

7. What are ORACLE PRECOMPILERS?

8. What is syntax for dropping a procedure and a function? Are these operations possible?

9. Can a function take OUT parameters. If not why?

10. Can the default values be assigned to actual parameters?

11. What is difference between a formal and an actual parameter?

12. What are different modes of parameters used in functions and procedures?

13. Difference between procedure and function.

14. Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

15. How do you pass cursor variables in PL/SQL?

16. How do you open and close a cursor variable.Why it is required?

17. What should be the return type for a cursor variable.Can we use a scalar data type as return type?

18. What is use of a cursor variable? How it is defined?

19. What WHERE CURRENT OF clause does in a cursor?

20. Difference between NO DATA FOUND and %NOTFOUND

21. What is a cursor for loop?

22. What are cursor attributes?

23. Difference between an implicit & an explicit cursor.

24. What is a cursor?

25. What is the purpose of a cluster?

26. How do you find the numbert of rows in a Table ?

27. Display the number value in Words?

28. What is a pseudo column. Give some examples?

29. How you will avoid your query from using indexes?

30. What is a OUTER JOIN?

31. Which is more faster - IN or EXISTS?

32. When do you use WHERE clause and when do you use HAVING clause?

33. There is a % sign in one field of a column. What will be the query to find it?

34. What is difference between SUBSTR and INSTR?

35. Which datatype is used for storing graphics and images?

36. What is difference between SQL and SQL*PLUS?

37. What is difference between UNIQUE and PRIMARY KEY constraints?

38. What is difference between Rename and Alias?

39. What are various joins used while writing SUBQUERIES

See latest Oracle Interview Questions for year 2008 and previous years questions asked in hr interviews and technical, programming placement papers of leading IT MNCs. See the oracle database questions for 2007, 2008 papers and detailed interview questions with solutions. See the questions of january, february, march, april, may, june, july, august, september, october, november, december 2007 and 2008 for free online sorted by categories... Various companies papers like infosys, wipro, tcs, hcl, cisco, microsoft, ibm, sap, satyam computers, patni, mastek, ramco systems, cognizant, cap gemini, accenture, etc. are provided here.. also gaming related questions are given here in detail related to graphic design and website database real SQL questions and open source related questions.. keep watching