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 11887

Compare and contrast TRUNCATE and DELETE for a table.

3 7277

Give the reasoning behind using an index.

2 6028

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

1 3777

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

1 8046

Give two examples of referential integrity constraints.

1 4715

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 14881

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

HCL,

1 7903

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

1 8622

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

1 5049

How would you go about generating an EXPLAIN plan?

Satyam,

1 4753

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

2542

Explain an ORA-01555

2 6959

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7571

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

1 5014

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

difference of using cursor for loop and open,fetch,close.which one is better

1736

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17496

3. Steps in UAT?

2367

What Are Cross Validation & Adi?

1098

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?

7912

How to clone the database using RMAN back

2145

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.

2261

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4389

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

2015

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2461

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

2219

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2060

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2878

Where in the Oracle directory tree structure are audit traces placed?

2577

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1238

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