🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.SELECT id, name, price FROM products WHERE price > 100
  2. B.SELECT category, SUM(price) FROM products GROUP BY category
  3. C.SELECT DISTINCT category FROM products
  4. 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 →