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 backup in Oracle?

MCN Solutions,

962

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

MCN Solutions,

1092

Give syntax for SQL and ORACLE joins.

TCS,

1052

What is Segment Advisor in Oracle?

MCN Solutions,

1061

What is SQL Tuning Advisor in Oracle?

MCN Solutions,

1121

What is MTTR advisor in Oracle?

MCN Solutions,

1044

How many types of cluster table in Oracle?

MCN Solutions,

997

How to get the Installed Oracle Version Information ?

MCN Solutions,

1088

What is flashback in Oracle?

MCN Solutions,

975

What is the difference between PFILE and SPFILE in Oracle?

MCN Solutions,

1002

How to check database size in Oracle?

MCN Solutions,

1133

What is catalog in Oracle?

MCN Solutions,

1285

What is archive log in Oracle?

MCN Solutions,

1080

Can we connect to ORACLE db using Windows Authentication?

MCN Solutions,

1196

What is memory advisor in Oracle?

MCN Solutions,

1030

Un-Answered Questions { Oracle }

How many types of cluster table in Oracle?

997

Name the various constraints used in oracle?

980

Design database draw er diagram for a certain scenario ?

4540

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1114

What is an oracle database table?

968

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

516

What is a parameter file in oracle?

1062

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1850

What is an Oracle SYSTEM tablespace and when is it Created?

1076

While taking hot backup (begin end backup) what will happens back end?

528

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2062

What do you mean by dba?

533

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1145

What is a synonym? What are its various types?

1053

Define oracle database

1000

For More Un-Answered { Oracle } Questions Click Here