Question:Given a table special_products that inherits from a table store_products, which of the following statements will modify store_products only without affecting its child table? 

A UPDATE store_products ONLY SET name = 'Wine' WHERE id = 2; 

B UPDATE store_products SET name= 'Wine' WHERE id = 2; 

C UPDATE ONLY store_products SET name = 'Wine' WHERE id = 2; 

D UPDATE JUST store_products SET name = 'Wine' WHERE id = 2; 

E UPDATE store_products NOT special_products SET name = 'Wine' WHERE id = 2; 

+ Answer
+ Report
Total Preview: 653

Copyright © 2024. Powered by Intellect Software Ltd