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

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 path setting for dll?

Explain the purpose of forms_ddl.

Can multiple columns be used in group by in oracle?

988

What is a Garbage Collection? and what is full recursive Garbage collection?

2902

How to do paging with oracle?

999

What do you understand by redo log file mirroring?

What is the implicit cursor in oracle?

1105

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2023

Is there a combination of "like" and "in" in sql?

1065

Which profile required to access Models in Designer tool?

707

What are functions of dba?

551

What is a synonym? What are its various types?

1110

What is the simplest tool to run commands on oracle servers?

1009

What is the fastest query method to fetch data from the table?

1361

Explain coalesce function?

1202

For More Un-Answered { Oracle } Questions Click Here