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

How can you Enforce Referential Integrity in snapshots ?

1 2900

What is a SNAPSHOT ?

1 2770

What is a shared pool?

1 2470

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

1 2745

Give the Types of modules in a form?

1 2740

What is PL/SQL ?

3 2046

What are advantages fo Stored Procedures?

1 3227

What are the uses of Database Trigger ?

1708

What is Database Trigger ?

1 3009

Can the default values be assigned to actual parameters?

1 2696

Can a primary key contain more than one columns?

2 3749

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

1 3396

Differentiate between TRUNCATE and DELETE?

2 3035

What is difference between a formal and an actual parameter?

1 2676

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

1 2661

Un-Answered Questions { Oracle }

What is Reduced List of Values?

2160

Explain an integrity constrains?

1139

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2260

What are the knowledge modules types?

586

What are the varoius components of physical database structure of oracle database?

1002

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2108

What is a subquery?

1117

How to put more than 1000 values into an oracle in clause?

1029

How to experiment a data lock in oracle?

1052

Step by step explain for the Flat file?

665

What is the use of oracle?

1027

What is the usage of analyze command in oracle?

1089

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2326

What is oracle in java?

961

How do you run ms_batch file in forms?

For More Un-Answered { Oracle } Questions Click Here