ORACLE Interview Preparation Questions with Answers (Part 1) Posted by Unknown on 5:10 AM

Check out this collection of ORACLE Interview Preparation  Questions with Answers .This is new series of ORACLE ORACLE Interview Preparation  Questions with Answers from very basic level to expert level..

• What are the components of physical database structure of Oracle database?
• What are the components of logical database structure of Oracle database?
• What is a tablespace?
• What is SYSTEM tablespace and when is it created?
• Explain the relationship among database, tablespace and data file.
• What is schema?
• What are Schema Objects?
• Can objects of the same schema reside in different tablespaces?
• Can a tablespace hold objects from different schemes?
• What is Oracle table?
• What is an Oracle view?
• What is Partial Backup ?
• What is Mirrored on-line Redo Log ?
• What is Full Backup ?
• Can a View based on another View ?
• Can a Tablespace hold objects from different Schemes ?
• Can objects of the same Schema reside in different tablespaces.?
• What is the use of Control File ?
• Do View contain Data ?
• What are the Referential actions supported by FOREIGN KEY integrity constraint ?

ORACLE Interview Questions for Preparations Part 2 Posted by Unknown on 8:34 AM

• From which designation is it preferred to send the output to the printed?
• what are difference between post database commit and post-form commit?
• What are the different display styles of list items?
• Which of the above methods is the faster method?
• With which function of summary item is the compute at options required?
• What are parameters?

ORACLE Interview Questions for Preparations Part 1 Posted by Unknown on 12:39 AM

List of ORACLE Interview Questions for preparations

• What are the components of logical database structure of Oracle database?
• What is a tablespace?
• What is SYSTEM tablespace and when is it created?
• Explain the relationship among database, tablespace and data file.
• What is schema?
• What are Schema Objects?