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

Explain the different levels at which oracle form services interact.

1055

In what sequence do triggers get fired by oracle forms?

957

What do you understand by lov and how can it be used?

1090

What is a matrix report and how many minimum groups are required to prepare the same?

1139

Name the different triggers associated with oracle forms having a master-detail relationship.

1000

List the different types of columns in oracle reports.

1003

Explain master-detail relationship with some examples.

1006

What is the difference between bind and lexical parameter?

1079

Can we invoke one form from another in a multi-forms application?

1132

How can we generate report output in excel format?

997

Why oracle forms required?

1042

What is an oracle report?

1071

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

1015

What is oracle and what are its different editions?

1065

What is the difference between substr & instr functions?

1228

Un-Answered Questions { Oracle }

How to connect the oracle server as sysdba?

1077

which one is currently in used software cmpanies.

2153

What is different types of joins?

1022

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

597

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

587

How to bring a tablespace offline?

1064

Explain about party and customer in ar : oracle accounts receivable

1209

Explain the difference between a procedure and a function? What do you understand by those terms?

1082

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1451

how to handle exceptions in post production

1426

Difference between lexical and bind varible.

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1276

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2261

Difference between ETL and E_LT?

594

What are the extensions used by oracle reports?

1037

For More Un-Answered { Oracle } Questions Click Here