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,

573

What are the IKM types?

Virtuas,

677

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

Hexaware,

700

When you use CKM?

Virtuas,

582

What is variable and how many types of variable?

Tech Mahindra,

586

Which profile required to access Models in Designer tool?

Accenture,

707

Differences between package and loadplans?

Accenture,

590

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,

687

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

Accenture,

633

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 the usage of control file in oracle?

1088

Is the After report trigger fired if the report execution fails ?

2915

How to create a table in a specific tablespace?

976

How does the on-delete-cascade statement work?

1104

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

638

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1988

What are the various benefits of using rac architecture?

master table and child table performances and comparisons in Oracle ?

2138

What are a query and state the different types of queries and their uses?

1015

What is an oracle database?

1035

What is MTTR advisor in Oracle?

1090

What is hot backup and logical backup?

1051

what is dynamic SGA and static SGA

4417

How to create a temporary table in oracle?

1268

What is an Oracle database Partial Backup?

1159

For More Un-Answered { Oracle } Questions Click Here