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

Oracle AllOther Interview Questions

Questions Answers Views Company eMail

Where would you look for errors from the database engine?

Fintellix,

2 12067

Compare and contrast TRUNCATE and DELETE for a table.

3 7436

Give the reasoning behind using an index.

2 6256

Give the two types of tables involved in producing a star schema and the type of data they hold.

1 3862

What type of index should you use on a fact table?

1 8149

Give two examples of referential integrity constraints.

1 4807

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

3 15061

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

HCL,

1 8071

What command would you use to create a backup control file?

1 8701

Give the stages of instance startup to a usable state where normal users may access it.

1 5136

How would you go about generating an EXPLAIN plan?

Satyam,

1 4864

How would you go about increasing the buffer cache hit ratio?

2608

Explain an ORA-01555

2 7089

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7684

How would you determine the time zone under which a database was operating?

1 5199

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

how to write customizations in po

1622

Difference between negative and positive adjustments : oracle accounts receivable

1108

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2265

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2080

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

1037

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?

2418

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2029

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1781

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1267

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2957

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1352

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17655

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2501

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2329

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

2079

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