🎴 Flashcard Mode
Oracle Database: DBMS_SCHEDULER and SQL
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which two of the following statements are true?
AnswerClick to flip back
A
A view can be created before creating the base table
B
A view will become invalid if the base table's column referred to in the view is altered
💡 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.