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 a snapshot log?

1003

Can objects of the same schema reside in different tablespace?

1061

How index is implemented in oracle database?

1006

How are extents allocated to a segment?

1125

How does one create a new database?

589

What database block size should I use?

732

How does one coalesce free space?

548

What are the attributes of cursor?

1054

What are set operators?

1082

What is blob datatype?

1128

What are a cluster and non-cluster index?

1018

How do we create privileges in oracle?

1045

State and explain about oracle instance?

991

What is the data type of dual table?

993

What is using clause and give example?

1038

Un-Answered Questions { Oracle }

What is CDC and explain complete CDC process flow?

592

Does oracle charge for java?

1054

What is an index associated with a constraint?

1040

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

550

what is difference between group above and group left report

3819

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

How to store only time; not date and time?

1018

Explain what are synonyms used for?

1034

What are the conditions kept in mind while connecting the oracle rac with the network?

What is control file used for?

1207

What is a sub query? What are its various types?

1177

Point out the difference between user tables and data dictionary?

981

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1424

How many anonymous blocks can be defined?

1184

How to generate query output in html format?

1117

For More Un-Answered { Oracle } Questions Click Here