Oracle Interview Questions
Questions Answers Views Company eMail

How to define Data Block size ?

2 4654

What is Row Chaining ?

Cognizant, CTS,

3 10954

What is an Extent ?

3 5209

What is a Segment ?

1 4057

What are the different type of Segments ?

2 3750

What is a Data Segment ?

3 4902

What is an Index Segment ?

2 3798

What is Rollback Segment ?

3 4486

What are the uses of Rollback Segment ?

2 4733

What is a Temporary Segment ?

2 4239

What is a Data File ?

1 3832

What are the Characteristics of Data Files ?

3 5275

What is a Redo Log ?

3 5745

What is the function of Redo Log ?

1 4355

What is the use of Redo Log Information ?

2 5243


Un-Answered Questions { Oracle }

How do you recover a lost control file?

1


How you find which is the latest record in SCD type2 transformation?

293


What is bulk load in oracle?

578


Difference between pre-select and pre-query

560


a text item is there what r the different types of triggers associated with it

1497






Differentiate between pre-select and pre-query?

603


What are the requirements of simple database?

276


How to count duplicated values in a column in oracle?

537


You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

299


Explain database link?

649


What do you mean by Oracle MEDIA RECOVERY?

715


What is a database instance?

275


Differentiate between translate and replace?

612


How to convert character types to numeric types?

564


What is the difference between sharding and replication?

467