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

How to assign values to variables?

1061

How to retrieve data from an cursor to a record?

1040

How to save query output to a local file?

983

How to export your own schema?

980

How to convert character types to numeric types?

1068

What are the system predefined user roles?

991

How to create a table in a specific tablespace?

926

How to create a table interactively?

1019

How to drop a stored function?

1099

How to export data to a csv file?

1232

What are the differences between interval year to month and interval day to second?

974

How to bring a tablespace offline?

1011

What is the order of defining local variables and sub procedures/functions?

1020

How to retrieve data from an explicit cursor?

1019

What are the arithmetic operations?

1033

Un-Answered Questions { Oracle }

how do u setup a replication site?

1940

What are the major difference between truncate and delete?

1000

How to use fetch statement in a loop?

989

What is a read write transaction in oracle?

1044

How do you tell what your machine name is and what is its IP address?

2021

Discuss row chaining, how does it happen? How do you correct it?

504

What is the purpose of save points in oracle database?

1030

How do I connect to oracle database?

1044

How can we generate report output in excel format?

951

What skills do you need to be a database administrator?

501

What is format trigger?

2026

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2303

Does oracle partitioning improve performance?

957

what exactly u write in when_new_form_instance

3403

What do you understand by recovery catalog?

531

For More Un-Answered { Oracle } Questions Click Here