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.

2370

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

Polaris,

1 5308

structural difference between bitmap and btree index ?

Infosys,

1 12138

What is format trigger?

2074

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

3 7343

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

1 5956

what is exact difference between drop and truncate table.

3 7221

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 15422

what are corelated subqueries

Global Infotech,

1 2809

who is the father of oracle and send chodd rules

ME,

4 18994

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 4784

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to view the tablespaces in the current database?

978

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1690

In what script is snap$ created? In what script is the scott/tiger schema created?

2709

What the is the diff between local index and global index. give some example.

1640

Explain rename?

983

what is IDE,DMV in sql server?

2822

How to rename an existing table?

1129

What is null value in oracle?

1097

Explain a synonym?

1032

How much memory your 10g xe server is using?

1103

What is the difference between sharding and partitioning?

986

What is transaction control statement and how many types of transaction control statement in Oracle?

1158

Give the various exception types.

993

How to run create database statement?

1034

Query to retrieve record for a many to many relationship ?

2520

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