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

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What are summary column and placeholder column in reports?

Explain the difference between repeating frame and frame.

Explain the benefits and uses lexical parameter.

What is ole automation?

What is the sequence of firing in report trigger?

What are record groups ?

What is path setting for dll?

What is transactional trigger property?

What are property classes?

What is iapxtb structure? Explain its importance

Difference between lexical and bind varible.

What are open_form,call_form,new_form?

What are the types of windows (window style)?

What are the file systems and volume management techniques used in oracle rac?

What are the conditions kept in mind while connecting the oracle rac with the network?

Un-Answered Questions { Oracle }

How to get maxsal , minsal, ename department wise in single query

1609

What is oracle sid?

1007

How to upsert (update or insert into a table)?

1045

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3389

What do you mean by a deadlock?

1116

did u received a single file or multiple files

2063

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2373

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2361

How to call a stored function in oracle?

1069

How to create a table index?

1234

List out the difference between commit, rollback, and savepoint?

1098

What is oracle in java?

1020

What is data store? How to create data store?

691

What is oracle thin client?

1081

Explain master-detail relationship with some examples.

1058

For More Un-Answered { Oracle } Questions Click Here