Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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 7964

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

Microsoft,

3 6602

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

Microsoft,

2123

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

Microsoft, Oracle, TCS,

5 10015

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 6124

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

Verizon,

6 9873

what is the step for rmanbackup?

1 3930

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 17496

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 5203

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

Sapient,

6 9746

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

2261

Define Normalization with example?

1 5205

what is dynamic SGA and static SGA

Oracle,

4495

sql query to get zero records from a table

CTS,

7 11939

what is integrity constrains?

3 6079

Un-Answered Questions { Oracle }

What is the difference between sharding and replication?

1143

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2179

Explain the payment term in ar. : oracle accounts receivable

1155

What is temporary Interface( Yellow Interface) ?

616

Explain the use of consistent option in exp command.

1146

How many dba can you have?

581

How many categories of data types in oracle?

1075

How to start a specific oracle instance?

1083

What are the types of locks in database?

663

What are the tools provided in oracle enterprise manager?

What is Java Pool in Oracle?

1253

Difference between inner join vs where ?

1096

How do you generate file output from sql?

669

What is a table index in oracle?

1189

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

660

For More Un-Answered { Oracle } Questions Click Here