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?

987

What do you know about normalization? Explain in detail?

888

What are the different oracle database objects?

1034

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

952

What is the difference between translate and replace?

1015

How can we delete duplicate rows in a table?

936

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

1132

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?

1008

State some uses of redo log files?

951

What is coalesce function?

1019

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Can we protect our pl/sql source code?

994

What is difference between sid and service name in oracle?

910

How to create a new tablespace in oracle?

938

What is tns entry?

1069

How to insert a record into a table?

1026

Explain the use of parfile option in exp command.

1000

What is define in oracle?

1014

What are group functions in oracle?

984

What are the oracle built-in data types?

1016

How to concatenate two text values in oracle?

1057

What is bulk copy or bcp in oracle?

1054

How to convert characters to times in oracle?

959

How to define a record variable to store a table row?

1012

How to convert numbers to characters in oracle?

976

What are named parameters?

1038

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