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 }

How to check the oracle tns settings?

1047

Explain the wait events in statspack report 'enqueue'?

577

What is meant by joins?

1058

Explain the hardware architecture used in oracle rac?

How to estimate disk space needed for an export job?

1049

What is the relationship among database, tablespace and data file?

989

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1043

What is the data pump export utility?

1081

What are the key characteristics of rac or why to use rac?

Discuss row chaining, how does it happen? How can you reduce it?

542

Can we use bind variables in oracle stored procedure?

949

Can a parameter be passed to a cursor?

1124

What is varray?

1135

How to use an explicit cursor without open statements?

1055

When configuring sqlnet on the server what files must be set up?

636

For More Un-Answered { Oracle } Questions Click Here