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

Oracle General Interview Questions

Questions Answers Views Company eMail

Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?

1 10208

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.

2370

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

Polaris,

1 5312

structural difference between bitmap and btree index ?

Infosys,

1 12143

What is format trigger?

2075

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

3 7348

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

1 5958

what is exact difference between drop and truncate table.

3 7225

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 15430

what are corelated subqueries

Global Infotech,

1 2814

who is the father of oracle and send chodd rules

ME,

4 18995

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

1 4804

How to find the date and time of last updated table?

4 7013

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

NIC,

2231

Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?

3 4787

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is instant client oracle?

1023

How many memory layers are in the oracle shared pool?

1184

What is the relation of a user account and a schema in oracle?

1080

What is the dynamic sql in oracle?

1077

What is data block in Oracle?

1118

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2033

What are the uses of a database trigger?

994

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2316

what is reindexing?

1678

How to get a create statement for an existing table?

970

How to start an oracle instance?

1022

What is the string concatenation operator in oracle?

1177

1) Does oracle have any table which contain all the exceptions and it's code internally?

1751

How to create id with auto_increment on oracle?

990

How do you store pictures in a database?

1008

For More Un-Answered { Oracle General } Questions Click Here