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

Oracle General (1809)
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

1041

Explain the importance of .pll extension in oracle?

1011

Explain the use of indexes option in exp command.

1149

When do you get a .pll extension in oracle?

1146

Can we protect our pl/sql source code?

1045

What is analyze command used for?

1073

What is merge statement used for?

1024

Explain the use of consistent option in exp command.

1068

Explain the use of indexes option in imp command.

1179

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

1116

Explain the types of exception?

1143

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

1042

What are the various types of snapshots ?

1029

Explain the use of ignore option in imp command.

1035

What is the purpose of save points in oracle database?

1119

Un-Answered Questions { Oracle }

In topology manager where the data are stored?

677

What are the benefits of oracle rac?

Components of Oracle Data Integrator?

548

What do you understand by lov and how can it be used?

1092

what is difference between inner join & nested query or subqueries

3035

What is concurrency in oracle?

1008

What is a database schema in oracle?

1110

How to define an anonymous procedure without variables?

1107

Can group functions be mixed with non-group selection fields?

1020

What is the use of Oracle Control File?

1074

What are the oracle built-in data types?

1074

What is the exact use of Collections?

2143

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2355

What is difference between sid and service name in oracle?

956

How many types of km's?

584

For More Un-Answered { Oracle } Questions Click Here