1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

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

 2 3721

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 3446

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

 4 5204

DBMS vs. RDBMS

TCS,

2 4427

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 5873

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

L&T,

2150

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

L&T,

1551

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

Cap Gemini,

2 5743

Which database is better for os platform dependency?

 1 2957

Why we choose emp number as primarykey?

 4 5040

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

 6170

am completed mca2011 how get certification in oracle

 1 2336

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 4641

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

 1 3778

Which Department has MOST NUMBER of employees?

IBM, LeadSquared, Mastek,

8 47915

Un-Answered Questions { Oracle }

what is difference between sql plus and sql*plus? (not sql and sql plus).

3351

When should an artificial (or derived) primary key be used?

335

When system tablespace is created?

606

Which is the best option used to move database from one server to another serve on same network and why?

257

How is it different from a normal table?

582




What is responsibility and how u attach How to create user and how u attach with responsibility.

1623

What are types of data model?

292

What is the purpose of save points in oracle database?

545

Why do we need object libraries?

1

What are set operators?

648

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

2278

What should a dba know?

267

How to unlock the sample user account in oracle?

558

How to define an anonymous procedure with variables?

547

why dont we assign not null constraint as table level constraint.

2257

For More Un-Answered { Oracle } Questions Click Here