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

Oracle General (1803)
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 13230

what is foreign key?

5 8641

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 27291

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 139215

What is index? How many types of indexes?

HCL,

2 12226

Can Multiple instances be run on Single Machine???

3 6167

How to create LOV in Oracle forms?

Accenture, Polaris,

2 33495

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 6635

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,

2390

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

3 14663

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

2250

which one is currently in used software cmpanies.

2203

How cost of one Forms created & Report Created?

TCS,

1 4915

What is Index and different types of Indexes?

7 36461

what is the bitmap index?

3 7076

Un-Answered Questions { Oracle }

What are the IKM types?

740

What is transactional trigger property?

What is the relation between database and instance?

702

What is bind variables in oracle reports?

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3249

What is catalog in Oracle?

1443

What are the original export and import utilities?

1268

What is an anonymous block?

1330

Difference between case & decode?

725

Which dba certification is best?

613

Explain a data segment?

1112

What are elements of administration?

641

How to shutdown your 10g xe server?

1208

What is a tns service name?

1058

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2342

For More Un-Answered { Oracle } Questions Click Here