← Quiz: Views, Triggers and Procedures: all 10 questions
Quiz: Views, Triggers and Procedures · Question 2 of 10
How can you let a team see product prices but not costs?
How can you let a team see product prices but not costs?
- A.Delete the cost column
- B.Add a trigger on SELECT
- C.Create a view without the cost column and grant access only to the view
- D.Use a stored function
Answer & explanation
Correct answer: Create a view without the cost column and grant access only to the view
The view exposes only the allowed columns, and permissions block the base table.
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 →