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

Briefly explain what is literal? Give an example where it can be used?

985

Explain about the analyze command in oracle?

1009

Difference between cartesian join and cross join?

978

Point the difference between translate and replace?

1034

What are the major difference between truncate and delete?

999

What is a sub query? Describe its types?

972

What is the difference between count (*), count (expression), count (distinct expression)?

968

Point out the difference between user tables and data dictionary?

942

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

917

Difference between the “verify” and “feedback” command?

1319

What do you mean by merge in oracle?

945

Describe an oracle table?

1002

What are the differences between primary key and unique key?

955

What is the difference between substr and instr?

988

Describe varray?

1009

Un-Answered Questions { Oracle }

How can we use tkprof?

How to find the duplicate rows count from employees table in oracle?

1051

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

536

What are the advantages of oracle 12c?

1133

Who is a database user?

488

i am writing a query select EmpNo from Emp how can i call in after parameter form

2064

What is split brain syndrome in rac?

What happens to the indexes if a table is recovered?

951

How to use "in" parameter properly?

1014

What are the constraints in odi?

575

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1300

What are the different types of backup available in the oracle?

546

What are temporal data types in oracle?

1076

How can we tune a sql query to optimize the performance of a database?

When you use CKM?

549

For More Un-Answered { Oracle } Questions Click Here