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 4966

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

ESS,

5 7360

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

1947

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

4446

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,

2008

what is the difference between data migration and production migration.

2346

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

2068

can u give guidance abt packages of plsql

Mphasis,

2174

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

5 7279

How to define a cusotmer as a supplier in ORACLE R12

Intelligroup,

2230

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

Intelligroup,

2209

what is shared memory?

IBM,

1 4297

what is semphore explian it?

IBM,

2815

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

Polaris,

2472

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 9190

Un-Answered Questions { Oracle }

How is clustered database important in oracle rac architecture?

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

604

Explain integrity constraints?

1102

What do you understand by database schema and what does it hold?

1230

Explain the wait events in statspack report 'db sequential real'?

636

Please explain oracle data types with examples?

1068

What do you understand by lov?

1034

How to use values from other tables in update statements using oracle?

1079

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2116

How to use "startup" command to start default instance?

1031

What do you mean by oracle dba?

570

What is an Oracle index?

1655

What are property classes?

Components of Oracle Data Integrator?

548

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

566

For More Un-Answered { Oracle } Questions Click Here