1. Categories >> Software >> Databases >> Oracle >> Oracle AllOther
  2. Suggest New Category
Oracle AllOther Interview Questions
Questions Answers Views Company eMail

Where would you look for errors from the database engine?

Fintellix,

2 10486

Compare and contrast TRUNCATE and DELETE for a table.

 3 6148

Give the reasoning behind using an index.

 2 4809

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

 1 3177

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

 1 7469

Give two examples of referential integrity constraints.

 1 3995

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 13680

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

HCL,

1 6669

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

 1 7827

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

 1 4400

How would you go about generating an EXPLAIN plan?

Satyam,

1 4022

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

 1946

Explain an ORA-01555

 2 5674

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

 2 6719

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

 1 4237

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

724

what is difference between inner join & nested query or subqueries

2477

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?

693

how to write customizations in po

1188

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

619




which one is currently in used software cmpanies.

1651

where the dff data will be stored

1795

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

669

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

648

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

708

Explain the use of table functions.

1785

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

1697

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

716

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

635

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

1576

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