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 12177

Compare and contrast TRUNCATE and DELETE for a table.

3 7541

Give the reasoning behind using an index.

2 6392

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

1 3921

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

1 8223

Give two examples of referential integrity constraints.

1 4868

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 15190

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

HCL,

1 8186

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

1 8771

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

1 5205

How would you go about generating an EXPLAIN plan?

Satyam,

1 4934

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

2659

Explain an ORA-01555

2 7159

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7779

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

1 5290

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

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

2236

What is the difference between recovery and restoring of the oracle database?

1297

How to clone the database using RMAN back

2318

How would you determine what sessions are connected and what resources they are waiting for?

2180

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2151

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2164

can we use lexical perameter in oracle plsql if yes how

2378

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1324

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

2574

How many segment are present in Oracle Manufacturing

2374

What is autocashrule set? : oracle accounts receivable

1504

default triggers available for reports

2271

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

2382

Give two methods you could use to determine what DDL changes have been made.

6857

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2329

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