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

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

4419

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

6 17405

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

2157

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,

2211

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

iGate,

2481

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,

2269

ABOUT IDENTITY?

HCL,

2112

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

15 16494

how can create the lexical parameter after the select class?

Oracle,

1 5356

Explain prerequisites and post activities of oracle database installation

2185

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

1 5188

How to clone the database using RMAN back

2323

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

HCL, IBM,

7 13172

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

CGI, IBM,

3 8012

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

Silicon,

1 4171

Un-Answered Questions { Oracle }

How translate command is different from replace?

1144

What is the usage of merge statement?

1210

How to do a full database export?

1155

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1194

What Are Cross Validation & Adi?

1208

What is your favorite tool for day-to-day oracle operation?

587

How to divide query output into groups in oracle?

1040

What are the advantages of oracle 12c?

1239

Explain the use of owner option in exp command.

1104

Explain the use of grant option in imp command.

1085

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

3053

Explain the use of grant option in exp command.

1113

Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

Explain an index?

1183

How to call a stored function with parameters?

1098

For More Un-Answered { Oracle } Questions Click Here