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?

1167

What are the different types of synonyms?

1140

How do you store pictures in a database?

1008

What is the use of file param in imp command?

1165

What is a system tablespace?

1082

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

1303

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?

1044

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 }

What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

593

What are a cluster and non-cluster index?

1018

What is chargeback invoice? How do we create it? : oracle accounts receivable

1333

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

625

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

1088

Can we create database in oracle using command line ?

1091

What is oracle thin client?

1027

What is the difference between sharding and partitioning?

986

What is the main function of database?

610

What is an external table?

1024

How do I know if oracle is installed on windows?

931

Does a dba have to file taxes?

584

How to omit columns with default values in insert statement in oracle?

1049

Explain a data segment?

1071

What is a data dictionary and how can it be created?

1152

For More Un-Answered { Oracle } Questions Click Here