Category Archives: Interviews questions

This page contains interview questions  on following topics

  1. Oracle database
  2. Oracle apps
  3. Oracle sql and plsql
  4. Unix
  5. php
  6. Oracle weblogic
  7. Oracle performance

I  am trying to cover most of the interview asked in these areas

40 Adpatch question every DBA should know

Last updated on August 25th, 2016 at 10:07 amHere is the compilation of 40 Adpatch question every DBA should know 1. What are the different types of patches? Ans : oneoff, mini packs, family packs, maintanance packs, rollup pathches, colsolidated patches. 2. What is a oneoff patch? Ans : An oneoff patch is a small patch of (20-90K size) without any pre-req’s 3. What is a … Continue reading 40 Adpatch question every DBA should know »

Most commmonly Frequently asked questions for DBA

Last updated on August 25th, 2016 at 09:45 amHere are some of the Frequently asked questions for DBA 1 which of the following is the first step in oracle’s recommended tuning a tune the database b tune the network c tune the application d all the above are equally important 2 increasing the size of the system global area in order to improve performance is an … Continue reading Most commmonly Frequently asked questions for DBA »

All about Oracle certification program

Last updated on August 31st, 2016 at 09:43 amAll about Oracle certification program The oracle certification program certifies a candidate based on its skills in particular oracle product and technology. The certificate is given by Oracle corporation and they are higly valued in IT industry. If two candidate have same skill sets then employer would prefer to choose the person which has Oracle certificate. Many … Continue reading All about Oracle certification program »

good Oracle sql examination questions with answer

Last updated on December 31st, 2015 at 06:05 pmHere are some of good Oracle sql examination questions with answer 1. You must permanently remove all data from the sales_data table, but will need the table structure in the future. What single command should be issued? a. DROP TABLE sales_data b. TRUNCATE TABLE sales_data c. DELETE FROM sales_data d. TRNCATE TABLE sales_data KEEP STRUCTURE; Solution :(b) … Continue reading good Oracle sql examination questions with answer »

19 oracle apps technical interview questions and answers

Last updated on November 8th, 2016 at 05:56 pmThis is a compilation of most commonly asked 19 oracle apps technical interview questions and answers Question 1 What is difference between AD_BUGS & AD_APPLID_PATCHES Ans: AD_BUGS holds information about the various Oracle Applications bugs whose fixes have been applied (ie. patched) in the Oracle Applications installation. AD_APPLIED_PATCHES holds information about the “distinct” Oracle Applications patches that have been … Continue reading 19 oracle apps technical interview questions and answers »

29 Oracle apps interview questions and answer

Last updated on August 27th, 2016 at 10:25 am Here we are presenting the most common Oracle apps interview questions and answer . Question 1) What is .pls files which you see with apps ? Ans: pls file stands for plsql files. In apps patch these files contain code to create package spec or package body or both. Question 2) What are .ldt & .lct … Continue reading 29 Oracle apps interview questions and answer »