Pages

Archives

Blogroll

Categories

Recent Posts

Tags

application software Web Binary parcels binary solutions of software business logistics system business models business software cable technology Cash advace loann cell phone Custom software Custom Software Application Epson T0711 ink cartridge fast cash payday loans financing of technology flight in jet greatest technological HR and payroll software ink cartridges for Epson SX405 magnetic cards Mobile phones music teacher network management Nokia online information Online merchant processing payroll software potential customers Powered Electrical Systems printer cartridges printer ink quite interactive software applications software development software equipment software of freight broker software of technology software technologies software technology Solar Powered submission tool technology education technology performance tools of technology Voice messaging Service Web Hosting Company

Part of the Oracle Technical Interview

Posted by admin on August 12th, 2009

12 Aug

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

No Comments

No comments yet.

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.