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?

1284

What is blob data type in oracle?

1203

What is the usage of analyze command in oracle?

1138

What is an oracle table?

1031

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

1028

How do you find current date and time in oracle?

1099

What is a snapshot in oracle database?

1070

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

1114

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

1118

How to load excel data sheet to oracle database

1072

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

1 1577

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

1021

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

1125

what is the dual table in oracle?

1037

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

1104

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to rename a column in an existing table?

1081

How to join two tables in a single query using oracle?

1051

How can we delete duplicate rows in a table?

1035

How to define a sub function?

1198

Point the difference between translate and replace?

1148

What are the database administrators utilities available?

1092

How a database is related to tablespaces?

1081

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2295

What is hash cluster in oracle?

1244

How to display row numbers with the records?

1132

How to experiment a data lock in oracle?

1108

Why is oracle so popular?

1052

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1109

What happens if you use a wrong connect identifier?

1135

Whats the benefit of dbms_stats over analyze?

2064

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