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

Is it possible to execute a dynamic sql from forms?

1069

what are the oracle forms services components include?

1023

Explain how can you use the same lov for 2 columns?

1128

List out the oracle forms configuration files?

1072

what is oracle forms?

1104

Explain how one can iterate through items and records in a specified block?

1125

what is the difference between call_form, new_form and open_form?

1307

what are the new features introduced in oracle form services in 11g release 2?

1036

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1295

what are bind variables?

1087

what is the sequence of firing triggers in forms?

1 1600

What do you mean by a tablespace?

1039

Explain the blob datatype?

1071

Explain rename?

978

List the various oracle database objects?

1057

Un-Answered Questions { Oracle }

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2183

How can you find all the processes on your system?

570

how to replace not in with not exist?

3737

all steps of bitmap report?

2353

What are the execution control statements?

1063

In what script is snap$ created? In what script is the scott/tiger schema created?

2708

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2129

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

590

why dont we assign not null constraint as table level constraint.

2737

How many types of tables are there in oracle?

1061

How to connect to oracle using service name instead of sid?

1024

How can a single instance environment be converted into rac environment and how will they be different?

Explain drop constraint oracle?

1067

What is the oracle implicit cursor?

1062

What is oracle server autotrace in oracle?

1166

For More Un-Answered { Oracle } Questions Click Here