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

Difference between open_form and call_form in oracle.

1224

Explain an exception and its types?

1141

What are the different types of record groups in oracle? Explain each of them

1077

Explain the use of record length option in exp command.

1128

What is control file used for?

1310

Explain the use of inctype option in exp command.

1086

what are actual and formal parameters?

1167

Differentiate between translate and replace?

1197

Explain the use of rows option in imp command.

1143

Explain the use of rows option in exp command.

1150

Explain the use of tables option in exp command.

1172

Differentiate between post-database commit and post-form commit?

1094

Explain the use of full option in exp command.

1179

Difference between pre-select and pre-query

1179

Explain an exception?

1065

Un-Answered Questions { Oracle }

State and explain about oracle instance?

1053

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1837

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2106

3. Steps in UAT?

2482

What is the use of the Service Knowledge module?

640

What is the difference between primary key and unique key and foreign key in oracle?

1037

What is an Oracle index?

1709

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

2401

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2290

What is olr?

How to declare a local variable?

1178

What is an Oracle Rollback Segment?

1169

In what script is snap$ created? In what script is the scott/tiger schema created?

2763

Explain what does a control file contain?

1166

Which profile required to access ODI Console?

646

For More Un-Answered { Oracle } Questions Click Here