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?

970

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

950

How to get last row id?

941

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

974

Difference between inner join vs where ?

979

How to store only time; not date and time?

960

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

1019

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

1008

How can I introduce multiple conditions in like operator?

926

How to load a large xml file?

1005

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

937

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

1079

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

984

What are the oracle differences between nvl and coalesce

1072

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

1018

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain the difference between sap and oracle?

978

how the indexes are stored in the Oracle Database?

2214

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2130

How to export data with a field delimiter?

974

Explain an integrity constrains?

1086

Where are the settings stored for each instance in oracle?

1065

What are the varoius components of physical database structure of oracle database?

946

How does oracle handle read consistency?

1052

How to use values from other tables in update statements using oracle?

1026

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

934

How to sort output in descending order in oracle?

989

When do you get a .pll extension in oracle? Explain its importance

987

How to create a single index for multiple columns?

981

what are bitmap indexes? How does they work?

2184

What is a nvl function?

958

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