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

Which of the above methods is the faster method?

1 4559

What is the frame & repeating frame?

1 6215

What buil-in routines are used to display editor dynamicaly?

1 3709

What is the main difference between Reports 2.0 & Reports 2.5?

1 3457

List the editors availables in forms 4.0?

1 3898

What are the menu items that oracle forms 4.0 supports?

1 4092

How is link tool operation different between reports 2 & 2.5?

1 3786

The join defined by the default data link is an outer join yes or no?

1 3898

How do you pass the parameters from one form to another form?

2 5156

Do user parameters appear in the data modal editor in 2.5?

1 4181

Explain about horizontal, Vertical tool bar canvas views?

1 5155

What are modal windows?

1 3972

What are the different modals of windows?

1 4845

What is an Lov?

2 5456

Is it possible to split the printpreviewer into more than one region?

1 3785

Un-Answered Questions { Oracle }

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

680

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

828

What are the various configuration files that are used by oracle forms?

1076

What is the difference between pre-select and pre-query?

1307

How to pass a cursor variable to a procedure?

1160

How remove data files before opening a database?

1135

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1072

What is oracle full backup?

617

How to select an oracle system id (sid)?

1125

Which process writes data from data files to database buffer cache?

643

What is a synonym? What are its various types?

1179

How does Oracle guarantee data integrity of data changes?

2460

What is the difference between substr & instr functions?

1297

What's dateware house and what's clustor with practicle example

2238

What is a trigger and what are its types?

1332

For More Un-Answered { Oracle } Questions Click Here