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?

972

What are the differences between lov and list item?

1065

How do we represent comments in oracle?

1048

What do you mean by group by clause?

1045

What do you know about normalization? Explain in detail?

951

What are the different oracle database objects?

1091

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

1000

What is the difference between translate and replace?

1060

How can we delete duplicate rows in a table?

973

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

1202

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

964

How different is ms access and oracle?

1038

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

1065

State some uses of redo log files?

1006

What is coalesce function?

1071

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is private procedure oracle?

1010

What is meant by recursive hints in oracle?

1086

How to retrieve data from an cursor to a record?

1102

How to write text literals in oracle?

1068

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

1065

Why do you use stored procedures and state some of its disadvantages?

1028

What is analyze command used for?

1072

How to open and close an explicit cursor in oracle?

1058

Why is oracle used?

938

How do I know if oracle client is installed on windows?

1024

Explain an extent?

1103

How to create a table interactively?

1090

What is index-organized table in Oracle?

1069

Explain the use of online redo log files in oracle.

1036

How to drop a stored function?

1137

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