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 12025

Compare and contrast TRUNCATE and DELETE for a table.

3 7403

Give the reasoning behind using an index.

2 6219

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

1 3853

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

1 8134

Give two examples of referential integrity constraints.

1 4792

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 15025

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

HCL,

1 8040

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

1 8677

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

1 5120

How would you go about generating an EXPLAIN plan?

Satyam,

1 4840

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

2593

Explain an ORA-01555

2 7063

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7656

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

1 5164

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1083

What is the mandatory setup in cyclecount ?

2745

default triggers available for reports

2205

How to clone the database using RMAN back

2221

where the dff data will be stored

2428

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2945

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

2252

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

2286

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3571

What is the importance of batch source set up in ar? : oracle accounts receivable

1254

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1122

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

1212

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1332

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

2124

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2392

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