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

Oracle

2428

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1710

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1914

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1793

Is it possible to drop a column in a table which contains only one column? How?

1 3279

what is tripstop report?

1911

What is Oracle table?

1 2552

What is an Oracle view?

1 2619

What is an Oracle sequence?

1 2732

What are the types of synonyms?

1 2531

What is a private synonym?

1647

What is a public synonym?

1 2527

What is an Oracle index?

1707

How are the index updates?

1 2736

What does ROLLBACK do ?

1 2964

Un-Answered Questions { Oracle }

What do you understand by the term 'normalization'?

716

What is an index associated with a constraint?

1094

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

582

Mention how oracle flex asm works?

What is load plan and types of load plans in ODI?

674

What is the difference between single instance environment and rac environment?

How to open a cursor variable?

1093

What is the recommended interval at which to run statspack snapshots, and why?

2968

How can we view last record added to a table?

1110

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

2194

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2265

How to create lov dynamically at runtime & attach to text field?

1241

What exactly does a dba do?

625

How to unlock the sample user account in oracle?

1079

What is the difference between PFILE and SPFILE in Oracle?

1113

For More Un-Answered { Oracle } Questions Click Here