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

can we implement package in package?

Hexaware, Seventhsense Technologies,

578

does odi support web services?

Hexaware, Seventhsense Technologies,

558

how to handle exceptions?

Hexaware, Seventhsense Technologies,

601

how to implement data validations?

Hexaware, Seventhsense Technologies,

587

how to implement the logic in procedures if the source side data deleted that will reflect the target side table?

Hexaware, Seventhsense Technologies,

681

how to remove the duplicate in odi?

Hexaware, Seventhsense Technologies,

625

how to write the sub-queries in odi?

Hexaware, Seventhsense Technologies,

701

in the package one interface got failed how to know which interface got failed if we no access to operator?

Hexaware, Seventhsense Technologies,

608

suppose having unique and duplicate but I want to load unique record one table and duplicates one table?

Hexaware, Seventhsense Technologies,

740

suppose I having 6 interfaces and running the interface 3 rd one failed how to run remaining interfaces?

Hexaware, Seventhsense Technologies,

789

what are knowledge modules?

Hexaware, Seventhsense Technologies,

635

what is load plans and types of load plans?

Hexaware, Seventhsense Technologies,

606

what is profile in odi?

Hexaware, Seventhsense Technologies,

645

what is the odi console?

Hexaware, Seventhsense Technologies,

623

what systems can odi extract and load data into?

Hexaware, Seventhsense Technologies,

584

Un-Answered Questions { Oracle }

In what script is snap$ created? In what script is the scott/tiger schema created?

2708

What is a table index?

1089

What is the disk migration? what is the steps involved in oracle disk migration?

1218

Explain do view contain data?

998

What is the use of lockboxes? : oracle accounts receivable

1200

What is J2EE Agent and port number?

610

How view is different from a table?

1026

How does one create a new database?

586

How do I spool to a csv formatted file using sqlplus?

1026

What happens if you lost a data file?

1034

What is an oracle table?

981

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1992

what are bind variables?

1083

What is iapxtb structure? Explain its importance

Please explain joins in oracle?

1059

For More Un-Answered { Oracle } Questions Click Here