Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1037

What is background process in Oracle?

1108

What is ASM (Automatic Storage Management) in Oracle?

1204

How many types of table in Oracle?

1131

What is Java Pool in Oracle?

1180

How many types of synonyms in Oracle?

1134

What is materialized view in Oracle?

1078

What is Trigger in Oracle?

1183

What is SQL access advisor in Oracle?

1199

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1157

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1114

What is partitioned table in Oracle?

1197

What is recovery manager in Oracle?

1062

What is BBED in Oracle?

1165

What is ADDM Advisor in Oracle?

1188

Un-Answered Questions { Oracle }

In the oracle version 9.3.0.5.0, what does each number shows?

1307

What is the recommended interval at which to run statspack snapshots, and why?

2923

What is the sequence of firing in form level trigger?

1

What is a parameter file in oracle?

1140

Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

592

Explain the difference between replace() and translate() functions in oracle?

1044

Is Odi used in oracle products?

672

Explain the different normalization forms?

1112

What is a server parameter file in oracle?

1063

What do you understand by oracle forms and why are they required?

1023

How to update a table row with a record?

1018

what's query optimization and without use of IN AND Exist can we get another way data from query

2148

How to upsert (update or insert into a table)?

1006

What is a user account in oracle?

1129

Name the three major set of files on disk that compose a database in Oracle?

1127

For More Un-Answered { Oracle } Questions Click Here