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?

1005

What is the use of file param in imp command?

1165

What is a system tablespace?

1072

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?

1053

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 }

What degree do database administrators need?

544

What is oracle host variable?

1061

How to delete a column in an existing table in oracle?

1071

How do you recover a lost control file?

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

1068

How to use attributes of the implicit cursor in oracle?

1008

How I can use srw.run_report in reports6i?

How to login to the server without an instance?

1162

Can we modify approve purchase order?if yes what is navigation?

2010

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

609

What is Data Dictionary Cache in Oracle?

1163

How to define a procedure inside another procedure?

1024

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2071

What is a canvas in oracle forms?

1066

What is an oracle user account?

990

For More Un-Answered { Oracle } Questions Click Here