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

Oracle General (1803)
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 8732

what is the difference between TRUNCATE and DELETE command in SQL

ICICI, Saama Tech, SkyTech, TCS,

23 67255

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 10355

Define 'view' advantage ?

AZTEC, TCS,

2 11767

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 3244

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

1 5157

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 4788

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

HCL, Wipro,

1 5461

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

Accenture, IBM,

1 9599

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

2 6605

Where would you look for errors from the database engine?

Fintellix,

2 12180

Compare and contrast TRUNCATE and DELETE for a table.

3 7544

Give the reasoning behind using an index.

2 6397

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

1 3922

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

1 8223

Un-Answered Questions { Oracle }

Mention where does the clusterware write when there is a network or storage issue?

Mention what is cluster?

What is the sid in oracle?

1036

What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?

Explain the purpose of oracle real application clusters (rac)?

What is split brain syndrome in rac?

What is oracle used for?

1075

How to download oracle database 10g xe?

1073

Explain the dml?

1051

What are four common errors found in an alert .log?

600

What are the constraints are used in Ur project?

588

How does one get the view definition of fixed views/tables?

1075

What is SQL Tuning Advisor in Oracle?

1258

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1975

What is proxy method?

1026

For More Un-Answered { Oracle } Questions Click Here