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 4387

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

1 10943

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

TCS,

10 54742

Explain the use of table functions.

2485

Name three advisory statistics you can collect.

1 8290

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

2637

Explain materialized views and how they are used.

2 6374

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

1 4898

What background process refreshes materialized views?

1 4761

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

2127

Describe what redo logs are.

1 3854

How would you force a log switch?

1 3635

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

1 6775

What does coalescing a tablespace do?

2 19613

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

2 22541

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2319

What view would you use to determine free space in a tablespace?

2224

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

2067

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

1145

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

1333

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7670

How do you create a credit note against an invoice? : oracle accounts receivable

1083

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2521

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2509

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2280

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2862

key flexfield structure

2176

Explain the payment term in ar. : oracle accounts receivable

1106

What do you mean by hz_ in customer tables? : oracle accounts receivable

1219

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2521

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