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 :
Explain the relationship among Database, Tablespace and Data file?
Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace
Question 25 :
What are the different type of Segments ?
Data Segment, Index Segment, Rollback Segment and Temporary Segment.