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 2195

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,

1158

What is the difference between online and offline backups?

MCN Solutions,

1130

what is the difference between restoring and recovering?

MCN Solutions,

1052

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

1189

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

Aricent,

1135

State any two functions of oracle?

Aricent,

1093

What is Virtual Private Database in Oracle?

MCN Solutions,

1147

Can we create database in oracle using command line ?

MCN Solutions,

1129

Why use resource manager in Oracle?

MCN Solutions,

1172

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

MCN Solutions,

1203

What is Undo Management Advisor in Oracle?

MCN Solutions,

1151

What is Redo Log Buffer in Oracle?

MCN Solutions,

1277

What is clustered table in Oracle?

MCN Solutions,

1257

What is data block in Oracle?

MCN Solutions,

1148

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is index in Oracle?

1128

How to define a variable of a specific record type?

1113

What is an anonymous block?

1323

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2100

What are the differences between number and binary_float in oracle?

1147

does the query needs a hint to access a materialized view?

1905

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2061

How to select some columns from a table in oracle?

1169

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1095

How to put more than 1000 values into an oracle in clause?

1085

What is proxy method?

1020

What is a trigger and what are its types in oracle?

1150

What is the relation of a user account and a schema in oracle?

1126

What is object data modeling?

1015

List out the types of joins.

1236

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