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 4377

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

1 10930

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

TCS,

10 54664

Explain the use of table functions.

2463

Name three advisory statistics you can collect.

1 8275

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

2629

Explain materialized views and how they are used.

2 6358

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

1 4896

What background process refreshes materialized views?

1 4743

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

2124

Describe what redo logs are.

1 3841

How would you force a log switch?

1 3630

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

1 6762

What does coalescing a tablespace do?

2 19605

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

2 22526

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

types of receipts and detail desription about recipts and tables effected by receipts?

2070

What is the difference between recovery and restoring of the oracle database?

1212

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2459

key flexfield structure

2167

What is autocashrule set? : oracle accounts receivable

1388

Differentiate between transaction type and transaction source? : oracle accounts receivable

1113

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2063

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

2063

Explain prerequisites and post activities of oracle database installation

2124

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7656

What is mrc and what is its use? : oracle accounts receivable

1202

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

1122

What is db_recovery_file_dest in oracle? When do you need to set this value?

1123

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1038

Explain the process of recievables in oracle financials. : oracle accounts receivable

1151

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