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 4667

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 4131

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

4 6753

DBMS vs. RDBMS

TCS,

2 5407

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 6717

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

L&T,

2713

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

L&T,

2005

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

Cap Gemini,

2 6907

Which database is better for os platform dependency?

1 3730

Why we choose emp number as primarykey?

4 6609

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

6917

am completed mca2011 how get certification in oracle

1 2959

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 5661

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

1 4453

Which Department has MOST NUMBER of employees?

IBM, LeadSquared, Mastek,

8 51125

Un-Answered Questions { Oracle }

What is a nested table and how is it different from a normal table?

1044

How to create sequence in odi?

643

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2179

How to add a new column to an existing table in oracle?

1135

How to end the current transaction in oracle?

1021

what is the difference between data migration and production migration.

2340

What is the function of having virtual internet protocol address (vip) in oracle rac?

What suggestions do you have to reduce the network traffic?

954

What is rac and what are the various benefits of using rac architecture?

Can we convert a date to char in oracle and if so, what would be the syntax?

1007

How to create an initialization parameter file?

1040

What are property classes?

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2304

What do you mean by a tablespace?

1035

Is oracle a language?

936

For More Un-Answered { Oracle } Questions Click Here