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?

1872

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

1 2780

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

2 4502

how can we store any pdf file in oracle

1739

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 2424

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 5464

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 3288

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 4289

what is main def between plsql/table and array?

Oracle,

1 3210

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 5276

Un-Answered Questions { Oracle }

While taking hot backup (begin end backup) what will happens back end?

339

Difference between hot backup vs. Cold backup?

696

How to loop through a cursor variable?

674

What are the types of partitions in oracle?

635

What does dba stand for database?

361

What is the difference between truncate and delete? Why is one faster?

338

What is a select query statement in oracle?

620

i am writing a query select EmpNo from Emp how can i call in after parameter form

1695

What is a recovery catalog?

Is there any link between pr form(purchse requisition)and po form(purchase order)

2254

What is oracle and what are its different editions?

671

Point out the difference between user tables and data dictionary?

626

What is difference between logical standby database and physical standby database?

370

Which profile required to access solution in Designer tool?

363

What are transaction isolation levels supported by oracle?

668

For More Un-Answered { Oracle } Questions Click Here