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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

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?

1006

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?

1040

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

1065

State some uses of redo log files?

1009

What is coalesce function?

1073

How can we view last record added to a table?

1038

What is the maximum number of triggers that can be applied to a single table?

1025

What is the usage of merge statement?

1154

Explain the difference between a procedure and a function?

1172

Un-Answered Questions { Oracle }

How to define Data Block size in Oracle?

1112

What is a snapshot log?

1003

What is a cognitive schema?

968

What is instant client oracle?

1021

what does the no logging option do? Why would we use it?

551

Explain the use of tables option in exp command.

1117

What is an oracle data file?

1103

What are the original export and import utilities?

1172

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

587

What is a recovery catalog?

What exactly do quotation marks around the table name do?

963

WHAT IS ecc 6.0

2147

Difference between 10g & 11g in odi?

776

What is BBED in Oracle?

1154

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1949

For More Un-Answered { Oracle } Questions Click Here