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

How can you Enforce Referential Integrity in snapshots ?

1 3004

What is a SNAPSHOT ?

1 2867

What is a shared pool?

1 2544

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

1 2831

Give the Types of modules in a form?

1 2880

What is PL/SQL ?

3 2222

What are advantages fo Stored Procedures?

1 3319

What are the uses of Database Trigger ?

1790

What is Database Trigger ?

1 3125

Can the default values be assigned to actual parameters?

1 2780

Can a primary key contain more than one columns?

2 3863

What is an UTL_FILE.What are different procedures and functions associated with it?

1 3496

Differentiate between TRUNCATE and DELETE?

2 3138

What is difference between a formal and an actual parameter?

1 2759

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 2735

Un-Answered Questions { Oracle }

What is ceil and floor in oracle?

1124

In which language oracle has been developed?

1139

What is the dba role in oracle?

628

You see multiple extents in the temporary tablespace. Is this a problem?

634

Mention what is the volume management techniques used in oracle rac?

What is the difference between Delete, Truncate and Drop in Oracle?

1187

What is a scenario in odi?

631

What are the set operators union, union all, minus & intersect meant to do?

1038

Explain the use of Merge statement in oracle 11g

1083

What is dba software?

696

how to replace not in with not exist?

3806

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1194

What is an Oracle Data Segment?

1100

what is the difference between data migration and production migration.

2403

Explain user account with reference to oracle.

1031

For More Un-Answered { Oracle } Questions Click Here