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 }

List the types of joins used in writing subqueries?

997

What is transaction control statement and how many types of transaction control statement in Oracle?

1156

Explain how can you use the same lov for 2 columns?

1130

What is a nested table and how is it different from a normal table?

1051

What does dba stand for in technology?

548

What is oracle analytical function?

1143

What is a cognitive schema?

964

How to use existing values in update statements using oracle?

1067

How to create a table in a specific tablespace?

976

Explain view?

1034

What kinds of responsibilities does a dba have in a database environment?

606

What is the sql query to concatenate column values from multiple rows in oracle?

1056

What is Reduced List of Values?

2165

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1193

What is the difference between pre-select and pre-query?

1219

For More Un-Answered { Oracle } Questions Click Here