SQL Quiz
10 questions · no time limit
0:00
DATA DEFINITION AND MANIPULATION
Question 1 of 10
No time limit
Current
Answered
Flagged
Not seen
PASSAGE
The
employees rows are: employee 1—Sales, active; employee 2—Sales, inactive; employee 3—Support, active; employee 4—Support, inactive; employee 5—Engineering, active. The active column contains either 1 or 0.Which employees are modified by this statement?
UPDATE employees SET bonus = 500 WHERE department = 'Sales' OR department = 'Support' AND active = 1; YOUR PROGRESS
10
QUESTIONS
Ready when you are
Answer in any order. Your progress shows here as you go.
QUESTIONS
KEYBOARD
Pick an answer ABCD
Next question ↵→
Previous ←
Flag for review F
Answers save as you go · flagged questions come back at the end