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

Explain about achiever in sql?

985

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

960

What are temporal data types in oracle?

1083

What is a relational database management system?

1080

What is difference between cartesian join and cross join?

1034

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

1035

Are truncate and delete commands same? If so why?

1093

How do we get field details of a table?

942

What is varray?

1055

What is a cursor variable?

1062

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

998

How do we display rows from the table without duplicates?

939

What are the differences between lov and list item?

1010

How do we represent comments in oracle?

1008

What do you mean by group by clause?

995

Un-Answered Questions { Oracle }

How do you generate file output from sql?

573

How to create a table index in oracle?

1094

what is reindexing?

1620

What is the use of aggregate functions in oracle?

988

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2426

What is a static data dictionary in oracle?

1046

What are the predefined tablespaces in a database?

1022

What is merge statement used for?

983

What is dump destination? What are bdump, cdump and udump?

515

did u p prepared complex report

1959

Explain the use of consistent option in exp command.

994

What is the mandatory setup in cyclecount ?

2708

Is there any function in oracle similar like group_concat of mysql?

1005

Please explain oracle data types with examples?

1009

What is an explain plan and how does it help in optimizing the sql query?

For More Un-Answered { Oracle } Questions Click Here