Wednesday 11 February 2015

Latest Data Warehousing Interview Questions and Answers (Page 4)

Below are some important Data Warehouse interview questions which are asked in most MNC company interviews for beginners or professionals.

36. What are the Characteristics of Data Files?

A data file can be associated with only one database. Once created a data file can't change size. One or more data files form a logical unit of database storage called a table space.

37. What is Rollback Segment?
A Database contains one or more Rollback Segments to temporarily store "undo" information.

38. What is a Table space?
A database is divided into Logical Storage Unit called table spaces. A table space is used to grouped related logical structures together.

39. What is Database Link?
A database link is a named object that describes a "path" from one database to another.

40. What is a Private Synonyms?
A Private Synonyms can be accessed only by the owner.
More Questions & Answers :-

No comments:

Post a Comment