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 7792

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

Microsoft,

3 6459

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

Microsoft,

2058

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

Microsoft, Oracle, TCS,

5 9763

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 5992

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

Verizon,

6 9668

what is the step for rmanbackup?

1 3796

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 17052

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 5060

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

Sapient,

6 9558

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

2205

Define Normalization with example?

1 5043

what is dynamic SGA and static SGA

Oracle,

4413

sql query to get zero records from a table

CTS,

7 11672

what is integrity constrains?

3 5926

Un-Answered Questions { Oracle }

Components of Oracle Data Integrator?

544

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1986

How to export data with a field delimiter?

1037

What does a senior database administrator do?

604

How to see free space of each tablespace?

1032

What skills do you need to be an administrator?

558

Have you created sequence? When will you use?

550

Any work done in oracle workflow builder. Did you customize or build a new workflow?

What is a cursor in oracle?

1170

Explain the use of analyse option in exp command.

1124

How many types of dimensions in oracle?

576

Can objects of the same schema reside in different tablespace?

1060

You are getting busy buffer waits. Is this bad? How can you find what is causing it?

533

How to connect to a local oracle 10g xe server?

992

Discuss row chaining, how does it happen? How do you correct it?

545

For More Un-Answered { Oracle } Questions Click Here