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 4683

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 4143

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

4 6778

DBMS vs. RDBMS

TCS,

2 5438

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 6733

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

L&T,

2730

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 6929

Which database is better for os platform dependency?

1 3748

Why we choose emp number as primarykey?

4 6633

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

6928

am completed mca2011 how get certification in oracle

1 2977

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 5680

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

1 4470

Which Department has MOST NUMBER of employees?

IBM, LeadSquared, Mastek,

8 51169

Un-Answered Questions { Oracle }

How to count groups returned with the group by clause in oracle?

1081

How do you create a credit note against an invoice? : oracle accounts receivable

1088

What is a private synonym?

1593

What do you understand by lov?

1040

Can a View based on another View in Oracle?

1034

suppose I having 6 interfaces and running the interface 3 rd one failed how to run remaining interfaces?

801

What is temporary Interface( Yellow Interface) ?

568

How you find which the latest record in SCD type2 transformation is?

586

What view would you use to determine free space in a tablespace?

2226

What is the maximum number of triggers that can be applied to a single table?

1029

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1133

Does oracle charge for java?

1060

What is required by oracle rac database to connect to a network?

What is SQL Tuning Advisor in Oracle?

1185

What is an oracle function?

1172

For More Un-Answered { Oracle } Questions Click Here