Oracle AllOther Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle AllOther Interview Questions

Questions Answers Views Company eMail

Name a tablespace automatically created when you create a database.

HCL,

3 8721

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

4 7067

How do you add a data file to a tablespace?

1 3690

How do you resize a data file?

2 5204

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

1 3885

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

2175

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

2259

How can you rebuild an index?

1 5159

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

1 5543

How can you gather statistics on a table?

3 8634

How can you enable a trace for a session?

2 6830

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

1 5275

Name two files used for network connection to a database.

1 3241

What is database schema?

Infosys,

4 16116

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 6046

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

HOW TO SPOT AHIERARCHY?

2251

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2232

How do you create a credit note against an invoice? : oracle accounts receivable

1037

Explain the payment term in ar. : oracle accounts receivable

1064

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

2175

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

2478

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

1957

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7920

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.

2152

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1227

how to write customizations in po

1569

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

2213

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7579

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

1203

What do you mean by Oracle MEDIA RECOVERY?

1173

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