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

Explain about achiever in sql?

1088

What are a query and state the different types of queries and their uses?

1068

What are temporal data types in oracle?

1171

What is a relational database management system?

1175

What is difference between cartesian join and cross join?

1163

Explain the difference between a procedure and a function? What do you understand by those terms?

1136

Are truncate and delete commands same? If so why?

1207

How do we get field details of a table?

1031

What is varray?

1202

What is a cursor variable?

1218

Can we store pictures in the database and if so, how it can be done?

1094

How do we display rows from the table without duplicates?

1019

What are the differences between lov and list item?

1150

How do we represent comments in oracle?

1100

What do you mean by group by clause?

1097

Un-Answered Questions { Oracle }

What do you mean by oracle database?

608

How do you analyze table partition using oracle provided package?

559

Is oracle an operator?

989

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

Can group functions be used in the order by clause in oracle?

1051

In topology manager where the data are stored?

729

from where do u receive the information to develop report

2058

What is a scenario in odi?

631

State the difference between a primary key and foreign key?

999

Can you list down the different components of physical and logical database structure?

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

What is SQL access advisor in Oracle?

1232

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1894

What is the exact use of Collections?

2197

How can you determine the space left in a file system?

692

For More Un-Answered { Oracle } Questions Click Here