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

Use of an integrity constraint is better to validate data. Explain

1099

Explain the importance of .pll extension in oracle?

1064

Explain the use of indexes option in exp command.

1213

When do you get a .pll extension in oracle?

1195

Can we protect our pl/sql source code?

1086

What is analyze command used for?

1128

What is merge statement used for?

1079

Explain the use of consistent option in exp command.

1146

Explain the use of indexes option in imp command.

1268

what is the use of system.effective.date variable in oracle?

1166

Explain the types of exception?

1199

When do you get a .pll extension in oracle? Explain its importance

1103

What are the various types of snapshots ?

1086

Explain the use of ignore option in imp command.

1090

What is the purpose of save points in oracle database?

1211

Un-Answered Questions { Oracle }

i am writing a query select EmpNo from Emp how can i call in after parameter form

2196

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1209

How a database is related to tablespaces?

1086

What is the relation between database and instance?

703

which one is currently in used software cmpanies.

2203

What does the no logging option do? Why would we be careful of using it?

661

What are the differences between char and varchar2 in oracle?

1251

Explain oracle insert into command?

1160

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

2211

What are the various benefits of using rac architecture?

What is a dba why is this position necessary?

621

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2517

How many types of knowledge Modules? Where are used in km?

662

What are four common errors found in an alert .log?

600

Is postgres faster than oracle?

1089

For More Un-Answered { Oracle } Questions Click Here