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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

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?

1302

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

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011

Can you create a synonym without having a table?

1042

What are the components of logical database structure in oracle database?

1088

What is the usage of save points in oracle database?

964

Un-Answered Questions { Oracle }

How to test null values?

1107

What is null value in oracle?

1097

How will you run ms_batch file in forms?

What is ceil and floor in oracle?

1069

What are the different types of partitions in oracle?

979

What is forms_mdi_window?

Explain table?

1118

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.

2180

Please explain drop constraint oracle?

1108

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2192

What is a canvas in oracle forms?

1066

Components of Oracle Data Integrator?

548

What is the use solutions?

591

How to connect asp pages to oracle servers?

1072

Explain an index segment?

1119

For More Un-Answered { Oracle } Questions Click Here