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 ASIS BUSINESS PROCESS IN ORACLE FINANCE

2330

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2288

what are the API of GL,PO,AP

2318

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2428

How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example

Polaris,

1 5393

structural difference between bitmap and btree index ?

Infosys,

1 12217

What is format trigger?

2122

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3

3 7471

How can we Update a table with out using UPDATE command?

1 6046

wht r the base tables & primary key for BOM& WIP modules

Satyam,

1 5990

what is exact difference between drop and truncate table.

3 7372

Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...

Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,

10 15724

what are corelated subqueries

Global Infotech,

1 2893

who is the father of oracle and send chodd rules

ME,

4 19147

query to find the maximum no persons with same age(age colomn) from emp table

1 4897

Un-Answered Questions { Oracle }

how to send file attachment from oracle forms

2605

How data locks are respected in oracle?

1113

explain what is odi?why is it different from the other etl tools.

668

what is difference between sql plus and sql*plus? (not sql and sql plus).

3943

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

630

Can we create trigger on materialized view in oracle?

1047

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

2050

Will you be able to store pictures in the database?explain.

1041

How do I find the database name in oracle?

1090

What is redo log?

1117

How to fetch the row which has the max value for a column?

1050

How to define an oracle cursor variable?

1094

how to write customizations in po

1660

Why does Oracle not permit the use of PCTUSED with indexes?

2483

What are the advantages of oracle 12c?

1239

For More Un-Answered { Oracle } Questions Click Here