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

How can you merge two tables in oracle?

955

How to store pictures on to the database?

934

Explain temporal data types in oracle

1053

List out the difference between commit, rollback, and savepoint?

1001

Does rowid change in oracle?

1 1334

Is rowid unique in oracle?

964

Is primary key indexed by default in oracle?

949

What are triggers in oracle?

985

What is max rowid in oracle?

985

What is oracle rowcount?

1049

What is oracle rownum?

903

What is oracle analytical function?

1057

What is rowid and rownum in oracle?

969

What is bulk collect in oracle?

968

What is truncate oracle?

932

Un-Answered Questions { Oracle }

What are the attributes of the cursor?

952

Mention how can you determine what protocol is being used for interconnect traffic?

Why do we need a database?

552

What is the difference between alert log file and tarce file ?

2118

What is the difference between view and materialized view in Oracle?

1107

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2134

what is dynamic SGA and static SGA

4355

What are advantages of dateset in datastage?

2216

What is the difference between substr and instr?

997

How will you run ms_batch file in forms?

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

1255

How can you determine if an oracle instance is up from the operating system level?

525

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2190

hiding item in report how like that properly,thats manually but at runtime i want to do

3171

How to check the oracle tns settings?

1006

For More Un-Answered { Oracle } Questions Click Here