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 12936

what is foreign key?

5 8467

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 26866

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 137336

What is index? How many types of indexes?

HCL,

2 12082

Can Multiple instances be run on Single Machine???

3 6052

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 6541

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.

2152

How cost of one Forms created & Report Created?

TCS,

1 4830

What is Index and different types of Indexes?

7 36222

what is the bitmap index?

3 6936

Un-Answered Questions { Oracle }

What are internal user account in oracle?

1005

Explain the use of log option in exp command.

1120

Explain an integrity constrains?

1147

Explain a private synonyms?

1036

Explain the use of consistent option in exp command.

1066

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

573

List the parts of a database trigger.

1049

Are truncate and delete commands same? If so why?

1152

What is a canvas in oracle forms?

1066

How many memory layers are in the oracle shared pool?

1179

How to assign values to data fields in record variables?

1035

What is an Oracle Instance?

1121

Please explain joins in oracle?

1060

If you are working Microsoft excel, which type of file you used .excel or .csv?

643

How to display employee records who gets more salary than the average salary in the department?

1065

For More Un-Answered { Oracle } Questions Click Here