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 7811

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 9772

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 9685

what is the step for rmanbackup?

1 3808

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 17083

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 5070

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 5051

what is dynamic SGA and static SGA

Oracle,

4417

sql query to get zero records from a table

CTS,

7 11685

what is integrity constrains?

3 5933

Un-Answered Questions { Oracle }

What is Sequences?

630

How many categories of data types?

994

What is secure property?

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4366

What is a dynamic performance view in oracle?

991

What are the various ingredients of sga?

572

What is execute immediate in oracle?

1021

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

589

Give the constructs of a package, function or a procedure.

1040

How to create a new view in oracle?

1078

What is a scenario in odi?

576

What is a data lock in oracle?

1118

What are the ansi data types supported in oracle?

947

What are the various types of snapshots ?

1027

Explain alias?

1147

For More Un-Answered { Oracle } Questions Click Here