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 4655

What is meant by redo log buffer ?

3 6960

What is the role of PCTFREE parameter is Storage clause ?

2 5878

What is use of Rollback Segments In Database ?

4 6550

What is a Rollback segment entry ?

TCS,

3 7898

How will you monitor the space allocation ?

3 8361

What is meant by recursive hints ?

1 4497

What is the OPTIMAL parameter ?

TCS,

1 6094

What is Database Buffers ?

4 11429

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

IBM,

1 4961

Can a formula column be obtained through a select statement?

TCS,

1 8181

What is the use of place holder column?

1 7129

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

1 4568

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

1 4923

What is the use of break group?

1 4239

Un-Answered Questions { Oracle }

List out the components of logical database structure of oracle database.

984

how to write the procedures in odi?

674

What is connection pool in oracle?

927

How to install oracle odbc drivers?

1039

Why are recursive relationships bad? How do you resolve them?

526

What is the difference between a primary key & a unique key?

1037

What are set operators?

1029

What are materialized views & where do we use them? What is a materialized view log?

Does oracle database need java?

941

How to define a data field as not null?

1060

How can I combine multiple rows into a comma-delimited list in oracle?

999

What is an oracle database schema?

1073

What is the data quality?

578

What are privileges and grants?

1002

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2200

For More Un-Answered { Oracle } Questions Click Here