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 12938

what is foreign key?

5 8469

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 26872

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 137357

What is index? How many types of indexes?

HCL,

2 12086

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?

2184

which one is currently in used software cmpanies.

2153

How cost of one Forms created & Report Created?

TCS,

1 4832

What is Index and different types of Indexes?

7 36224

what is the bitmap index?

3 6939

Un-Answered Questions { Oracle }

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

how can you pass values to-and-fro from foreign function?

How do we get field details of a table?

978

Name the various constraints used in oracle?

1019

Why we use oracle d2k?

Explain integrity constraint?

1161

What is clustered table in Oracle?

1196

How to write a query with a left outer join in oracle?

1065

How can we delete duplicate rows in a table?

973

What is required by oracle rac database to connect to a network?

How to check database size in Oracle?

1191

What is the difference between oracle media recovery and crash recovery?

1175

What is oracle datasource?

985

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1786

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2231

For More Un-Answered { Oracle } Questions Click Here