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 different types of joins?

1078

How to fetch the row which has the max value for a column?

1042

How to get last row id?

1049

How to put more than 1000 values into an oracle in clause?

1085

Difference between inner join vs where ?

1094

How to store only time; not date and time?

1065

What is the minimum client footprint required to connect c# to an oracle database?

1161

Is there a combination of "like" and "in" in sql?

1114

How can I introduce multiple conditions in like operator?

1047

How to load a large xml file?

1105

What is the difference between "as" and "is" in an oracle stored procedure?

1046

is there a tool to trace queries, like profiler for sql server?

1192

What is the difference between a user and a schema in oracle?

1076

What are the oracle differences between nvl and coalesce

1233

What is the best way to do multi-row insert in oracle?

1105

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to Truncate Table in Oracle

1210

How does Oracle guarantee data integrity of data changes?

2453

Difference between varchar and varchar2 data types?

1257

What is the parameter mode that can be passed to a procedure?

1106

Can the query output be sorted by multiple columns in oracle?

1049

How to create tables for odbc connection testing?

1202

What is the difference between translate and replace?

1114

What is instant client oracle?

1072

What are the four Oracle system processes that must always be up and running for the database to be useable?

1048

How to export your connection information to a file?

1171

How to end the current transaction in oracle?

1067

Explain the use of tables option in exp command.

1166

How would you best determine why your MVIEW couldnt FAST REFRESH?

1931

How to drop an index in oracle?

1118

How to start a new transaction in oracle?

1134

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