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

What is database schema?

Infosys,

4 16296

What is Reduced List of Values?

iFlex,

2165

What is Hash Index?

1 5908

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 7487

How to call Report from other Report ?

1 8663

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

Bank Of America,

4 14809

what is latest version in reports

KPIT, Wipro,

3 7629

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

HCL,

4572

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

1891

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

1987

.fmb will be in which folder

2 5750

how do u place it in required folder

1934

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

2014

what exactly u write in when_new_form_instance

TCS,

3444

where do u put the report file

2091

Un-Answered Questions { Oracle }

How to create an initialization parameter file?

1049

What is oracle update statement with inner join ?

1059

Is java required for oracle client?

999

What is new feature in oracle asm 12c?

How would you go about verifying the network name that the local_listener is currently using?

2049

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2697

What is the function of grid naming service used in oracle rac

What do you understand by the term 'normalization'? Explain the various modes of normalization?

556

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

563

What is a dba why is this position necessary?

573

What is rac and what are the various benefits of using rac architecture?

Is Odi used in oracle products?

668

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

988

where do u put the report file

2091

What is connection pooling in oracle?

973

For More Un-Answered { Oracle } Questions Click Here