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 10310

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.

2422

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

Polaris,

1 5392

structural difference between bitmap and btree index ?

Infosys,

1 12217

What is format trigger?

2120

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

3 7456

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

1 6036

what is exact difference between drop and truncate table.

3 7353

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 15687

what are corelated subqueries

Global Infotech,

1 2884

who is the father of oracle and send chodd rules

ME,

4 19131

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

1 4888

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

4 7121

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

NIC,

2285

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 4922

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to create a new table by selecting rows from another table?

1149

What is the difference between a user and a schema in oracle?

1079

Can multiple cursors being opened at the same time?

1115

What happens if you lost a data file?

1080

What is the use of file param in imp command?

1215

How to drop a stored function?

1182

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4230

Explain the use of control file?

1173

Â How to use an oracle sequence generator in a mapping?

1130

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2261

How to create a new table in your schema?

1129

How many categories of data types?

1041

What is format trigger?

2120

What are the advantages of oracle?

1068

Can you create a synonym without having a table?

1090

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