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 3994

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 13678

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

HCL,

1 6668

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 4399

How would you go about generating an EXPLAIN plan?

Satyam,

1 4021

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

 1946

Explain an ORA-01555

 2 5673

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 4235

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

706

What is the use of lockboxes? : oracle accounts receivable

643

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

707

What is autocashrule set? : oracle accounts receivable

717

1. What is PO rate variance gain and loss?

2304




Are These Dff's Flexible?

727

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

2047

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3322

default triggers available for reports

1751

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

745

what is difference between inner join & nested query or subqueries

2477

Could you please let me know the interfaces in OM / FA??

1732

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

1835

What is db_recovery_file_dest in oracle? When do you need to set this value?

642

Explain how to close periods in ar. : oracle accounts receivable

695

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