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 5626

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

3 9487

Can a Tablespace hold objects from different Schemes ?

3 7719

what is Table ?

2 5356

What is a View ?

3 6640

Do View contain Data ?

10 23749

Can a View based on another View ?

3 11914

What are the advantages of Views ?

3 10299

What is a Sequence ?

3 7038

What is a Synonym ?

3 7187

What are the type of Synonyms?

1 5921

What is a Private Synonyms ?

1 5117

What is a Public Synonyms ?

1 4953

What are synonyms used for ?

3 7156

What is an Index ?

2 6822

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Why does Oracle not permit the use of PCTUSED with indexes?

2479

Why we use bulk collect in oracle?

1117

What is dual table oracle?

1030

What is a table index in oracle?

1187

Why oracle is used?

1108

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2187

What are the restrictions in a oracle read only transaction?

1084

How to pass parameters to procedures?

1089

How to set a transaction to be read only in oracle?

1140

How do you find current date and time in oracle?

1101

What is a trigger and what are its types in oracle?

1155

What is a nested table?

1111

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1836

Explain oracle’s system global area (sga).

1189

How do I spool in oracle?

1065

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