Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 11805

how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)

1 3626

how to make an oracle object

2402

How to find 1st, 2nd, 3rd highest using select select statement not using rownum

3 6196

what is different between view and sequence?

4 6644

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

3051

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

1 3103

select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help

6 21135

Un-Answered Questions { Oracle }

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4682

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

621

What are the various types of snapshots ?

1086

what's query optimization and without use of IN AND Exist can we get another way data from query

2202

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

656

What is a select query statement in oracle?

1033

How to use "in" parameter properly?

1121

What is oracle join syntax?

1064

What is a synonym? What are its various types?

1179

What is oracle in java?

1020

What is merge statement used for?

1078

What is an oracle database?

1114

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

What is different type of rman backup?

722

What does the no logging option do? Why would we use it? Why would we be careful of using it?

596

For More Un-Answered { Oracle } Questions Click Here