Module quiz: Introduction to Databases & SQL :Working with Data (Meta React Native Specialization) Answers 2025
1. Question 1
CREATE staff TABLE
❌ True
✔️ False
2. Question 2
CREATE TABLE staff (name VARCHAR(100), address VARCHAR(100));
✔️ True
❌ False
3. Question 3
SQL command to add a new record:
✔️ INSERT INTO staff
❌ ADD INTO staff
❌ INSERT TO staff
4. Question 4
Correct syntax to update records:
✔️ UPDATE staff
❌ UPDATE Table staff
❌ Table staff UPDATE
5. Question 5
EDIT command modifies data?
❌ True
✔️ False
(We use UPDATE, not EDIT.)
6. Question 6
Update Karl’s email:
✔️ UPDATE staff SET email = ‘Karl@email.com‘ WHERE ID = 16;
❌ UPDATE students SET name = ‘Karl@email.com‘ WITH ID = 16;
❌ UPDATE staff WHERE ID = 16 SET email = ‘Karl@email.com‘;
7. Question 7
INSERT INTO staff (ID, name) VALUES (7, “Tom”)
❌ DATA
✔️ VALUES
❌ COLUMN
8. Question 8
Select all data from all three columns:
✔️ SELECT * FROM staff
✔️ SELECT name, email, age FROM staff
❌ SELECT name, email AND age FROM staff
9. Question 9
Select phone numbers:
✔️ True
❌ False
10. Question 10
Delete all records without deleting table:
✔️ DELETE FROM staff
✔️ TRUNCATE TABLE staff
❌ DROP TABLE staff (this deletes the table itself)
✅ Summary Table (as you prefer)
| Q | Correct Answer |
|---|---|
| 1 | False ✔️ |
| 2 | True ✔️ |
| 3 | INSERT INTO staff ✔️ |
| 4 | UPDATE staff ✔️ |
| 5 | False ✔️ |
| 6 | UPDATE staff SET email = ‘…’ WHERE ID = 16; ✔️ |
| 7 | VALUES ✔️ |
| 8 | SELECT * FROM staff; AND SELECT name, email, age FROM staff ✔️ |
| 9 | True ✔️ |
| 10 | DELETE FROM staff; TRUNCATE TABLE staff ✔️ |