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

What is database schema?

Infosys,

4 16508

What is Reduced List of Values?

iFlex,

2248

What is Hash Index?

1 5988

There are Two pl/sql Libraries Lib1,Lib2 are attached to a form and these two libraries contains functions with same name fun1 (i,e lib1 have a function fun1 and lib2 also have a function fun1).how to call these functios from forms?

3i Infotech,

3 7605

How to call Report from other Report ?

1 8736

what is difference between cartesian join & cross join even they give same result?

Bank Of America,

4 14989

what is latest version in reports

KPIT, Wipro,

3 7772

how do u compile a form i.e .fmb file in Unix or in dos

HCL,

4621

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1948

if u want to delete all these detail block etc what will happen in form

2056

.fmb will be in which folder

2 5847

how do u place it in required folder

1991

a text item is there what r the different types of triggers associated with it

2086

what exactly u write in when_new_form_instance

TCS,

3500

where do u put the report file

2136

Un-Answered Questions { Oracle }

What is oracle database 10g express edition?

1173

Why should I use oracle database?

1053

What kinds of responsibilities does a dba have in a database environment?

649

What is the data quality in odi?

710

How view is different from a table?

1092

Explain a private synonyms?

1100

Explain oracle insert into command?

1160

How should a many-to-many relationship be handled?

597

How can we identify the resources for which the sessions are waiting?

How to define an oracle sub procedure?

1233

How is clustered index different from non-clustered index?

How to define and use table alias names in oracle?

998

how the indexes are stored in the Oracle Database?

2339

Whats the benefit of dbms_stats over analyze?

2068

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

1136

For More Un-Answered { Oracle } Questions Click Here