Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

what is primary key?

9 12682

what is foreign key?

5 8272

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 26420

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 135449

What is index? How many types of indexes?

HCL,

2 11929

Can Multiple instances be run on Single Machine???

3 5920

How to create LOV in Oracle forms?

Accenture, Polaris,

2 33272

Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through

Azri Solutions,

1 6473

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

eicc,

2269

pls explain connect by prior with example and its real time use

3 14414

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2151

which one is currently in used software cmpanies.

2115

How cost of one Forms created & Report Created?

TCS,

1 4737

What is Index and different types of Indexes?

7 35969

what is the bitmap index?

3 6786

Un-Answered Questions { Oracle }

How to create a temporary table in oracle?

1206

Why is oracle used?

887

How to rename an index?

1012

Name the different triggers associated with oracle forms having a master-detail relationship.

937

What is data type in oracle?

1054

What is a dba why is this position necessary?

540

What do you mean by group by clause?

992

as a technical developer in oracle applications which type errors feced in your experience sofar

2281

Explain the various types of canvas in form.

What is the order of defining local variables and sub procedures/functions?

1017

List the parts of a database trigger.

997

How to load data from external tables to regular tables?

1005

How to update values in a table in oracle?

970

Differences between package and loadplans?

550

Explain odi architecture?

579

For More Un-Answered { Oracle } Questions Click Here