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 4664

What is meant by redo log buffer ?

3 6976

What is the role of PCTFREE parameter is Storage clause ?

2 5898

What is use of Rollback Segments In Database ?

4 6578

What is a Rollback segment entry ?

TCS,

3 7919

How will you monitor the space allocation ?

3 8381

What is meant by recursive hints ?

1 4504

What is the OPTIMAL parameter ?

TCS,

1 6104

What is Database Buffers ?

4 11453

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

IBM,

1 4973

Can a formula column be obtained through a select statement?

TCS,

1 8193

What is the use of place holder column?

1 7146

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

1 4591

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

1 4940

What is the use of break group?

1 4254

Un-Answered Questions { Oracle }

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

545

What is ASM (Automatic Storage Management) in Oracle?

1142

Why more redos are generated when the oracle database is in begin backup mode?

1080

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1029

Which date function is used to find the difference between two dates?

534

What are the knowledge modules types?

552

Explain the use of constraints option in exp command.

1000

What is the exact use of Collections?

2104

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

979

What is the use solutions?

559

suppose having unique and duplicate but I want to load unique record one table and duplicates one table?

712

What is Undo Management Advisor in Oracle?

1046

How to delete a column in an existing table in oracle?

1020

What should a dba know?

490

How would you best determine why your MVIEW couldnt FAST REFRESH?

1847

For More Un-Answered { Oracle } Questions Click Here