Home » Oracle » 1z0-591 » Identify the two true statements about alias tables.
Identify the two true statements about alias tables.
A. Alias tables are set up to avoid triangular or circular joins.
B. Alias tables are set up to include best practice naming conventions for physical table names.
C. Alias tables are set up to create another physical copy of the data.
D. Alias tables are set up to create a copy of the data with a filter applied to it.
Correct Answer: AB
Explanation/Reference:
It is a best practice to create aliases for all tables. Aliases are created in the Physical Layer of the repository. Some of the benefits of using aliases are given below:
(A) * An alias is used to avoid circular joins and to configure self joins.
* You can create a join relationship which is different than the actual foreign key relationship in the database. This helps in defining relationships to meet business model criteria.
* Aliases can function in numerous ways to define business model e.g. a table can act both as a dimension and a fact using aliases.
(B) * You can rename aliases to make physical and business model easier to understand.
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
