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

Oracle General Interview Questions

Questions Answers Views Company eMail

How do we display rows from the table without duplicates?

922

What are the differences between lov and list item?

1001

How do we represent comments in oracle?

1005

What do you mean by group by clause?

984

What do you know about normalization? Explain in detail?

887

What are the different oracle database objects?

1034

State all possible different index configurations a table can possibly have?

951

What is the difference between translate and replace?

1015

How can we delete duplicate rows in a table?

933

What is a cursor and what are the steps need to be taken?

1130

Compare and contrast between sql and sql server and explain its various functions?

924

How different is ms access and oracle?

990

How to display employee records who gets more salary than the average salary in the department?

1005

State some uses of redo log files?

949

What is coalesce function?

1016

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the oracle built-in data types?

1015

What is an external table?

962

Explain a segment?

1030

How to install oracle odbc drivers?

1045

In the oracle version 9.3.0.5.0, what does each number shows?

1231

What happens if you use a wrong connect identifier?

986

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3003

What are the different pseudo commands? Explain in general?

1026

Explain the use of file option in exp command.

1087

How different is ms access and oracle?

990

What is max rowid in oracle?

972

What is not equal to in oracle?

956

What is blob data type in oracle?

1052

How to add a new column to an existing table with a default value?

974

How to get a create statement for an existing table?

910

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