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

What is meant by recursive hints in oracle?

1086

List out the components of logical database structure of oracle database.

1035

Explain the use of file option in exp command.

1129

What is the difference between conversions and interfaces? : oracle accounts receivable

1231

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1276

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1294

Difference between transaction type and transaction sources. : oracle accounts receivable

1032

What is the use of lockboxes? : oracle accounts receivable

1208

Explain how to close periods in ar. : oracle accounts receivable

1312

What is chargeback invoice? How do we create it? : oracle accounts receivable

1333

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

1194

Difference between negative and positive adjustments : oracle accounts receivable

1104

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1145

Explain about party and customer in ar : oracle accounts receivable

1208

What are different types of transactions in ar? : oracle accounts receivable

1295

Un-Answered Questions { Oracle }

What is tns entry?

1151

How to invoke the original export import utilities?

1064

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

616

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1051

What are the different tools that are provided by oracle to assist performance monitoring?

How to calculate date and time differences in oracle?

1042

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1209

WHAT IS ecc 6.0

2147

explain what is odi?why is it different from the other etl tools.

619

What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2135

What is a directory object?

1097

What are operators in oracle?

1055

Can we invoke one form from another in a multi-forms application?

1131

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2310

For More Un-Answered { Oracle } Questions Click Here