In a data warehouse environment,views are materialized on demand,i.e.when the view query is submitted.
Correct Answer:
Verified
Q8: The motivations for using views are that
Q9: A single-table view is not updatable if
Q10: A modification query may cause rows in
Q11: In a 1-M updatable query,you cannot insert
Q12: In a 1-M updatable query,to insert a
Q14: Modifications to views,such as deleting rows or
Q15: Only single-table views are updatable with SQL
Q16: The WITH RESTRICTIONS OPTION clause of the
Q17: If a table name used in a
Q18: In a 1-M updatable query,update operations are
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents