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 can Oracle users be audited?

MCN Solutions,

1106

What is recovery manager(rman) backup in Oracle?

MCN Solutions,

1183

What is backup in Oracle?

MCN Solutions,

998

What is transaction control statement and how many types of transaction control statement in Oracle?

MCN Solutions,

1151

Give syntax for SQL and ORACLE joins.

TCS,

1092

What is Segment Advisor in Oracle?

MCN Solutions,

1101

What is SQL Tuning Advisor in Oracle?

MCN Solutions,

1173

What is MTTR advisor in Oracle?

MCN Solutions,

1090

How many types of cluster table in Oracle?

MCN Solutions,

1030

How to get the Installed Oracle Version Information ?

MCN Solutions,

1119

What is flashback in Oracle?

MCN Solutions,

1015

What is the difference between PFILE and SPFILE in Oracle?

MCN Solutions,

1060

How to check database size in Oracle?

MCN Solutions,

1189

What is catalog in Oracle?

MCN Solutions,

1359

What is archive log in Oracle?

MCN Solutions,

1131

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Why do you use stored procedures and state some of its disadvantages?

1026

What is save point in oracle database?

1289

What is a database schema in oracle?

1107

How to define a data field as not null?

1106

What is a named program unit?

1070

What is an oracle recycle bin?

1007

What is an oracle wallet?

942

what happened to the global index when I truncate the data in one of the partition?

2018

Explain the use of compress option in exp command.

1019

What are the varoius components of physical database structure of oracle database?

1004

Can we save images in a database and if yes, how?

1061

What happens to the current transaction if the session is ended?

1096

What do database buffers contain?

1023

What is the difference between Delete, Truncate and Drop in Oracle?

1129

What is MTTR advisor in Oracle?

1090

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