Oracle Interview Questions and Answers, oracle questions and answers for interviews,interview questions and answers in oracle, oracle short questions and answers, oracle 10 interview questions and answers,oracle 9 interview questions and answers Page 12 -- Infibee

56.

What are the type of Synonyms?

There are two types of Synonyms Private and Public.

57.

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.

58.

What is an Index Segment ?

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

59.

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.

60.

What are the different type of Segments ?

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