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

What is meant by recursive hints in oracle?

1135

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

1098

Explain the use of file option in exp command.

1180

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

1310

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

1333

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

1348

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

1075

What is the use of lockboxes? : oracle accounts receivable

1270

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

1383

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

1383

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

1261

Difference between negative and positive adjustments : oracle accounts receivable

1166

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

1194

Explain about party and customer in ar : oracle accounts receivable

1272

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

1375

Un-Answered Questions { Oracle }

What is the difference between single instance environment and rac environment?

How do you analyze the tables

IS it possible to built the oracle database without setting the kernal parameters?

2399

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

1077

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1894

How to write text literals in oracle?

1126

What is the sequence of firing in form level trigger?

Can we connect to ORACLE db using Windows Authentication?

1311

Explain temporal data types in oracle

1135

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

1103

Where are the settings stored for each instance in oracle?

1158

How to work with data objects interactively?

1045

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

657

How to increment dates by 1 in oracle?

1140

What are the oracle differences between nvl and coalesce

1243

For More Un-Answered { Oracle } Questions Click Here