Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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,

650

does odi support web services?

Hexaware, Seventhsense Technologies,

619

how to handle exceptions?

Hexaware, Seventhsense Technologies,

657

how to implement data validations?

Hexaware, Seventhsense Technologies,

643

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

Hexaware, Seventhsense Technologies,

741

how to remove the duplicate in odi?

Hexaware, Seventhsense Technologies,

668

how to write the sub-queries in odi?

Hexaware, Seventhsense Technologies,

750

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

Hexaware, Seventhsense Technologies,

642

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

Hexaware, Seventhsense Technologies,

794

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

Hexaware, Seventhsense Technologies,

844

what are knowledge modules?

Hexaware, Seventhsense Technologies,

675

what is load plans and types of load plans?

Hexaware, Seventhsense Technologies,

673

what is profile in odi?

Hexaware, Seventhsense Technologies,

702

what is the odi console?

Hexaware, Seventhsense Technologies,

689

what systems can odi extract and load data into?

Hexaware, Seventhsense Technologies,

659

Un-Answered Questions { Oracle }

Why oracle is used?

1114

What is the order of defining local variables and sub procedures/functions?

1117

Give the constructs of a package, function or a procedure.

1098

Is insert autocommit in oracle?

1134

Point out the difference between user tables and data dictionary?

1039

What is oracle sid?

1007

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1990

what are bind variables?

1149

What is a recovery catalog?

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

2035

How to start a new transaction in oracle?

1138

What is a proxy class?

1109

What is the data quality?

672

What are the various tools? - Name a few?

How do I limit the number of rows returned by an oracle query after ordering?

1228

For More Un-Answered { Oracle } Questions Click Here