Oracle Interview Questions and Answers
Related differences
Ques 21. What are the type of Synonyms?
There are two types of Synonyms Private and Public.
Is it helpful?
Add Comment
View Comments
Ques 22. What is a Redo Log?
The set of Redo Log files YSDATE,UID,USER or USERENV SQL functions, or the pseudo columns LEVEL or ROWNUM.
Is it helpful?
Add Comment
View Comments
Ques 23. What is an Index Segment?
Each Index has an Index segment that stores all of its data.
Is it helpful?
Add Comment
View Comments
Ques 24. What are the different type of Segments?
Data Segment, Index Segment, Rollback Segment and Temporary Segment.
Is it helpful?
Add Comment
View Comments
Ques 25. What are Clusters?
Clusters are groups of one or more tables physically stores together to share common columns and are often used together.
Is it helpful?
Add Comment
View Comments
Most helpful rated by users:
- 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?