Oracle AllOther Interview Questions
Questions Answers Views Company eMail

what is the difference between oracle 81,91,11i

Oracle, i2,

2 13474

How client makes connection with server in client/server architecture?

CA,

1 1787

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 2403




For web applications from which version of Oracle is suitable?

1 2625

What are the main diff. between oracle 7.3 and oracle 8i?

1 2516

What is the Symbol use for Inner Join

Oracle, TCS,

1 9604

How do you use trigger to create mutating state of table

TCS,

2 3856

When the procedures or packagess become invalidate

TCS,

3 4278




what is the difference between TRUNCATE and DELETE command in SQL

Saama Tech, TCS, ICICI, SkyTech,

23 44581

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 4904

Explain the difference between a hot backup and a cold backup and the benefits associated with each

1 2453

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

1 1914

How do you switch from an init.ora file to a spfile?

HCL, Wipro,

1 2451

Explain the difference between a data block, an extent and a segment.

Accenture, IBM,

1 5828

Give two examples of how you might determine the structure of the table DEPT.

2 2498


Post New Oracle AllOther Questions






Un-Answered Questions { Oracle AllOther }

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.

708


What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

633


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.

2099


Where in the Oracle directory tree structure are audit traces placed?

883


HOW TO SPOT AHIERARCHY?

796


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

1399


A scenario for amount correction & how to use amount correction functionality in AP invoices

607


3. Steps in UAT?

806


What is the mandatory setup in cyclecount ?

993


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

766


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

775


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

584


I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

1044


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

676


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

657