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 4234

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

ESS,

5 6180

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

1569

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

4080

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,

1612

what is the difference between data migration and production migration.

1906

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

1669

can u give guidance abt packages of plsql

Mphasis,

1736

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

5 5865

How to define a cusotmer as a supplier in ORACLE R12

Intelligroup,

1838

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

Intelligroup,

1795

what is shared memory?

IBM,

1 3615

what is semphore explian it?

IBM,

2346

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

Polaris,

2109

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 8128


Un-Answered Questions { Oracle }

if you ctreate table identity

1974


what are the API of GL,PO,AP

1888


What are the roles of dba?

708


suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

1691


What is the sequence of firing in form level trigger?

1






what is dynamic SGA and static SGA

3946


How to recover a dropped table in oracle?

687


What is private procedure oracle?

604


What is an Oracle database Partial Backup?

790


If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

375


Why does oracle 9i treat an empty string as null?

619


Explain the features of oracle?

689


How to create a table index in oracle?

750


What is the purpose of tables, private synonyms and public synonyms in Oracle?

688


Mention what are the main components of an oracle rac system?

1