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 5999

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

Verizon,

6 9688

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 17088

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 5056

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 }

What is the maximum limit on the number of columns in a table?

1086

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

587

What do you mean by oracle dba and what is its role?

586

What is pct free/pct used/pct increase parameter in segment?

576

What happens if you lost a data file?

1034

How to add a new column to an existing table in oracle?

1139

What is the advantage of using rman?

722

What are the key components of oracle’s maximum availability architecture?

Explain an integrity constrains?

1149

How to create tables for odbc connection testing?

1117

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2149

What are a collation and state the different types of collation sensitivity?

1170

What are the original export and import utilities?

1171

What is instant client oracle?

1021

What is the meaning of recursive hints in oracle?

1046

For More Un-Answered { Oracle } Questions Click Here