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

4366

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

6 17114

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

2103

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,

2163

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,

2186

ABOUT IDENTITY?

HCL,

2057

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

15 16038

how can create the lexical parameter after the select class?

Oracle,

1 5273

Explain prerequisites and post activities of oracle database installation

2132

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

1 5105

How to clone the database using RMAN back

2237

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

HCL, IBM,

7 12967

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

CGI, IBM,

3 7848

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

Silicon,

1 4080

Un-Answered Questions { Oracle }

What is the difference between formal parameters and actual parameters?

1088

Explain the use of dde package in d2k.

What is the data quality in odi?

645

How do you set up tablespaces during an oracle installation?

606

How to synchronize 2 schema's objects?

2181

How can we delete duplicate rows in a table?

973

What is an oracle user account?

990

What is the load balancing advisory?

What are the uses of a database trigger?

994

What are the main benefits of using spfile over pfile?

641

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

668

Hi Can any one tell me what are the API's used in requisition import.

1923

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3200

What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

593

What do you understand by anchoring in reports?

For More Un-Answered { Oracle } Questions Click Here