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 4731

What are the different type of Segments ?

2 4698

What is a Data Segment ?

3 6165

What is an Index Segment ?

2 4771

What is Rollback Segment ?

3 6303

What are the uses of Rollback Segment ?

2 5840

What is a Temporary Segment ?

2 5203

What is a Data File ?

1 4634

What are the Characteristics of Data Files ?

3 6627

What is a Redo Log ?

3 7425

What is the function of Redo Log ?

1 5167

What is the use of Redo Log Information ?

2 6636

What does a Control file Contain ?

2 8292

What is the use of Control File ?

3 6570

What is a Data Dictionary ?

5 8313

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain the use of indexes option in imp command.

1179

Explain how you would restore a database using RMAN to Point in Time?

2144

How to update values on multiple rows in oracle?

1034

What privilege is needed for a user to insert rows to tables in another schema?

1015

What is oracle open database communication (odbc)?

1028

Does oracle partitioning improve performance?

992

What do you know about normalization? Explain in detail?

951

How many memory layers are in the oracle shared pool?

1181

What is a cognitive schema?

964

what are actual and formal parameters?

1104

How to create a stored procedure in oracle?

1103

What are a query and state the different types of queries and their uses?

1015

Is there a function to split a string in plsql?

1056

How to count groups returned with the group by clause in oracle?

1076

What is a subquery in oracle?

1109

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