Oracle Interview Questions
Questions Answers Views Company eMail

What is database schema?

Infosys,

4 14431

What is Reduced List of Values?

iFlex,

1708

What is Hash Index?

1 5183

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 6130

How to call Report from other Report ?

1 7481

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

Bank Of America,

4 12869

what is latest version in reports

KPIT, Wipro,

3 6412

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

HCL,

4024

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

1484

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

1479

.fmb will be in which folder

2 4786

how do u place it in required folder

1478

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

1514

what exactly u write in when_new_form_instance

TCS,

2900

where do u put the report file

1652


Un-Answered Questions { Oracle }

What is snapshot is too old? Give and example for better understand.

1102


How many knowledge modules you used?

300


What is the quickest way to fetch the data from a table?

570


What is the meaning of database backup?

287


Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7450






What is J2EE Agent and port number?

297


What are the five main functions of a database administrator?

303


What is bind variables in oracle reports?

1


When should you increase copy latches? What parameters control copy latches?

299


How to get last row id?

559


How many types of knowledge Modules? Where are used in km?

326


Do you know table based value sets?

1


How can you find out how many users are currently logged into the database?

323


Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

299


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1502