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 is meant by joins?

1059

Can we save images in a database and if yes, how?

1063

What is a view and how is it different from a table?

1044

How will you write a query to get a 5th rank student from a table student_report?

1866

What are the different editions of oracle?

1106

What is meant by an index?

1144

What is meant by a deadlock situation?

1109

What is the difference between a primary key & a unique key?

1089

How can we find out the current date and time in oracle?

1088

What is a nested table and how is it different from a normal table?

1049

How is it different from a normal table?

1030

How does the on-delete-cascade statement work?

1103

What is meant by joins? List out the types of joins.

1030

What do you understand by database schema and what does it hold?

1230

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

1049

Un-Answered Questions { Oracle }

Explain each trigger related to mouse.

How do we create privileges in oracle?

1045

What do you mean by dba?

572

what are archived logs?

2199

Explain the hardware architecture used in oracle rac?

What is archive log in Oracle?

1134

Can we write dml statement in function in oracle?

1081

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2208

What is set verify off in oracle?

1102

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2988

What is MTTR advisor in Oracle?

1090

What are triggers in oracle?

1037

How to define an anonymous procedure without variables?

1106

What are the tools for Oracle ?

1062

How remove data files before opening a database?

1072

For More Un-Answered { Oracle } Questions Click Here