Technology is playing an important role in everyday life. Oracle is in great demand and has revolutionized the way businesses work. Answer the question where you are asked to differ between truncate and delete in sql or oracle. An important question in your interview is about the maximum buffer size in a oracle function called dbms_output.enable. Give an example about how to specify the buffer size here. There are more detailed and important sql and oracle interview questions which are mostly asked.

Tell in detail about the self join. The various instances here in a table are to be found which are joined in the query. It is useful here to find out the meaning of self join. The important reasons for using commit statement inside a database trigger. We have to use the utl_file here and the functions related to it. There are also procedures which are related to this file and these must be used properly. For all those who are preparing, you can find all sample placement papers here.

Next is the importance of using OCI and its various function in oracle and sql technologies. What is the main reason for using oracle precompilers? You can study & keep these for your personal use. Details about the syntax used to drop a procedure are asked. It is also advised to know the syntax to drop a function as well. According to you, whether the actual parameters can have the default values or not. How are the actual parameters different from the formal ones? How do they differ in functioning?

Find out the proper definition of procedure and function as well along with the reason for storing the cursor variables in pl or sql tables. How is this achieved in sql? What methods can be followed for passing cursor variables here and the techniques we use to open or close this? The kind of return types which are used here and the importance of using scalar data type.

Last 5 posts by admin

• Use Algadon to entertain your self in the online market - July 31st, 2010
• Disposable Cameras - July 23rd, 2010
• Avoiding Laptop Mouse Disorders - July 18th, 2010
• Mobile Phone Technological Advantages - July 8th, 2010
• How to get Cheap Mobile Phones - June 25th, 2010