Oracle perguntas e respostas de entrevista
Diferencas relacionadas
Pergunta 21. What are the type of Synonyms?
There are two types of Synonyms Private and Public.
Isto e util?
Adicionar comentario
Ver comentarios
Pergunta 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.
Isto e util?
Adicionar comentario
Ver comentarios
Pergunta 23. What is an Index Segment?
Each Index has an Index segment that stores all of its data.
Isto e util?
Adicionar comentario
Ver comentarios
Pergunta 24. What are the different type of Segments?
Data Segment, Index Segment, Rollback Segment and Temporary Segment.
Isto e util?
Adicionar comentario
Ver comentarios
Pergunta 25. What are Clusters?
Clusters are groups of one or more tables physically stores together to share common columns and are often used together.
Isto e util?
Adicionar comentario
Ver comentarios
Mais uteis segundo os usuarios:
- 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?