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 8688

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

4 7046

How do you add a data file to a tablespace?

1 3669

How do you resize a data file?

2 5180

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

1 3871

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

2166

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

2249

How can you rebuild an index?

1 5148

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

1 5522

How can you gather statistics on a table?

3 8597

How can you enable a trace for a session?

2 6801

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

1 5262

Name two files used for network connection to a database.

1 3221

What is database schema?

Infosys,

4 16070

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 6019

Post New Oracle AllOther Questions

Un-Answered Questions { Oracle AllOther }

please send me oracle pl/sql exp resume. and also faqs...

2445

what are the API of GL,PO,AP

2214

What is autocashrule set? : oracle accounts receivable

1292

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

1218

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2221

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1236

what are basic modules required to implement oracle application in any oraganisation?

2147

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

2539

can u give guidance abt packages of plsql

2106

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2058

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2461

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2014

What is Restricted Mode of Instance Startup in Oracle?

1140

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?

2099

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2355

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