> > >

PostgreSQL MCQs

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?

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

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

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

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

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

Answer

Correct Answer: UPDATE ONLY store_products SET name = 'Wine' WHERE id = 2;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

PostgreSQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it