Oracle Questions et reponses d'entretien
Differences associees
Question 21. What are the type of Synonyms?
There are two types of Synonyms Private and Public.
Question 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.
Question 23. What is an Index Segment?
Each Index has an Index segment that stores all of its data.
Question 24. What are the different type of Segments?
Data Segment, Index Segment, Rollback Segment and Temporary Segment.
Question 25. What are Clusters?
Clusters are groups of one or more tables physically stores together to share common columns and are often used together.
Les plus utiles selon les utilisateurs :
- 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?