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 10202

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.

2368

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

Polaris,

1 5305

structural difference between bitmap and btree index ?

Infosys,

1 12134

What is format trigger?

2070

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

3 7342

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

1 5955

what is exact difference between drop and truncate table.

3 7218

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 15415

what are corelated subqueries

Global Infotech,

1 2806

who is the father of oracle and send chodd rules

ME,

4 18992

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 4780

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Difference between hot backup vs. Cold backup?

991

What is the quickest way to fetch the data from a table?

1058

What is oracle database client?

1032

What is Java Pool in Oracle?

1168

How many types of tables are there in oracle?

1061

What is the meaning of recursive hints in oracle?

1046

How to check database size in Oracle?

1189

What is a cognitive schema?

963

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2969

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5550

What is procedure overloading in oracle?

1060

How to upsert (update or insert into a table)?

999

candidate key is subset of super key but not vice-verse explain

2068

What is a package ? What are the advantages of package ?

1091

How to see free space of each tablespace?

1034

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