Oracle AllOther Interview Questions
Questions Answers Views Company eMail

Name a tablespace automatically created when you create a database.

HCL,

3 7137

When creating a user, what permissions must you grant to allow them to connect to the database?

4 5807

How do you add a data file to a tablespace?

1 2873

How do you resize a data file?

2 4305

What view would you use to look at the size of a data file?

1 3245

What view would you use to determine free space in a tablespace?

1769

How would you determine who has added a row to a table?

1786

How can you rebuild an index?

1 4392

You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 4804

How can you gather statistics on a table?

3 7248

How can you enable a trace for a session?

2 5838

What is the difference between the SQL*Loader and IMPORT utilities?

1 4490

Name two files used for network connection to a database.

1 2503

What is database schema?

Infosys,

4 14375

What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

CTS,

2 5057


Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

what is difference between inner join & nested query or subqueries

2478


Explain how to close periods in ar. : oracle accounts receivable

697


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

1606


What is the mandatory setup in cyclecount ?

2176


Explain prerequisites and post activities of oracle database installation

1609






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

663


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

6720


What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

681


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.

1847


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.

1733


Explain the process of recievables in oracle financials. : oracle accounts receivable

651


how to write customizations in po

1189


I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

1817


key flexfield structure

1593


3. Steps in UAT?

1940