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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

When the procedures or packagess become invalidate

TCS,

3 8572

what is the difference between TRUNCATE and DELETE command in SQL

ICICI, Saama Tech, SkyTech, TCS,

23 66392

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 10167

Define 'view' advantage ?

AZTEC, TCS,

2 11632

Could u tell me, u work as a support & maintenace when sub ledger and gl is mismatch, then how do u match with the both side/

HCL,

1 3160

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

1 5075

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 4662

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

HCL, Wipro,

1 5350

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

Accenture, IBM,

1 9507

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

2 6464

Where would you look for errors from the database engine?

Fintellix,

2 12029

Compare and contrast TRUNCATE and DELETE for a table.

3 7406

Give the reasoning behind using an index.

2 6221

Give the two types of tables involved in producing a star schema and the type of data they hold.

1 3854

What type of index should you use on a fact table?

1 8136

Un-Answered Questions { Oracle }

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

1142

What is the page protect in reports?

What is Undo Management Advisor in Oracle?

1093

How do I become a data manager?

523

State all possible different index configurations a table can possibly have?

994

WHAT IS ecc 6.0

2145

How can you find out how many users are currently logged into the database?

604

How to see the table columns used in an index?

1017

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1688

What is a select query statement in oracle?

959

What is pragma autonomous transaction in oracle?

1062

What is index in Oracle?

1068

Explain cascading triggers.

1068

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

2128

Explain the use of constraints option in exp command.

1044

For More Un-Answered { Oracle } Questions Click Here