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

Difference between open_form and call_form in oracle.

1159

Explain an exception and its types?

1073

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

1025

Explain the use of record length option in exp command.

1067

What is control file used for?

1207

Explain the use of inctype option in exp command.

1034

what are actual and formal parameters?

1104

Differentiate between translate and replace?

1116

Explain the use of rows option in imp command.

1085

Explain the use of rows option in exp command.

1090

Explain the use of tables option in exp command.

1115

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

1037

Explain the use of full option in exp command.

1116

Difference between pre-select and pre-query

1106

Explain an exception?

993

Un-Answered Questions { Oracle }

What is the placeholder column?

How many knowledge modules you used?

594

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1194

as a technical developer in oracle applications which type errors feced in your experience sofar

2329

key flexfield structure

2176

Describe varray?

1057

What is an oracle database?

1035

You are getting busy buffer waits. Is this bad? How can you find what is causing it?

537

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

590

what exactly u write in when_new_form_instance

3444

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

1083

What are the different types of failures that occur in Oracle database?

1067

What do you understand by row chaining?

What are joins, explain all types of joins?

2299

What do you mean by cdb and pdb in oracle 12c?

1059

For More Un-Answered { Oracle } Questions Click Here