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

Briefly explain what is literal? Give an example where it can be used?

988

Explain about the analyze command in oracle?

1013

Difference between cartesian join and cross join?

983

Point the difference between translate and replace?

1039

What are the major difference between truncate and delete?

1001

What is a sub query? Describe its types?

975

What is the difference between count (*), count (expression), count (distinct expression)?

973

Point out the difference between user tables and data dictionary?

945

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

923

Difference between the “verify” and “feedback” command?

1324

What do you mean by merge in oracle?

952

Describe an oracle table?

1005

What are the differences between primary key and unique key?

960

What is the difference between substr and instr?

996

Describe varray?

1011

Un-Answered Questions { Oracle }

What is the difference between truncate & delete command?

1146

Mention what are the main components of an oracle rac system?

What is a production dba?

562

What is package and main advantages?

564

What is Restricted Mode of Instance Startup in Oracle?

1160

How can I create database in oracle?

973

Can a formula column be obtained through a select statement ?

2281

What is the exact use of Collections?

2108

How to convert the oracle reports to excel sheet from oracle?

How to create a new view in oracle?

1025

Explain alias?

1097

What is oracle used for?

987

How many categories of data types?

954

What are the general rules on data consistency?

968

please explain.. DB architecture ...

1986

For More Un-Answered { Oracle } Questions Click Here