Set - 1

Question 21 :

What are the type of Synonyms?

Answer :

There are two types of Synonyms Private and Public.

Question 22 :

What is a Redo Log ?

Answer :

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 ?

Answer :

Each Index has an Index segment that stores all of its data.

Question 24 :

Explain the relationship among Database, Tablespace and Data file?

Answer :

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 ?

Answer :

Data Segment, Index Segment, Rollback Segment and Temporary Segment.