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

Which of the above methods is the faster method?

1 4471

What is the frame & repeating frame?

1 6126

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

1 3632

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

1 3386

List the editors availables in forms 4.0?

1 3835

What are the menu items that oracle forms 4.0 supports?

1 3995

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

1 3719

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

1 3819

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

2 5040

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

1 4097

Explain about horizontal, Vertical tool bar canvas views?

1 5058

What are modal windows?

1 3901

What are the different modals of windows?

1 4737

What is an Lov?

2 5345

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

1 3716

Un-Answered Questions { Oracle }

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2322

What is call form stack?

Can multiple columns be used in group by in oracle?

988

Give syntax for SQL and ORACLE joins.

1092

What is the difference between post-database commit and post-form commit?

1198

what are basic modules required to implement oracle application in any oraganisation?

2207

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2827

Point out the difference between user tables and data dictionary?

982

what is load plans and types of load plans?

614

What do you understand by the term 'system change number (scn)'?

582

What are privileges and grants?

1067

How to use group functions in the select clause using oracle?

1072

What is a connect identifier?

1039

How to save query output to a local file?

1026

How to define an oracle sub procedure?

1145

For More Un-Answered { Oracle } Questions Click Here