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,

647

What are the constraints are used in Ur project?

Tech Mahindra,

554

What is Journalization and why we are using in ODI?

Accenture,

578

What are the IKM types?

Virtuas,

682

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

Hexaware,

703

When you use CKM?

Virtuas,

588

What is variable and how many types of variable?

Tech Mahindra,

591

Which profile required to access Models in Designer tool?

Accenture,

711

Differences between package and loadplans?

Accenture,

598

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

TCS,

623

What are the types of profiles in ODI?

Accenture,

597

Difference between Row Id and Row Num?

TCS,

694

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

Accenture,

635

How to load data from multiple files to single target?

Accenture,

567

What is the load plans in odi?

TCS,

637

Un-Answered Questions { Oracle }

Can we write dml statement in function in oracle?

1089

What is the relationship among database, tablespace and data file?

993

what is normalisation?what are its uses?

2278

How to define an oracle cursor variable?

1035

What are parameter files? Where do we use them?

Explain the truncate in oracle?

971

How can I combine multiple rows into a comma-delimited list in oracle?

1062

What is the importance of batch source set up in ar? : oracle accounts receivable

1267

How to get / select the nth row from the table?

What is a production dba?

611

How many types of tables are there in oracle?

1062

What is java oracle used for?

1030

Difference between varchar and varchar2 data types?

1190

What are the various types of snapshots ?

1032

What is a table index in oracle?

1132

For More Un-Answered { Oracle } Questions Click Here