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

Must read unix shell scripting interview questions

Unix is used everywhere and knowledge of the operating system is must for any interview. Here are the must read  unix shell scripting interview questions 1) What is Shell Script? Answer A shell script is a collection of command which are executed in a order given. There are conditional statement and looping also available like if ,while which helps in finding if a particular value is … Continue reading Must read unix shell scripting interview questions »

Top 40 oracle dba interview questions and answers

This article contains the most commonly asked top 40 oracle dba interview questions and answers 1) What is oracle database ? Answer: Oracle Database is a relational database management system (RDBMS) which is used to store and retrieve the large amounts of data. Oracle Database had physical and logical structures. Logical structures and physical structures are separated from each other 2) What is the difference … Continue reading Top 40 oracle dba interview questions and answers »

Top 40 Oracle sql interview questions

This article contains Top 40  Oracle sql interview questions asked in various interview. I hope it should help in interviews 1) What is a table Cluster ? Answer: Table Cluster is a group of related tables that share common columns are store related data in the same block. 2) What is exists usage in sql Answer “exists” statement helps us to do the job of … Continue reading Top 40 Oracle sql interview questions »

Most commonly asked 25 oracle plsql interview questions

Here  is the compilation of Most commonly asked oracle plsql interview questions Q1) What is Oracle plsql? Answer PL/SQL is a procedural language extension to Structured Query Language (SQL). The purpose of PL/SQL is to combine database language and procedural programming language Q2) What are the components of a PL/SQL Block? Answer Declarative part, Executable part and Exception part. Q3) What are the datatypes a available … Continue reading Most commonly asked 25 oracle plsql interview questions »

40 question you must know about R12.2

40 questions you must know about R12.2

R12.2 is the latest release in Oracle EBS area. We are presenting here the most sought over 40 question you must know about R12.2 Question 1: What is Online Patching? Answer: Online patching is a new patching mechanism that is available with R12.2 that allows the application of patches while the system is up and running, and the users are working as normal. Question 2: Which … Continue reading 40 question you must know about R12.2 »

Oracle examination questions

Question 1. Which two are valid modes for a process requesting latches? A. Scheduled B. Deferred C. Immediate D. Pre- Emptive E. Willing- to- Wait Solution C, E. Question 2. Which three SQL statements can use the NOLOGGING mode to reduce redo operations? A. UPDATE B. CREATE INDEX C. ALTER INDEX …REBUILD D. Conventional Path INSERT E. CREATE TABLE …AS SELECT Solution B, C, E. … Continue reading Oracle examination questions »

30 Awesome Frequently asked DBA questions

I am here presenting some of the most commonly asked DBA questions. We have provided the required answer to these DBA questions also Question 1) How to find Database version ? Answer SQL> select * from v$version; The command returns the release information, Question 2) How to find opatch Version ? Answer opatch is utility to apply database patch , In order to find opatch version execute”$ORACLE_HOME/OPatch/opatch … Continue reading 30 Awesome Frequently asked DBA questions »

60 Awesome oracle apps dba interview questions

Here is the list of oracle apps dba interview questions, I expect Apps DBA to know Question 1) I am applying a patch , can I open another session and run adadmin ? Answer Yes, We can run unless you are running a process where workers are involved Question 2) I am applying a patch , can I open another session in another node and … Continue reading 60 Awesome oracle apps dba interview questions »

Oracle performance tuning examination question -1

Oracle performance tuning examination few questions are present below. Question 1.When tables are stored in locally managed tablespaces, where is extent allocation nformation stored? A. Within the locally managed tablespace B. Data dictionary C. Temporary tablespace D. Memory Answer: A Question 2.What are two benefits of storing each table and index partition in a separate tablespace? A. You can backup and recover each partition independently. … Continue reading Oracle performance tuning examination question -1 »

40 Adpatch question every DBA should know

Here 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 mini pack ? Ans : A mini pack … Continue reading 40 Adpatch question every DBA should know »

Most commmonly Frequently asked questions for DBA

Here 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 example of which step in the oracle tuning … Continue reading Most commmonly Frequently asked questions for DBA »

All about Oracle certification program

All 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 times first shortlisting happens on the basis of … Continue reading All about Oracle certification program »