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

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2273

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2210

what are the API of GL,PO,AP

2262

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.

2364

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

Polaris,

1 5297

structural difference between bitmap and btree index ?

Infosys,

1 12127

What is format trigger?

2062

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

3 7326

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

1 5949

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

Satyam,

1 5904

what is exact difference between drop and truncate table.

3 7204

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 15385

what are corelated subqueries

Global Infotech,

1 2796

who is the father of oracle and send chodd rules

ME,

4 18966

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

1 4802

Un-Answered Questions { Oracle }

What are the different types of modules in oracle forms?

999

What is rich query?

977

Explain the different types of queries created in reports?

What do you mean by a database transaction & what all tcl statements are available in oracle?

988

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

570

How to increment dates by 1 in oracle?

1063

How to load excel data sheet to oracle database

1017

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1769

Have you created fact table and dimension tables?

638

What is an oracle cursor variable?

1070

Why do you create or replace procedures rather that drop and recreate.

1001

what is insert all statement in sql

6506

Is rowid unique in oracle?

996

How can you tell if a tablespace has excessive fragmentation?

596

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1038

For More Un-Answered { Oracle } Questions Click Here