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 16131

What is Reduced List of Values?

iFlex,

2119

What is Hash Index?

1 5851

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 7368

How to call Report from other Report ?

1 8582

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

Bank Of America,

4 14638

what is latest version in reports

KPIT, Wipro,

3 7495

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

HCL,

4524

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

1855

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

1941

.fmb will be in which folder

2 5648

how do u place it in required folder

1880

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

1957

what exactly u write in when_new_form_instance

TCS,

3403

where do u put the report file

2048

Un-Answered Questions { Oracle }

What is the anchoring in reports?

How to write date and time literals in oracle?

964

How to drop a stored procedure in oracle?

1011

Can you have more than one content canvas view attached with a window ?

2277

What is meant by joins? List out the types of joins.

974

how do u setup a replication site?

1940

What is a snapshot in oracle database?

981

What are the restrictions on external table columns?

1007

interview questions with answer for cts

2544

What is the difference between recovery and restoring of the oracle database?

1162

Which are the five query types available in oracle?

917

What is the sequence of firing in form level trigger?

What is logical backup in oracle?

979

6. Display the client name and order date for all orders using the traditional method.

2259

what is a package n what r the packages availbla in report

2044

For More Un-Answered { Oracle } Questions Click Here