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 5527

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 23522

Can a View based on another View ?

3 11817

What are the advantages of Views ?

3 10195

What is a Sequence ?

3 6922

What is a Synonym ?

3 7071

What are the type of Synonyms?

1 5839

What is a Private Synonyms ?

1 5019

What is a Public Synonyms ?

1 4855

What are synonyms used for ?

3 6989

What is an Index ?

2 6735

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

State the various uses of dbcc command?

1061

What is the data pump export utility?

1086

What are named parameters?

1097

In what script is snap$ created? In what script is the scott/tiger schema created?

2710

what is reindexing?

1682

How can I combine multiple rows into a comma-delimited list in oracle?

1062

Explain a segment?

1093

What suggestions do you have to reduce the network traffic?

967

Explain the difference between replace() and translate() functions in oracle?

1041

What privilege is needed for a user to delete rows from tables in another schema?

1071

How to filter out duplications in the returning rows using oracle?

1020

What is a relational database management system?

1123

What is a snapshot in oracle database?

1027

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1935

Differentiate between function and procedure in oracle.

1086

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