Multiple choice technology databases

Which two of the following statements are true?

  1. A view can be created before creating the base table

  2. A view cannot be created before creating the base table

  3. A view will become invalid if the base table's column referred to in the view is altered

  4. A view will become invalid if any column in the base table is altered
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

Views can be created before their base tables exist in Teradata due to late binding - the view definition is stored but not validated until the view is used. However, if columns specifically referenced in the view definition are altered or dropped, the view becomes invalid and cannot be used.

Keep practicing — related questions