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

What is table partitioning?

What is an explain plan and how does it help in optimizing the sql query?

What is a recovery catalog?

How is incremental backup different from differential backup?

What do you understand by row chaining?

What is tkprof and how can we use it?

How can a single instance environment be converted into rac environment and how will they be different?

What do we mean by hot backup & cold backup and how are they different?

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

Why do we use materialized view instead of table or views?

How can we use tkprof?

How would you identify the shared_pool_size parameter that needs to be adjusted?

How can we collect the statistics of different database objects?

What do you understand from cache fusion?

Why do we need to rebuild indexes?

Un-Answered Questions { Oracle }

What is a synonym? What are its various types?

1055

Can we invoke one form from another in a multi-forms application?

1094

Is oracle an open source?

1033

What are a collation and state the different types of collation sensitivity?

1114

How can I introduce multiple conditions in like operator?

934

List five most important parameter in 9i affecting performance?

519

What is a connect identifier?

994

How to use "out" parameter properly?

1036

How to use group functions in the select clause using oracle?

1035

What is variable? What is Flow of variable?

574

What is an oracle report?

1001

What are the constraints are used in Ur project?

514

What are group functions in oracle?

990

What are set operators?

1036

What happens if you use a wrong connect identifier?

997

For More Un-Answered { Oracle } Questions Click Here