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

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 5073

LOV can best describe a) window b)modal c)list d) none of these d)

ESS,

5 7558

can u plz provide me oca sql dumps please i need them

1999

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4511

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

Sierra Atlantica,

2059

what is the difference between data migration and production migration.

2404

candidate key is subset of super key but not vice-verse explain

2116

can u give guidance abt packages of plsql

Mphasis,

2245

"primary key=unique+null" is equal,reson?not,reason?

5 7491

How to define a cusotmer as a supplier in ORACLE R12

Intelligroup,

2310

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

Intelligroup,

2257

what is shared memory?

IBM,

1 4387

what is semphore explian it?

IBM,

2885

what is the link between suppliers and banks in ap module in oracle apps? And also query?

Polaris,

2546

how many outer joins are used in a single sql query? is there any limitations for using of outer joins?

BOB Technologies, Cap Gemini, IBM,

2 9311

Un-Answered Questions { Oracle }

What do you understand by the term 'normalization'? Explain the various modes of normalization?

598

How can we view last record added to a table?

1110

How will you run ms_batch file in forms?

Difference between case & decode?

727

Explain the use of decode function

what is the difference between substr and instr function in oracle?

1145

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

8014

What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

620

What is an oracle database table?

1065

Explain the benefits and uses lexical parameter.

What is the database name in oracle?

1083

What is an oracle user account?

1047

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2316

How can you determine if an index needs to be dropped and rebuilt?

605

How can windows applications connect to oracle servers?

1123

For More Un-Answered { Oracle } Questions Click Here