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
PostgreSQL is being used with transactional DDL. A populated table
members is altered inside one transaction: BEGIN; ALTER TABLE members ADD COLUMN phone text; ALTER TABLE members ADD COLUMN tier text NOT NULL;. The second ALTER TABLE fails because existing rows would have null tiers. The transaction is then rolled back.What is the schema of
members after the rollback? 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