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

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

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 }

In oracle there is column command, how will you explain that?

1145

what is meant by magic query

2240

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2352

What are record groups ? Explain the types of record group.

Explain prerequisites and post activities of oracle database installation

2185

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

2002

How to define a data source name (dsn) in odbc manager?

1085

What do you mean by merge in oracle and how can you merge two tables?

1011

How to drop a stored function?

1187

What are the uses of Database Trigger ?

1792

What is system global area (sga) in oracle?

1041

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1324

Name the various constraints used in oracle?

1082

Explain the use of full option in exp command.

1179

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2129

For More Un-Answered { Oracle } Questions Click Here