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?

1164

What are the different types of synonyms?

1140

How do you store pictures in a database?

1004

What is the use of file param in imp command?

1165

What is a system tablespace?

1071

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

1299

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?

1052

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?

1041

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

1087

What is the usage of save points in oracle database?

964

Un-Answered Questions { Oracle }

Mention what are the key characteristics of rac or why to use rac?

How to establish administrator authentication to the server?

1040

What is Session Tasks?

601

HOW TO SPOT AHIERARCHY?

2294

What is the use of file param in imp command?

1165

Does oracle partitioning improve performance?

992

Is oracle dba in demand?

594

How many concurrent programs you have customized, can you name some of them?

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2464

How many types of database software are there?

587

Why more redos are generated when the oracle database is in begin backup mode?

1120

Explain the characteristics of oracle dba?

1120

How can we identify the resources for which the sessions are waiting?

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3576

How to run queries on external tables?

1046

For More Un-Answered { Oracle } Questions Click Here