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

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

2 4960

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

ESS,

5 7344

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

1943

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

4440

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,

2004

what is the difference between data migration and production migration.

2341

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

2068

can u give guidance abt packages of plsql

Mphasis,

2167

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

5 7275

How to define a cusotmer as a supplier in ORACLE R12

Intelligroup,

2228

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

Intelligroup,

2206

what is shared memory?

IBM,

1 4287

what is semphore explian it?

IBM,

2808

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

Polaris,

2466

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 9175

Un-Answered Questions { Oracle }

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3049

What is the difference between a hot backup and a cold backup in oracle?

1013

How a tablespace is related to data files?

1105

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1977

How does Oracle guarantee data integrity of data changes?

2382

What is tkprof?

How to sort output in descending order in oracle?

1040

What is translate in oracle?

1093

What happens if you lost a data file?

1034

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1030

What is query image?

979

Explain the use of dde package in d2k.

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

2466

Can you create a synonym without having a table?

1038

What are the main components of an oracle rac system?

For More Un-Answered { Oracle } Questions Click Here