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

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2218

hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 3684

What is the sql query to find the employee who has Nth maximum salary?

2 5319

how can we store any pdf file in oracle

2160

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

IBM, Wipro,

1 2967

Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks

IBM,

2 6162

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

IBM,

2 4022

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

IBM,

2 5027

what is main def between plsql/table and array?

Oracle,

1 3859

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

Microsoft,

2 5995

Un-Answered Questions { Oracle }

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

2994

Explain the use of rows option in imp command.

1080

What are named parameters?

1087

What is Data Dictionary Cache in Oracle?

1161

How to bring a tablespace offline?

1055

What is memory advisor in Oracle?

1074

What is the data pump export utility?

1077

What is transactional trigger property?

How to create an initialization parameter file?

1040

What are temporal data types in oracle?

1119

What is an artificial (derived) primary key?

611

What do you mean by cdb and pdb in oracle 12c?

1057

What is the relation of a user account and a schema?

1129

How to change program global area (pga) in oracle?

1084

How to use group functions in the select clause using oracle?

1069

For More Un-Answered { Oracle } Questions Click Here