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 12030

Compare and contrast TRUNCATE and DELETE for a table.

3 7410

Give the reasoning behind using an index.

2 6224

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

1 3854

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

1 8138

Give two examples of referential integrity constraints.

1 4795

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 15031

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

HCL,

1 8045

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

1 8686

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

1 5122

How would you go about generating an EXPLAIN plan?

Satyam,

1 4845

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

2593

Explain an ORA-01555

2 7066

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7666

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

1 5171

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

What is the disk migration? what is the steps involved in oracle disk migration?

1218

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

1769

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

1208

Explain the use of table functions.

2470

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

1151

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

2493

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.

2510

which one is currently in used software cmpanies.

2145

please send me oracle pl/sql exp resume. and also faqs...

2491

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

1269

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

2096

Are These Dff's Flexible?

1164

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3572

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

2065

what are the tools used for oracle 10g in real time.

2437

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