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

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

when do u go for hash partitioning?

1 3840

what is RAID technology?which is better RAID 0+1 OR RAID 5?

CSC,

2 16995

how do get database name at sql prompt?

3 7220

what is the scenario where you take the database to NoArchivelog mode?

2380

does the query needs a hint to access a materialized view?

1910

what is analyze command ? what kind of statistics does it generate?

2 5108

how do u know the total no of rows in a table?

6 9278

what are archived logs?

2264

what are bitmap indexes? How does they work?

2311

what are the database links ?

2 4894

does the query needs a hint to access a materialized view?

1 3949

what are different types of locks?

6 8830

master table and child table performances and comparisons in Oracle ?

2200

what are the different types of cursors? explain?

4 10437

what are different types of deletes?

1 3872

Un-Answered Questions { Oracle }

How many memory layers are in the oracle shared pool?

1256

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

Explain how to close periods in ar. : oracle accounts receivable

1381

What are the benefits of oracle rac?

What is key.next.item trigger?

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2157

key flexfield structure

2235

Difference between Row Id and Row Num?

732

how to write customizations in po

1660

What do you mean by dba?

611

How to build data dictionary view an new database?

1054

What is an oracle cursor variable?

1133

What are the attributes that are found in a cursor?

1125

What are the advantages of oracle 12c?

1239

How to drop an existing view in oracle?

995

For More Un-Answered { Oracle } Questions Click Here