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

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

3865

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

6 14980

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

1652

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,

1661

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

iGate,

1985

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,

1646

ABOUT IDENTITY?

HCL,

1553

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

15 12160

how can create the lexical parameter after the select class?

Oracle,

1 4382

Explain prerequisites and post activities of oracle database installation

1616

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

1 4275

How to clone the database using RMAN back

1615

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

HCL, IBM,

7 10790

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

CGI, IBM,

3 6383

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

Silicon,

1 3209

Un-Answered Questions { Oracle }

Can we commit inside a function in oracle?

556

what are archived logs?

1712

What are ddl statements in oracle?

590

What is a dba?

281

What is max rowid in oracle?

551

How to use windows user to connect to the server?

530

What is the parameter mode that can be passed to a procedure?

568

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1854

What are a cluster and non-cluster index?

572

What is proxy method?

540

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

267

How would you identify the shared_pool_size parameter that needs to be adjusted?

What happens in oracle commit?

561

Explain the designer?

339

How to use "in" parameter properly?

617

For More Un-Answered { Oracle } Questions Click Here