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 12920

what is foreign key?

5 8446

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 26809

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 137107

What is index? How many types of indexes?

HCL,

2 12062

Can Multiple instances be run on Single Machine???

3 6040

How to create LOV in Oracle forms?

Accenture, Polaris,

2 33375

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 6538

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,

2318

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

3 14523

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

2176

which one is currently in used software cmpanies.

2143

How cost of one Forms created & Report Created?

TCS,

1 4823

What is Index and different types of Indexes?

7 36196

what is the bitmap index?

3 6930

Un-Answered Questions { Oracle }

How to fetch the row which has the max value for a column?

996

What is oracle in java?

961

What is a view and how is it different from a table?

1040

What are the logical operations?

1119

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1837

Explain the use of grant option in exp command.

1060

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

604

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2267

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1981

How to create an oracle database?

1033

How do I connect to oracle database?

1110

Mention what is the volume management techniques used in oracle rac?

What are the differences between char and varchar2 in oracle?

1162

What is key.next.item trigger?

What is the use solutions?

583

For More Un-Answered { Oracle } Questions Click Here