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 12057

Compare and contrast TRUNCATE and DELETE for a table.

3 7424

Give the reasoning behind using an index.

2 6245

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

1 3856

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

1 8148

Give two examples of referential integrity constraints.

1 4800

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 15046

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

HCL,

1 8059

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

1 8696

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

1 5128

How would you go about generating an EXPLAIN plan?

Satyam,

1 4856

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

2601

Explain an ORA-01555

2 7076

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7674

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

1 5190

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2189

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

2071

What is the mandatory setup in cyclecount ?

2753

What is auto invoicing? : oracle accounts receivable

1159

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1349

can u give guidance abt packages of plsql

2174

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2399

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2281

What is an Oracle database Partial Backup?

1160

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

1276

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7674

What is an Oracle database Full Backup?

1132

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

2075

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1994

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2955

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