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

Oracle AllOther Interview Questions

Questions Answers Views Company eMail

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 4472

What command would you use to encrypt a PL/SQL application?

1 11033

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

TCS,

10 55178

Explain the use of table functions.

2588

Name three advisory statistics you can collect.

1 8368

Where in the Oracle directory tree structure are audit traces placed?

2707

Explain materialized views and how they are used.

2 6482

When a user process fails, what background process cleans up after it?

1 5001

What background process refreshes materialized views?

1 4845

How would you determine what sessions are connected and what resources they are waiting for?

2180

Describe what redo logs are.

1 3950

How would you force a log switch?

1 3729

Give two methods you could use to determine what DDL changes have been made.

1 6857

What does coalescing a tablespace do?

2 19740

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 22667

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2458

1. What is PO rate variance gain and loss?

3015

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1173

What is an Oracle database Full Backup?

1178

Explain the use of table functions.

2588

What is auto invoicing? : oracle accounts receivable

1240

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2267

8. Supporting AP, AR and GL?

2362

Explain the payment term in ar. : oracle accounts receivable

1155

What is auto invoicing? Explain : oracle accounts receivable

1174

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2211

Difference between negative and positive adjustments : oracle accounts receivable

1164

What is Tax Categories?

2162

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

2236

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

1381

For More Un-Answered { Oracle AllOther } Questions Click Here