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

Oracle General Interview Questions

Questions Answers Views Company eMail

What is a Segment ?

1 4818

What are the different type of Segments ?

2 4789

What is a Data Segment ?

3 6286

What is an Index Segment ?

2 4870

What is Rollback Segment ?

3 6438

What are the uses of Rollback Segment ?

2 5957

What is a Temporary Segment ?

2 5290

What is a Data File ?

1 4698

What are the Characteristics of Data Files ?

3 6758

What is a Redo Log ?

3 7548

What is the function of Redo Log ?

1 5275

What is the use of Redo Log Information ?

2 6746

What does a Control file Contain ?

2 8412

What is the use of Control File ?

3 6719

What is a Data Dictionary ?

5 8515

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

what are archived logs?

2261

what is a Nested Loop join?

2175

What is sharded cluster?

1071

What is concurrency in oracle?

1059

What are the types of trigger in oracle?

1029

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1985

how to clone 9i Database on to 10g Database.

2388

What is Data Dictionary Cache in Oracle?

1244

What is an oracle data file?

1163

How to generate query output in html format?

1212

Explain the use of owner option in exp command.

1099

Is there any function in oracle similar like group_concat of mysql?

1109

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

1068

What are joins, explain all types of joins?

2364

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4234

For More Un-Answered { Oracle General } Questions Click Here