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,

1115

What is recovery manager(rman) backup in Oracle?

MCN Solutions,

1185

What is backup in Oracle?

MCN Solutions,

1004

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

MCN Solutions,

1155

Give syntax for SQL and ORACLE joins.

TCS,

1092

What is Segment Advisor in Oracle?

MCN Solutions,

1103

What is SQL Tuning Advisor in Oracle?

MCN Solutions,

1179

What is MTTR advisor in Oracle?

MCN Solutions,

1090

How many types of cluster table in Oracle?

MCN Solutions,

1034

How to get the Installed Oracle Version Information ?

MCN Solutions,

1125

What is flashback in Oracle?

MCN Solutions,

1019

What is the difference between PFILE and SPFILE in Oracle?

MCN Solutions,

1060

How to check database size in Oracle?

MCN Solutions,

1191

What is catalog in Oracle?

MCN Solutions,

1365

What is archive log in Oracle?

MCN Solutions,

1134

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is bind variable in oracle 11g?

1039

How to speed up webrick?

1076

What are the differences between char and varchar2 in oracle?

1170

How to create a temporary table in oracle?

1267

What is Library Cache in Oracle?

1142

How to see free space of each tablespace?

1034

What is the use of aggregate functions in oracle?

1026

what is the difference between restoring and recovering?

1011

List out the components of logical database structure of oracle database.

1035

How to create an oracle database manually?

1085

How to view the data files in the current database?

1098

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1840

How to bring a tablespace online?

1079

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2204

Is primary key indexed by default in oracle?

987

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