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

Oracle General Interview Questions

Questions Answers Views Company eMail

how to hide the stored procedure inside a package

1 2115

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

Oracle,

1106

What is the difference between online and offline backups?

MCN Solutions,

1052

what is the difference between restoring and recovering?

MCN Solutions,

1009

What are the most common interview questions on ETL Testing for experience?

1140

In oracle there is column command, how will you explain that?

Aricent,

1049

State any two functions of oracle?

Aricent,

1044

What is Virtual Private Database in Oracle?

MCN Solutions,

1085

Can we create database in oracle using command line ?

MCN Solutions,

1083

Why use resource manager in Oracle?

MCN Solutions,

1103

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

MCN Solutions,

1149

What is Undo Management Advisor in Oracle?

MCN Solutions,

1093

What is Redo Log Buffer in Oracle?

MCN Solutions,

1201

What is clustered table in Oracle?

MCN Solutions,

1190

What is data block in Oracle?

MCN Solutions,

1114

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Which is better Oracle or MS SQL? Why?

4933

What are the differences between blob and clob in oracle?

1086

What is truncate oracle?

971

How can windows applications connect to oracle servers?

1052

What is an Oracle Instance?

1118

What is blob datatype?

1124

Why do you create or replace procedures rather that drop and recreate.

1003

How to change user password in oracle?

1024

Explain a data segment?

1064

what is the use of system.effective.date variable in oracle?

1111

Write a syntax for update query in oracle?

1031

State the difference between a primary key and foreign key?

933

Explain an extent?

1095

what is difference between sql plus and sql*plus? (not sql and sql plus).

3893

Can sub procedure/function be called recursively?

996

For More Un-Answered { Oracle General } Questions Click Here