Oracle Interview Questions
Questions Answers Views Company eMail


What is Normalization ?

ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,

55 73785

Difference between sub query and nested query ?

Keane India Ltd, TCS,

19 62421

Indexes in oracle ?

Keane India Ltd, L&T,

3 8742

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

2081

Query to get max and second max in oracle in one query ?

CTS, Keane India Ltd, TCS, Wipro,

34 57430

Write a simple Store procedure and pass parameter to it ?

Keane India Ltd,

3 6523

What is DTS and purpose of DTS ?

TCS,

1 6160

What is currency type in database ?

TCS,

3 12885

What is a heap related to database ?

TCS, University of Edinburgh,

1 7034

What are the built-in functions used for sending Parameters to forms ?

Oracle, TCS,

2847

Can you have more than one content canvas view attached with a window ?

Oracle,

1817

Is the After report trigger fired if the report execution fails ?

Oracle,

2404

Does a Before form trigger fire when the parameter form is suppressed ?

Oracle,

1 3919

Is it possible to split the print reviewer into more than one region ?

Oracle,

1837


Un-Answered Questions { Oracle }

How to count duplicated values in a column in oracle?

554


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.

1633


What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

716


Tell me some differences between ODI 10g and ODI 11g?

276


What is sharded cluster?

520






How can I combine multiple rows into a comma-delimited list in oracle?

583


What is the most common database language that a db administrator needs to know?

269


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

297


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1448


Explain the truncate in oracle?

549


how to load the data with one flat file and one rdbms table using joins?

303


Explain joins in oracle?

561


What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?

1


How many types of v variables'? Where will appear for variables in odi?

274


What are the set operators union, union all, minus & intersect meant to do?

564