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,

1156

Give syntax for SQL and ORACLE joins.

TCS,

1092

What is Segment Advisor in Oracle?

MCN Solutions,

1104

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 the use of file param in imp command?

1165

How to upsert (update or insert into a table)?

999

What are the database administrators utilities available?

1031

What are the types of trigger in oracle?

982

When do you get a .pll extension in oracle?

1146

How to connect ms access to oracle servers?

1007

Explain about the analyze command in oracle?

1052

What are the various constraints used in oracle?

1045

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1017

Explain alias?

1151

Query to retrieve record for a many to many relationship ?

2519

What is a sub query? Describe its types?

1017

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1988

Why is oracle so popular?

997

What is parameterized cursor in oracle?

1150

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