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

What is memo?

Accenture,

637

What are the constraints are used in Ur project?

Tech Mahindra,

550

What is Journalization and why we are using in ODI?

Accenture,

571

What are the IKM types?

Virtuas,

676

what we specify the in XML data server and parameters for to connect to xml file?

Hexaware,

700

When you use CKM?

Virtuas,

580

What is variable and how many types of variable?

Tech Mahindra,

586

Which profile required to access Models in Designer tool?

Accenture,

706

Differences between package and loadplans?

Accenture,

589

How many types of knowledge Modules? Where are used in km?

TCS,

621

What are the types of profiles in ODI?

Accenture,

595

Difference between Row Id and Row Num?

TCS,

686

What is an agent and What are the types of agents?

Accenture,

632

How to load data from multiple files to single target?

Accenture,

563

What is the load plans in odi?

TCS,

633

Un-Answered Questions { Oracle }

What is Sequences?

630

What are the different types of synonyms?

1140

What are advantages of dateset in datastage?

2263

What are the differences between date and timestamp in oracle?

1046

What are the various types of snapshots ?

1027

What is transport network substrate (tns) in oracle?

1045

Can group functions be mixed with non-group selection fields?

1020

What are the constraints are used in Ur project?

550

How to open and close an explicit cursor in oracle?

1058

Difference between cartesian join and cross join?

1039

What is private procedure oracle?

1009

what are basic modules required to implement oracle application in any oraganisation?

2207

How to send the emails for odi?

697

What are the differences between blob and clob in oracle?

1089

What is oracle thin client?

1023

For More Un-Answered { Oracle } Questions Click Here