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 11261

Compare and contrast TRUNCATE and DELETE for a table.

3 6744

Give the reasoning behind using an index.

2 5352

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

1 3493

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

1 7793

Give two examples of referential integrity constraints.

1 4411

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 14386

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

HCL,

1 7302

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

1 8260

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

1 4791

How would you go about generating an EXPLAIN plan?

Satyam,

1 4371

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

2267

Explain an ORA-01555

2 6430

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7202

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

1 4642

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

How many segment are present in Oracle Manufacturing

2073

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2020

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

2315

How do you create a credit note against an invoice? : oracle accounts receivable

864

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

1001

3. Steps in UAT?

2193

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2080

What Are Cross Validation & Adi?

908

Can we modify approve purchase order?if yes what is navigation?

1759

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.

3610

as a technical developer in oracle applications which type errors feced in your experience sofar

2119

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2077

8. Supporting AP, AR and GL?

2080

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7719

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

842

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