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 12937

what is foreign key?

5 8469

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 26871

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 137354

What is index? How many types of indexes?

HCL,

2 12083

Can Multiple instances be run on Single Machine???

3 6054

How to create LOV in Oracle forms?

Accenture, Polaris,

2 33386

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 6542

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,

2322

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

3 14535

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

2183

which one is currently in used software cmpanies.

2153

How cost of one Forms created & Report Created?

TCS,

1 4830

What is Index and different types of Indexes?

7 36223

what is the bitmap index?

3 6938

Un-Answered Questions { Oracle }

Which date function is used to find the difference between two dates?

578

How to define a record variable to store a table row?

1058

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2525

How to create Drill down report?

2127

How to return top 5 rows in oracle?

1062

What is forms_mdi_window?

How to connect to oracle using service name instead of sid?

1024

How to add a new column to an existing table with a default value?

1016

WHAT IS ecc 6.0

2147

what we specify the in XML data server and parameters for to connect to xml file?

700

What happens if the update subquery returns multiple rows?

1116

What is the purpose of the import option ignore? What is its default setting?

600

What is the data pump export utility?

1081

What is transactional trigger property?

Explain the difference between sap and oracle?

1029

For More Un-Answered { Oracle } Questions Click Here