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 1999

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,

1047

What is the difference between online and offline backups?

MCN Solutions,

974

what is the difference between restoring and recovering?

MCN Solutions,

965

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

1079

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

Aricent,

969

State any two functions of oracle?

Aricent,

984

What is Virtual Private Database in Oracle?

MCN Solutions,

1017

Can we create database in oracle using command line ?

MCN Solutions,

1031

Why use resource manager in Oracle?

MCN Solutions,

1052

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

MCN Solutions,

1094

What is Undo Management Advisor in Oracle?

MCN Solutions,

1042

What is Redo Log Buffer in Oracle?

MCN Solutions,

1127

What is clustered table in Oracle?

MCN Solutions,

1108

What is data block in Oracle?

MCN Solutions,

1050

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is bulk collect in oracle?

958

How to pass parameters to procedures?

975

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2434

How to find out what oracle odbc drivers are installed?

979

What are ddl statements in oracle?

1018

How to get the Installed Oracle Version Information ?

1075

What is the difference between PFILE and SPFILE in Oracle?

996

How can we force the database to use the user specified rollback segment?

1069

How do I escape a reserved word in oracle?

1132

What is the difference between online and offline backups?

974

What is a tns service name?

945

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1999

What is procedure overloading in oracle?

994

What privilege is needed for a user to insert rows to tables in another schema?

957

In the oracle version 9.3.0.5.0, what does each number shows?

1227

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