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

Oracle General (1803)
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?

1080

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

1109

What is the difference between translate and replace in oracle?

1218

What are the different types of synonyms?

1206

How do you store pictures in a database?

1064

What is the use of file param in imp command?

1221

What is a system tablespace?

1138

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

1352

What are the different types of modules in oracle forms?

1055

What are the limitations of check constraint?

1078

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

1105

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

1069

Can you create a synonym without having a table?

1097

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

1139

What is the usage of save points in oracle database?

1021

Un-Answered Questions { Oracle }

What is a subquery in oracle?

1171

Mention in rac what files should be created on shared storage?

Explain rename?

1048

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

640

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

638

What is oracle forms system.currentblock?

Can the query output be sorted by multiple columns in oracle?

1061

Explain integrity constraints?

1161

Mention what are the main components of an oracle rac system?

Oracle

2429

What is db_recovery_file_dest in oracle? When do you need to set this value?

1172

What is connection pooling in oracle?

1022

What is path setting for dll?

What are materialized views & where do we use them? What is a materialized view?

Mention what are the file storage options provided by oracle database for oracle rac?

For More Un-Answered { Oracle } Questions Click Here