Oracle AllOther Interview Questions
Questions Answers Views Company eMail

Where would you look for errors from the database engine?

Fintellix,

2 11334

Compare and contrast TRUNCATE and DELETE for a table.

3 6811

Give the reasoning behind using an index.

2 5410

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

1 3521

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

1 7817

Give two examples of referential integrity constraints.

1 4442

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 14446

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

HCL,

1 7353

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

1 8291

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

1 4817

How would you go about generating an EXPLAIN plan?

Satyam,

1 4402

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

2292

Explain an ORA-01555

2 6500

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7242

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

1 4678


Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

what are the tools used for oracle 10g in real time.

2201


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2166


types of receipts and detail desription about recipts and tables effected by receipts?

1873


i want to know about the javaBean.what is its purpose and how it can use in Forms.

2163


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

912


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

1995


where the dff data will be stored

2059


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

1076


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

805


how to write customizations in po

1415


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

1778


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2103


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

2108


HOW TO SPOT AHIERARCHY?

2079


What is Tax Categories?

1875