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

Oracle General (1803)
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 4816

What is meant by redo log buffer ?

3 7258

What is the role of PCTFREE parameter is Storage clause ?

2 6116

What is use of Rollback Segments In Database ?

4 6908

What is a Rollback segment entry ?

TCS,

3 8181

How will you monitor the space allocation ?

3 8637

What is meant by recursive hints ?

1 4640

What is the OPTIMAL parameter ?

TCS,

1 6279

What is Database Buffers ?

4 11835

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

IBM,

1 5150

Can a formula column be obtained through a select statement?

TCS,

1 8384

What is the use of place holder column?

1 7332

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

1 4838

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

1 5087

What is the use of break group?

1 4415

Un-Answered Questions { Oracle }

What is set verify off in oracle?

1165

How to filter out duplications in the returning rows using oracle?

1068

What is parameterized cursor in oracle?

1228

How do you bind variables in oracle?

1024

What is a cognitive schema?

1035

Difference between pre-select and pre-query

1179

Which rman command is used to create an exact replica of a database innew host?

631

How do I become a dba?

628

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1924

How to check the oracle tns settings?

1094

Have you attend the client meetings?

661

What is the difference between internal & external schema?

809

What is a dead lock in oracle?

1181

did u p prepared complex report

2054

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2264

For More Un-Answered { Oracle } Questions Click Here