Aug 19, 2022, 01:30 PM

News:

MyKidsDiary.in :: Capture your kids magical moment and create your Online Private Diary for your kids


Oracle Database Administrator Interview Questions

Started by Kalyan, Jan 10, 2009, 01:26 AM

previous topic - next topic
Go Down

Kalyan

Oracle Database Administrator Interview Questions

   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?

Go Up
 

Quick Reply

With Quick-Reply you can write a post when viewing a topic without loading a new page. You can still use bulletin board code and smileys as you would in a normal post.

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.
Name:
Email:
Verification:
Please leave this box empty:

Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:

shortcuts: alt+s submit/post or alt+p preview
IT Acumens Web Designing Chennai | GinGly :: Build your Personal Website | CineBuzz :: Cinema News | My Kids Diary :: Gift your Kids Memories :: Book Website @ 349 Rs monthly
Copyright © 2005 - 2021 :: IT Acumens :: All Rights Reserved. :: XML Sitemap
ITAcumens Discussion Forum with 2 lakhs post running for 15 years - Powered by IT Acumens Pro Dedicated Server

My Kids Diary