Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What is backup in Oracle?

MCN Solutions,

1084

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

MCN Solutions,

1244

Give syntax for SQL and ORACLE joins.

TCS,

1149

What is Segment Advisor in Oracle?

MCN Solutions,

1149

What is SQL Tuning Advisor in Oracle?

MCN Solutions,

1258

What is MTTR advisor in Oracle?

MCN Solutions,

1145

How many types of cluster table in Oracle?

MCN Solutions,

1084

How to get the Installed Oracle Version Information ?

MCN Solutions,

1191

What is flashback in Oracle?

MCN Solutions,

1065

What is the difference between PFILE and SPFILE in Oracle?

MCN Solutions,

1113

How to check database size in Oracle?

MCN Solutions,

1259

What is catalog in Oracle?

MCN Solutions,

1443

What is archive log in Oracle?

MCN Solutions,

1187

Can we connect to ORACLE db using Windows Authentication?

MCN Solutions,

1310

What is memory advisor in Oracle?

MCN Solutions,

1136

Un-Answered Questions { Oracle }

What is data store? How to create data store?

690

What does an oracle dba do?

649

How to get / select the nth row from the table?

How to define a data source name (dsn) in odbc manager?

1085

How to list all indexes in your schema?

1148

What are the different pseudo commands? Explain in general?

1129

Explain rename?

1048

What are the uses of Oracle Rollback Segment?

1179

State the difference between a primary key and foreign key?

999

What is the scd? and Types of SCD?

675

What is the difference between restoring a database and recovering a database?

How to divide query output into groups in oracle?

1039

How to rename a tablespace in oracle?

1130

How to turn on or off recycle bin for the session?

1180

How oracle flex asm works?

For More Un-Answered { Oracle } Questions Click Here