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?

900

What are the different oracle database objects?

1042

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

958

What is the difference between translate and replace?

1021

How can we delete duplicate rows in a table?

944

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

1145

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

931

How different is ms access and oracle?

997

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

1018

State some uses of redo log files?

963

What is coalesce function?

1031

How can we view last record added to a table?

978

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

977

What is the usage of merge statement?

1107

Explain the difference between a procedure and a function?

1106

Un-Answered Questions { Oracle }

what is the difference between functional dependecy and multilevel dependency?

2429

What is open database communication (odbc) in oracle?

969

did u p prepared complex report

1961

What are types of data model?

504

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

535

Give two methods you could use to determine what DDL changes have been made.

6708

WHAT IS ecc 6.0

2116

Explain how to convert a report into excel sheet.

Differentiate between post-database commit and post-form commit?

990

What does >> do?

547

How do we display rows from the table without duplicates?

940

Does a dba have to file taxes?

539

What does a dba do all day?

513

What is the relationship among database, tablespace and data file?

943

How to invoke the data pump import utility?

1096

For More Un-Answered { Oracle } Questions Click Here