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

What is SYSTEM tablespace and When is it Created?

2 7691

Explain the relationship among Database, Tablespace and Data file?

4 12782

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 64510

What are Schema Objects ?

2 5632

Can objects of the same Schema reside in different tablespaces.?

3 9492

Can a Tablespace hold objects from different Schemes ?

3 7726

what is Table ?

2 5368

What is a View ?

3 6643

Do View contain Data ?

10 23762

Can a View based on another View ?

3 11916

What are the advantages of Views ?

3 10308

What is a Sequence ?

3 7045

What is a Synonym ?

3 7199

What are the type of Synonyms?

1 5930

What is a Private Synonyms ?

1 5119

Un-Answered Questions { Oracle }

did u received a single file or multiple files

2063

How to define an anonymous block?

1252

What is the data type of dual table?

1071

What is a read only transaction in oracle?

1084

What are bind variables and why are they important?

595

How to define an external table with a text file?

1129

How is it different from a normal table?

1084

What is the difference between truncate and delete? How would a full table scan behave after?

600

How to change program global area (pga) in oracle?

1150

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2149

How to create lov dynamically at runtime & attach to text field?

1243

How to specify default values in insert statement using oracle?

1157

what is semphore explian it?

2885

How to define default values for formal parameters?

1096

Can a formula column be obtained through a select statement ?

2383

For More Un-Answered { Oracle } Questions Click Here