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

Oracle General Interview Questions

Questions Answers Views Company eMail

Explain about your project and its relation to the current job position you are applying to?

1011

What are privileges and grants?

1067

How to display row numbers with the records?

1079

What are the uses of linked server and explain it in detail?

1061

Why do you use stored procedures and state some of its disadvantages?

1028

How to convert a date to char in oracle? Give one example.

1068

What is the difference between translate and replace in oracle?

1165

What are the different types of synonyms?

1140

How do you store pictures in a database?

1007

What is the use of file param in imp command?

1165

What is a system tablespace?

1079

In the oracle version 9.3.0.5.0, what does each number shows?

1301

What are the different types of modules in oracle forms?

1001

What are the limitations of check constraint?

1033

How to convert a string to a date in oracle database?

1054

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the best way to do multi-row insert in oracle?

1067

How to add another datafile to a tablespace?

1040

Design database draw er diagram for a certain scenario ?

4579

Can we connect to ORACLE db using Windows Authentication?

1257

What are the tools for Oracle ?

1062

List the various oracle database objects?

1060

How to apply filtering criteria at group level in oracle?

1042

How to define a variable of a specific record type?

1078

What language does oracle use?

1102

What is data file?

1106

What is an oracle?

1018

what is insert all statement in sql

6519

How to import one table back from a dump file?

1025

What is instant client oracle?

1021

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3331

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