Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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.

1113

In what sequence do triggers get fired by oracle forms?

1027

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

1155

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

1208

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

1060

List the different types of columns in oracle reports.

1053

Explain master-detail relationship with some examples.

1057

What is the difference between bind and lexical parameter?

1129

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

1179

How can we generate report output in excel format?

1041

Why oracle forms required?

1095

What is an oracle report?

1124

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

1071

What is oracle and what are its different editions?

1122

What is the difference between substr & instr functions?

1297

Un-Answered Questions { Oracle }

How to get maxsal , minsal, ename department wise in single query

1607

How many types of tables supported by oracle?

1126

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2148

how to handle exceptions in post production

1486

What is the usage of merge statement?

1210

How to compare dates in oracle sql?

1162

What is a relational database management system?

1175

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1754

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2517

What is oracle host variable?

1137

What is logical backup in oracle?

1087

What is the dynamic sql in oracle?

1139

Is it possible to have multiple layouts in a report?

1094

How can I see all tables in oracle?

1063

What is oracle in java?

1020

For More Un-Answered { Oracle } Questions Click Here