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 2116

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,

1110

What is the difference between online and offline backups?

MCN Solutions,

1059

what is the difference between restoring and recovering?

MCN Solutions,

1011

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

1143

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

Aricent,

1055

State any two functions of oracle?

Aricent,

1046

What is Virtual Private Database in Oracle?

MCN Solutions,

1090

Can we create database in oracle using command line ?

MCN Solutions,

1086

Why use resource manager in Oracle?

MCN Solutions,

1105

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

MCN Solutions,

1155

What is Undo Management Advisor in Oracle?

MCN Solutions,

1098

What is Redo Log Buffer in Oracle?

MCN Solutions,

1209

What is clustered table in Oracle?

MCN Solutions,

1196

What is data block in Oracle?

MCN Solutions,

1116

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2144

Explain rename?

981

What is oracle rowcount?

1084

What is the order of defining local variables and sub procedures/functions?

1061

What is index-organized table in Oracle?

1069

How to export data with a field delimiter?

1039

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

1148

How to drop a stored procedure in oracle?

1051

How can I introduce multiple conditions in like operator?

989

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1929

How to convert characters to numbers in oracle?

1065

how can we store any pdf file in oracle

2164

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1115

How to call a stored function with parameters?

1045

How to enter a new row into a table interactively?

1012

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