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 5495

What is Row Chaining ?

Cognizant, CTS,

3 12767

What is an Extent ?

3 6256

What is a Segment ?

1 4658

What are the different type of Segments ?

2 4588

What is a Data Segment ?

3 6066

What is an Index Segment ?

2 4679

What is Rollback Segment ?

3 6180

What are the uses of Rollback Segment ?

2 5742

What is a Temporary Segment ?

2 5119

What is a Data File ?

1 4571

What are the Characteristics of Data Files ?

3 6489

What is a Redo Log ?

3 7323

What is the function of Redo Log ?

1 5096

What is the use of Redo Log Information ?

2 6509

Un-Answered Questions { Oracle }

How to load data from external tables to regular tables?

1010

Explain what are the uses of rollback segment?

975

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

519

Hi Can any one tell me what are the API's used in requisition import.

1891

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

1032

Explain integrity constraint?

1126

Give the different types of rollback segments.

987

what is difference between inner join & nested query or subqueries

2987

how do u compile a form i.e .fmb file in Unix or in dos

4526

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4403

What is the difference between a user and a schema in oracle?

1000

What is oracle d2k? Why we use it?

master table and child table performances and comparisons in Oracle ?

2090

Mention what are the key characteristics of rac or why to use rac?

How to create id with auto_increment on oracle?

952

For More Un-Answered { Oracle } Questions Click Here