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 5508

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

3 9385

Can a Tablespace hold objects from different Schemes ?

3 7577

what is Table ?

2 5247

What is a View ?

3 6501

Do View contain Data ?

10 23452

Can a View based on another View ?

3 11791

What are the advantages of Views ?

3 10185

What is a Sequence ?

3 6897

What is a Synonym ?

3 7050

What are the type of Synonyms?

1 5819

What is a Private Synonyms ?

1 5003

What is a Public Synonyms ?

1 4841

What are synonyms used for ?

3 6969

What is an Index ?

2 6718

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

1) Does oracle have any table which contain all the exceptions and it's code internally?

1749

What is Java Pool in Oracle?

1165

How to turn on or off recycle bin for the instance?

1079

What is dual table oracle?

984

what is normalisation?what are its uses?

2268

How to use "out" parameter properly?

1080

How to handle a single quote in oracle sql?

1045

WHAT IS ecc 6.0

2147

How to find the duplicate rows count from employees table in oracle?

1085

What is the use of aggregate functions in oracle?

1023

List out the difference between commit, rollback, and savepoint?

1029

How to delete a user account in oracle?

964

What are the most common interview questions on ETL Testing for experience?

1140

What happens to the data files if a tablespace is dropped?

1059

How to use subqueries with the in operator using oracle?

1089

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