← Quiz: Views, Triggers and Procedures: all 10 questions
Quiz: Views, Triggers and Procedures · Question 8 of 10
Which view is usually updatable?
Which view is usually updatable?
- A.SELECT id, name, price FROM products WHERE price > 100
- B.SELECT category, SUM(price) FROM products GROUP BY category
- C.SELECT DISTINCT category FROM products
- D.SELECT p.name, o.qty FROM products p JOIN order_items o ON p.id = o.product_id
Answer & explanation
Correct answer: SELECT id, name, price FROM products WHERE price > 100
Each row of a simple single-table view maps to exactly one base row.
Can you get the rest right without peeking?
Take the timed Quiz: Views, Triggers and Procedures quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →