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 12049

Compare and contrast TRUNCATE and DELETE for a table.

3 7416

Give the reasoning behind using an index.

2 6241

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 8143

Give two examples of referential integrity constraints.

1 4795

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 15044

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

HCL,

1 8057

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

1 8693

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

1 5126

How would you go about generating an EXPLAIN plan?

Satyam,

1 4853

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

2597

Explain an ORA-01555

2 7076

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7670

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

1 5188

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

Why more redos are generated when the oracle database is in begin backup mode?

1120

can we use lexical perameter in oracle plsql if yes how

2313

what are basic modules required to implement oracle application in any oraganisation?

2207

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

1391

Explain the use of table functions.

2482

What is the difference between conversions and interfaces? : oracle accounts receivable

1230

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

2597

Are These Dff's Flexible?

1170

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2194

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

1221

Difference between transaction type and transaction sources. : oracle accounts receivable

1032

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2061

what is semphore explian it?

2815

key flexfield structure

2176

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

17641

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