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 4981

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

ESS,

5 7388

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

1955

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

4447

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,

2015

what is the difference between data migration and production migration.

2350

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

2070

can u give guidance abt packages of plsql

Mphasis,

2177

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

5 7300

How to define a cusotmer as a supplier in ORACLE R12

Intelligroup,

2232

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

Intelligroup,

2210

what is shared memory?

IBM,

1 4308

what is semphore explian it?

IBM,

2821

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 9208

Un-Answered Questions { Oracle }

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

605

Is it possible to insert comments into sql statements return in the data model editor ?

2570

What is an Oracle Data Dictionary?

1118

Could you please let me know the interfaces in OM / FA??

2273

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1070

What is the relation between database and instance?

648

Explain for repository?

596

what is difference between group above and group left report

3827

What are the knowledge modules types?

599

types of receipts and detail desription about recipts and tables effected by receipts?

2076

What are open_form,call_form,new_form?

Can we write dml statement in function in oracle?

1089

Name the different triggers associated with oracle forms having a master-detail relationship.

1001

What is the use of oracle?

1032

How to start a specific oracle instance?

1042

For More Un-Answered { Oracle } Questions Click Here