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

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

Microsoft,

4 7812

I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

Microsoft,

3 6465

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

Microsoft,

2059

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

Microsoft, Oracle, TCS,

5 9777

how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

Verizon,

2 5996

how to get the second max val for every group in a table

Verizon,

6 9687

what is the step for rmanbackup?

1 3809

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

Wipro,

11 17087

dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.

3 5071

how to select second mauximum value in a given table under salary column

Sapient,

6 9570

what are basic modules required to implement oracle application in any oraganisation?

2207

Define Normalization with example?

1 5055

what is dynamic SGA and static SGA

Oracle,

4417

sql query to get zero records from a table

CTS,

7 11691

what is integrity constrains?

3 5937

Un-Answered Questions { Oracle }

How to export your own schema?

1007

Can group functions be used in the order by clause in oracle?

997

explain what is odi?why is it different from the other etl tools.

619

How to store pictures on to the database?

975

How to drop an index in oracle?

1076

What is a staging area? Do we need it?

What is a system tablespace and when it is created?

972

State the difference between a primary key and foreign key?

935

What are the system predefined user roles?

1041

What is rac?

What is Data Dictionary Cache in Oracle?

1163

State any two functions of oracle?

1046

Explain a data segment?

1068

What do you mean by oracle dba?

570

How to speed up webrick?

1076

For More Un-Answered { Oracle } Questions Click Here