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

List the Optional Flexible Architecture (OFA) of Oracle database ?

1 4729

What is meant by redo log buffer ?

3 7095

What is the role of PCTFREE parameter is Storage clause ?

2 6000

What is use of Rollback Segments In Database ?

4 6715

What is a Rollback segment entry ?

TCS,

3 8040

How will you monitor the space allocation ?

3 8492

What is meant by recursive hints ?

1 4564

What is the OPTIMAL parameter ?

TCS,

1 6166

What is Database Buffers ?

4 11621

How free extents are managed in Ver 6.0 and Ver 7.0 ?

IBM,

1 5050

Can a formula column be obtained through a select statement?

TCS,

1 8279

What is the use of place holder column?

1 7229

How can a break order be created on a column in an existing group?

1 4696

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

1 5007

What is the use of break group?

1 4325

Un-Answered Questions { Oracle }

What do you mean by oracle dba?

566

How do I connect to oracle database?

1108

how to clone 9i Database on to 10g Database.

2332

What is the order of defining local variables and sub procedures/functions?

1054

How to convert character types to numeric types?

1115

What is clustered table in Oracle?

1182

How to use null as conditions in oracle?

1073

How to create a stored program unit?

1216

Are you familiar with user exits in reports?

What is an oracle?

1003

How can I introduce multiple conditions in like operator?

982

How would you change old and new values in an insert, delete and update triggers?

1012

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1906

When should you increase copy latches? What parameters control copy latches?

568

query optmization techniques and quwry analyser+projects+ppts

2410

For More Un-Answered { Oracle } Questions Click Here