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

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

4358

Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)

6 17085

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2099

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

IBM,

2161

how to join query for one source type is oracle another source type is sql server ?

iGate,

2425

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

Cap Gemini,

2181

ABOUT IDENTITY?

HCL,

2051

How to select the name of employee who is getting maximum sal with out using subquery

15 15995

how can create the lexical parameter after the select class?

Oracle,

1 5267

Explain prerequisites and post activities of oracle database installation

2126

Why required to run root.sh at the time of installation and what exactly it will do

1 5092

How to clone the database using RMAN back

2225

i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

HCL, IBM,

7 12951

1.display list of all users from ur data base.what is the query?

CGI, IBM,

3 7839

What are the mandatory setups in setting up a PO in oracle

Silicon,

1 4070

Un-Answered Questions { Oracle }

How to define Data Block size in Oracle?

1108

Explain the function of optimizer in oracle?

1134

What happens to the data files if a tablespace is dropped?

1059

How much memory your 10g xe server is using?

1097

What does an oracle dba do?

597

What are database skills?

581

Explain for repository?

578

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2259

What are the different tools that are provided by oracle to assist performance monitoring?

What is the recommended interval at which to run statspack snapshots, and why?

2914

Which is faster join or subquery in oracle?

986

Have you used lexical parameters in reports?

How can we use tkprof?

What are operators in oracle?

1053

How to view the data files in the current database?

1094

For More Un-Answered { Oracle } Questions Click Here