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 16266

What is Reduced List of Values?

iFlex,

2160

What is Hash Index?

1 5907

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 7476

How to call Report from other Report ?

1 8657

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

Bank Of America,

4 14787

what is latest version in reports

KPIT, Wipro,

3 7609

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

HCL,

4566

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

1889

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

1980

.fmb will be in which folder

2 5730

how do u place it in required folder

1928

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

2005

what exactly u write in when_new_form_instance

TCS,

3442

where do u put the report file

2091

Un-Answered Questions { Oracle }

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2155

How to create a temporary table in oracle?

1262

What are the different windows events activated at runtime ?

2896

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2336

How to drop a stored procedure in oracle?

1051

List the various oracle database objects?

1053

How to use attributes of the implicit cursor in oracle?

1004

How can be determining the size of the log files?

578

What is ELT? Or What is the difference between ODI and other ETL Tools?

683

What is Sequences?

621

How to drop an index?

952

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

1184

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2514

What is split brain syndrome in rac?

How do you set up your tablespace on installation level: low?

564

For More Un-Answered { Oracle } Questions Click Here