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.

1048

In what sequence do triggers get fired by oracle forms?

955

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

1088

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.

999

List the different types of columns in oracle reports.

1003

Explain master-detail relationship with some examples.

1004

What is the difference between bind and lexical parameter?

1078

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

1131

How can we generate report output in excel format?

996

Why oracle forms required?

1039

What is an oracle report?

1070

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?

1064

What is the difference between substr & instr functions?

1226

Un-Answered Questions { Oracle }

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

616

Have you used lexical parameters in reports?

How to create lov dynamically at runtime & attach to text field?

1194

Will you be able to store pictures in the database?explain.

992

What are the variable types?

611

How to use subqueries with the exists operator in oracle?

1027

Explain joins in oracle?

1035

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5410

What do you understand by redo log file mirroring?

How to create a new table in your schema?

1081

What is an oracle database table?

1015

What happens if you set the sga too low in oracle?

1147

What is an Oracle SYSTEM tablespace and when is it Created?

1115

How can we tune a sql query to optimize the performance of a database?

What is a dba why is this position necessary?

573

For More Un-Answered { Oracle } Questions Click Here