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,

582

does odi support web services?

Hexaware, Seventhsense Technologies,

560

how to handle exceptions?

Hexaware, Seventhsense Technologies,

603

how to implement data validations?

Hexaware, Seventhsense Technologies,

590

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

Hexaware, Seventhsense Technologies,

687

how to remove the duplicate in odi?

Hexaware, Seventhsense Technologies,

627

how to write the sub-queries in odi?

Hexaware, Seventhsense Technologies,

704

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,

748

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

Hexaware, Seventhsense Technologies,

791

what are knowledge modules?

Hexaware, Seventhsense Technologies,

638

what is load plans and types of load plans?

Hexaware, Seventhsense Technologies,

614

what is profile in odi?

Hexaware, Seventhsense Technologies,

649

what is the odi console?

Hexaware, Seventhsense Technologies,

628

what systems can odi extract and load data into?

Hexaware, Seventhsense Technologies,

592

Un-Answered Questions { Oracle }

How does Oracle guarantee data integrity of data changes?

2388

What is the difference between substr & instr functions?

1228

how to make an oracle object

2359

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

979

How would you go about verifying the network name that the local_listener is currently using?

2049

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

689

How to check your oracle database 10g xe installation?

986

How to export data with a field delimiter?

1039

What are the different pseudo commands? Explain in general?

1080

How can Oracle users be audited?

1115

What is oracle datasource?

984

Mention what is new feature in oracle asm 12c?

How to download oracle database 10g xe?

1018

How I can use srw.run_report in reports6i?

Explain what are the advantages of views?

1069

For More Un-Answered { Oracle } Questions Click Here