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 8886

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

4 7210

How do you add a data file to a tablespace?

1 3805

How do you resize a data file?

2 5308

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

1 3969

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

2224

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

2316

How can you rebuild an index?

1 5256

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

1 5663

How can you gather statistics on a table?

3 8786

How can you enable a trace for a session?

2 6939

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

1 5353

Name two files used for network connection to a database.

1 3315

What is database schema?

Infosys,

4 16306

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 6179

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1145

Explain about party and customer in ar : oracle accounts receivable

1211

default triggers available for reports

2213

Explain the payment term in ar. : oracle accounts receivable

1106

What is auto invoicing? Explain : oracle accounts receivable

1126

as a technical developer in oracle applications which type errors feced in your experience sofar

2331

can we use lexical perameter in oracle plsql if yes how

2315

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

1393

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2280

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

2601

Differentiate between transaction type and transaction source? : oracle accounts receivable

1115

What are different types of transactions in ar? : oracle accounts receivable

1299

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2192

how to write customizations in po

1618

Are These Dff's Flexible?

1170

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