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 3714

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 3442

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

 4 5202

DBMS vs. RDBMS

TCS,

2 4422

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 5867

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

L&T,

2145

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

L&T,

1549

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 2956

Why we choose emp number as primarykey?

 4 5032

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

 6167

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 4632

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

 1 3772

Which Department has MOST NUMBER of employees?

IBM, LeadSquared, Mastek,

8 47887

Un-Answered Questions { Oracle }

What is the relation of a user account and a schema in oracle?

590

What are the built-in functions used for sending Parameters to forms ?

2844

What skills does a dba need?

309

What is proxy method?

542

Which environment variables are absolutely critical in order to run the OUI?

1658




How to use "while" statements in oracle?

737

How can we view last record added to a table?

601

Explain overloading. Can functions be overloaded?

573

What is oracle partial backup?

308

How many types of table in Oracle?

619

What is a parameter file in oracle?

560

How to store pictures on to the database?

530

How to turn on or off recycle bin for the session?

610

How do I use os authentication with weblogic jdriver for oracle and connection pools?

577

What are the Types of Scd's?

306

For More Un-Answered { Oracle } Questions Click Here