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

can you explain performance tunning in oracle(sql,PL/SQL)

2 4673

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 4137

Can we get the deleted Record again if the delete transaction has been committed.

4 6770

DBMS vs. RDBMS

TCS,

2 5426

WHAT IS THE ORACLE FORM TRIGGER WHICH CAN BE FIT IN ALL THREE LEVELS i.e., IN FORM LEVEL, BLOCK LEVEL AND ITEM LEVEL ?

TATA, TCS,

1 6727

Is there any link between pr form(purchse requisition)and po form(purchase order)

L&T,

2726

Can we modify approve purchase order?if yes what is navigation?

L&T,

2010

HI GURUS, WHAT IS THE PURPOSE OF LEXICAL PARAMETER IN REPORT DEVELOPMENT.

Cap Gemini,

2 6920

Which database is better for os platform dependency?

1 3741

Why we choose emp number as primarykey?

4 6619

I am using oracle developer suit(form 10g), On used ole2 objects to initialize excel and worksheet and on "BEFORE REPORT" i am printing report heading in excel using OLE2 objects only. if i run report from developer suit report builder it give output in excel normally and what expected but when ever i put same report on server and run report from application it gives error : " Terminated with error :
REP-1401 'before report': FATAL pl/sql error occured. ORA-43356; message 43356 not found; Product=RDBMS; facility = ORA." Please reply it is urgent

6923

am completed mca2011 how get certification in oracle

1 2966

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

Polaris,

3 5674

Suppose I want to fire block level sequence before form level, then is it possible?

1 4464

Which Department has MOST NUMBER of employees?

IBM, LeadSquared, Mastek,

8 51148

Un-Answered Questions { Oracle }

how to write the sub-queries in odi?

704

How can I combine multiple rows into a comma-delimited list in oracle?

1062

How do I limit the number of oracle database connections generated by weblogic server?

1070

Why we use oracle d2k?

Can we store pictures in the database and if so, how it can be done?

1044

What is the difference between online and offline backups?

1059

What is a schema in oracle?

1013

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2221

What is using clause and give example?

1044

Explain the truncate in oracle?

967

What's dateware house and what's clustor with practicle example

2175

ABOUT IDENTITY?

2058

Explain force logging feature in 9i.

608

What are the various oracle database objects?

1144

What is the advantage of using rman?

722

For More Un-Answered { Oracle } Questions Click Here