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

Oracle General Interview Questions

Questions Answers Views Company eMail

What are Schema Objects ?

2 5528

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

3 9409

Can a Tablespace hold objects from different Schemes ?

3 7600

what is Table ?

2 5270

What is a View ?

3 6525

Do View contain Data ?

10 23523

Can a View based on another View ?

3 11817

What are the advantages of Views ?

3 10197

What is a Sequence ?

3 6923

What is a Synonym ?

3 7071

What are the type of Synonyms?

1 5840

What is a Private Synonyms ?

1 5019

What is a Public Synonyms ?

1 4856

What are synonyms used for ?

3 6991

What is an Index ?

2 6735

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is pragma autonomous transaction in oracle?

1075

What is the difference between truncate & delete command?

1189

How to list all indexes in your schema?

1097

master table and child table performances and comparisons in Oracle ?

2139

What is a directory object?

1101

What is the purpose of save points in oracle database?

1124

How to store pictures on to the database?

980

How to define an oracle cursor variable?

1035

How to call a stored function with parameters?

1049

How much memory your 10g xe server is using?

1106

How to calculate date and time differences in oracle?

1045

Is it possible to insert comments into sql statements return in the data model editor ?

2569

How to omit columns with default values in insert statement in oracle?

1051

How to create a new table in oracle?

1162

Explain what are the advantages of views?

1069

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