Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Practice InterviewNew Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

Oracle Interview Questions and Answers

  Difficulty Level: AllBeginnerIntermediateExpert

Ques 1. What are the components of physical database structure of Oracle database?

Ques 2. What are the components of logical database structure of Oracle database?

Ques 3. What is a tablespace?

Ques 4. What is SYSTEM tablespace and when is it created?

Ques 5. Explain the relationship among database, tablespace and data file?

Ques 6. What is schema?

Ques 7. What are Schema Objects?

Ques 8. Can objects of the same schema reside in different tablespaces?

Ques 9. Can a tablespace hold objects from different schemes?

Ques 10. What is Oracle table?

Ques 11. What is an Oracle view?

Ques 12. What is Partial Backup?

Ques 13. What is Full Backup?

Ques 14. Can a View based on another View?

Ques 15. Can a Tablespace hold objects from different Schemes?

Ques 16. Can objects of the same Schema reside in different tablespace?

Ques 17. Do View contain Data?

Ques 18. What are the Referential actions supported by FOREIGN KEY integrity constraint?

Ques 19. What are the type of Synonyms?

Ques 20. What is an Index Segment?

Ques 21. What are the different type of Segments?

Ques 22. What are Clusters?

Ques 23. What is an Integrity Constrains?

Ques 24. What is an Index?

Ques 25. What is an Extent?

Ques 26. What is a View?

Ques 27. What is Table?

Ques 28. What are the advantages of views?

©2020 WithoutBook