In a 1-M updatable query,update operations are supported on the parent table even if the query does not contain the primary key of the parent table.
Correct Answer:
Verified
Q13: In a data warehouse environment,views are materialized
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
Q19: In a hierarchical form involving a 1-M
Q20: In a 1-M updatable query,to insert a
Q21: In the "three schema architecture",views belong to:
A)
Q22: Figuer:
CUSTOMER (primary key = CID)
Q23: When creating a hierarchical report,the groups 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