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?

1199

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?

980

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

1056

what is the dual table in oracle?

992

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

1053

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is Segment Advisor in Oracle?

1104

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2397

what are the advantages of running a database in archive log mode?

2203

What happens to the data files if a tablespace is dropped?

1059

how to handle exceptions in post production

1426

Does oracle charge for java?

1056

How to rename an index in oracle?

1114

What language does oracle use?

1100

Please explain drop constraint oracle?

1105

How to drop a stored procedure in oracle?

1051

How to define an explicit cursor in oracle?

1040

Why do we use coalesce function in oracle?

1119

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2270

What are advantages of dateset in datastage?

2263

What is the use of oracle?

1030

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