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

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

Oracle Interview Questions

Questions Answers Views Company eMail

Oracle

2327

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

1600

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??

1803

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??

1681

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

1 3123

what is tripstop report?

1775

What is Oracle table?

1 2395

What is an Oracle view?

1 2470

What is an Oracle sequence?

1 2568

What are the types of synonyms?

1 2395

What is a private synonym?

1537

What is a public synonym?

1 2366

What is an Oracle index?

1613

How are the index updates?

1 2560

What does ROLLBACK do ?

1 2779

Un-Answered Questions { Oracle }

What is a cognitive schema?

915

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?

568

What are four common errors found in an alert .log?

511

How to write an inner join with the where clause in oracle?

1016

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

539

Explain the benefits and uses lexical parameter.

Explain the various types of canvas in form.

Write a trigger example in oracle?

990

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2217

How to define an anonymous procedure with variables?

1081

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

523

Define oracle database

1000

How would you determine who has added a row to a table?

2261

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

519

How many memory layers are in the oracle shared pool?

1122

For More Un-Answered { Oracle } Questions Click Here