1. Categories >> Software >> Databases >> Oracle >> Oracle AllOther
  2. Suggest New Category
Oracle AllOther Interview Questions
Questions Answers Views Company eMail

Where would you look for errors from the database engine?

Fintellix,

2 10525

Compare and contrast TRUNCATE and DELETE for a table.

 3 6175

Give the reasoning behind using an index.

 2 4828

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

 1 3188

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

 1 7479

Give two examples of referential integrity constraints.

 1 4016

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 13709

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

HCL,

1 6706

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

 1 7844

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

 1 4411

How would you go about generating an EXPLAIN plan?

Satyam,

1 4048

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

 1955

Explain an ORA-01555

 2 5717

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

 2 6739

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

 1 4250

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3336

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

734

which one is currently in used software cmpanies.

1661

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1650

What is the difference between oracle media recovery and crash recovery?

677




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

577

what are the API of GL,PO,AP

1777

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1615

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

625

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2019

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

1834

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

727

what is semphore explian it?

2247

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.

1852

What is the mandatory setup in cyclecount ?

2188

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