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?

1002

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?

1039

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

1065

State some uses of redo log files?

1007

What is coalesce function?

1072

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What do you mean by merge in oracle and how can we merge two tables?

1049

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2007

What exactly do quotation marks around the table name do?

963

What are the benefits of ordbms?

1088

What is a read only transaction in oracle?

1029

What language does oracle use?

1100

How to write an inner join with the where clause in oracle?

1044

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

How to change system global area (sga) in oracle?

1013

Differentiate between translate and replace?

1117

Explain database link?

1123

What is index-organized table in Oracle?

1069

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2123

what is the difference between data migration and production migration.

2346

How to compare dates in oracle sql?

1103

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