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

4370

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

6 17140

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

2106

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,

2166

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

iGate,

2429

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,

2193

ABOUT IDENTITY?

HCL,

2064

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

15 16076

how can create the lexical parameter after the select class?

Oracle,

1 5281

Explain prerequisites and post activities of oracle database installation

2139

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

1 5112

How to clone the database using RMAN back

2245

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

HCL, IBM,

7 12993

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

CGI, IBM,

3 7857

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

Silicon,

1 4082

Un-Answered Questions { Oracle }

How many types of km's? And you what are the type's km are used in your project?

577

what is the difference between restoring and recovering?

1014

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

2138

Is truncate autocommit in oracle?

1091

What is table partitioning and why is it required?

What is the difference between alert log file and tarce file ?

2173

What are the types of profiles in ODI?

597

What do database buffers contain?

1041

from where do u receive the information to develop report

2015

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2316

Explain the use of show option in imp command.

1099

How to work with data objects interactively?

992

How to connect asp pages to oracle servers?

1075

What is the order of defining local variables and sub procedures/functions?

1061

Which flexfields you have customized?

For More Un-Answered { Oracle } Questions Click Here