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

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

2 4797

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 4233

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

4 6940

DBMS vs. RDBMS

TCS,

2 5525

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 6800

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

L&T,

2794

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

L&T,

2078

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

Cap Gemini,

2 7030

Which database is better for os platform dependency?

1 3840

Why we choose emp number as primarykey?

4 6821

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

6983

am completed mca2011 how get certification in oracle

1 3067

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 5823

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

1 4552

Which Department has MOST NUMBER of employees?

IBM, LeadSquared, Mastek,

8 51457

Un-Answered Questions { Oracle }

Give syntax for SQL and ORACLE joins.

1149

How to convert a string to a date in oracle database?

1105

What is oracle partial backup?

640

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

3104

What is table partitioning and why is it required?

How to define an external table with a text file?

1129

What is the difference between post-database commit and post-form commit?

1288

How to get last row id?

1062

Explain the types of record group.

How can a single instance environment be converted into rac environment and how will they be different?

What is an SQL FORMS ?

2841

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

634

how report can be generated if we have the database designed in oracle 10g?

1945

What is varray?

1202

How to drop an index in oracle?

1122

For More Un-Answered { Oracle } Questions Click Here