Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle Interview Questions

Questions Answers Views Company eMail

What is oracle d2k? Why we use it?

Why we use oracle d2k?

What are the new features in release 11i?

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

Do you know table based value sets?

What are materialized views & where do we use them? What is a materialized view?

What is a staging area? Do we need it?

When do you analyze the tables?

Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?

What are parameter files? Where do we use them?

What is the purpose of a staging area?

Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?

What are active transformation / passive transformations?

I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

What are the various tools? - Name a few?

Un-Answered Questions { Oracle }

What is format trigger?

2070

What are materialized views & where do we use them? What is a materialized view log?

Explain the oracle real application clusters architecture?

Explain index?

1258

What is split brain syndrome in rac?

What is truncate oracle?

971

How to get execution statistics reports on query statements?

1091

What is the difference between a primary key & a unique key?

1089

What is a trigger and what are its types in oracle?

1070

What do you understand by the term 'normalization'? Explain the various modes of normalization?

556

How to do clean up if create database failed?

1027

what is reindexing?

1675

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

587

Difference between lexical and bind varible.

How is clustered index different from non-clustered index?

For More Un-Answered { Oracle } Questions Click Here