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

How to define Data Block size ?

2 5577

What is Row Chaining ?

Cognizant, CTS,

3 12877

What is an Extent ?

3 6375

What is a Segment ?

1 4727

What are the different type of Segments ?

2 4695

What is a Data Segment ?

3 6157

What is an Index Segment ?

2 4764

What is Rollback Segment ?

3 6282

What are the uses of Rollback Segment ?

2 5832

What is a Temporary Segment ?

2 5193

What is a Data File ?

1 4628

What are the Characteristics of Data Files ?

3 6616

What is a Redo Log ?

3 7410

What is the function of Redo Log ?

1 5158

What is the use of Redo Log Information ?

2 6624

Un-Answered Questions { Oracle }

Where in the Oracle directory tree structure are audit traces placed?

2630

What are group functions in oracle?

1038

Mention what is the volume management techniques used in oracle rac?

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2132

What is data store? How to create data store?

631

How to build data dictionary view an new database?

1002

How are extents allocated to a segment?

1120

What is the mandatory setup in cyclecount ?

2746

What is PL/SQL ?

2050

State and explain the different types of data models?

938

When you used JKM ?

585

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

1031

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7666

What are the differences between blob and clob in oracle?

1082

how report can be generated if we have the database designed in oracle 10g?

1880

For More Un-Answered { Oracle } Questions Click Here