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 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 }

How to change system global area (sga) in oracle?

971

What is the difference between instance recovery and crash recovery?

What are the numeric comparison operations?

1068

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1052

What is SQL Tuning Advisor in Oracle?

1122

What is a user account in oracle?

1074

What is an oracle transaction?

1072

Tell me about standby database? What should we watch out for?

510

What do you mean by dba?

533

What is the difference between bind and lexical parameter?

1026

explain what is odi?why is it different from the other etl tools.

562

Whats the benefit of dbms_stats over analyze?

1955

In the oracle version 9.3.0.5.0, what does each number shows?

1244

What is oracle in java?

923

What is the sequence of firing in form level trigger?

For More Un-Answered { Oracle } Questions Click Here