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

Oracle General Interview Questions

Questions Answers Views Company eMail

What is the difference between post-database commit and post-form commit?

1198

What is blob data type in oracle?

1123

What is the usage of analyze command in oracle?

1093

What is an oracle table?

988

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

979

How do you find current date and time in oracle?

1047

What is a snapshot in oracle database?

1025

How can I combine multiple rows into a comma-delimited list in oracle?

1062

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1078

How to load excel data sheet to oracle database

1024

What does `(+)` do in a where clause?

1 1496

Is there an oracle sql query that aggregates multiple rows into one row?

978

Why does oracle 9i treat an empty string as null?

1056

what is the dual table in oracle?

991

Is there any function in oracle similar like group_concat of mysql?

1053

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Is oracle the best database?

963

Explain oracle’s server parameter file.

992

Can we commit inside a function in oracle?

964

Name the three major set of files on disk that compose a database in Oracle?

1123

State and explain about oracle instance?

991

1) Does oracle have any table which contain all the exceptions and it's code internally?

1749

What is a sub query? Describe its types?

1017

Difference between pre-select and pre-query

1108

How do I start tns listener?

1043

Explain how you would restore a database using RMAN to Point in Time?

2144

What is the max number of columns in an oracle table?

999

What is a oracle database?

1055

What is truncate oracle?

971

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2261

How will you write a query to get a 5th rank student from a table student_report?

1866

For More Un-Answered { Oracle General } Questions Click Here