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,

542

does odi support web services?

Hexaware, Seventhsense Technologies,

533

how to handle exceptions?

Hexaware, Seventhsense Technologies,

571

how to implement data validations?

Hexaware, Seventhsense Technologies,

544

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

Hexaware, Seventhsense Technologies,

647

how to remove the duplicate in odi?

Hexaware, Seventhsense Technologies,

583

how to write the sub-queries in odi?

Hexaware, Seventhsense Technologies,

640

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

Hexaware, Seventhsense Technologies,

572

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

Hexaware, Seventhsense Technologies,

712

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

Hexaware, Seventhsense Technologies,

757

what are knowledge modules?

Hexaware, Seventhsense Technologies,

587

what is load plans and types of load plans?

Hexaware, Seventhsense Technologies,

566

what is profile in odi?

Hexaware, Seventhsense Technologies,

610

what is the odi console?

Hexaware, Seventhsense Technologies,

591

what systems can odi extract and load data into?

Hexaware, Seventhsense Technologies,

538

Un-Answered Questions { Oracle }

What is SKM and when we will use this SKM?

615

How to load a large xml file?

1009

What happens if the update subquery returns multiple rows?

1059

What is a recovery catalog?

How to define a data source name (dsn) in odbc manager?

976

Explain the types of exception?

1091

What is the usage of control file in oracle?

1032

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

2316

How to load excel data sheet to oracle database

979

Can we connect to ORACLE db using Windows Authentication?

1195

How to find the duplicate rows count from employees table in oracle?

1050

Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

WHAT IS ecc 6.0

2110

Why use resource manager in Oracle?

1062

What are functions of dba?

515

For More Un-Answered { Oracle } Questions Click Here