# Module quiz: Create, Read, Update and Delete (CRUD) Operations

1. **The following SQL clause creates a table named staff within a database:**
    
    `CREATE staff TABLE;`
    
    * <mark>False</mark>
        
    * True
        
2. **The following SQL statement creates a table named staff, with two columns called name and address:**
    
    `CREATE TABLE staff (name VARCHAR(100), address VARCHAR(100));`
    
    * False
        
    * <mark>True</mark>
        
3. **What is the SQL command to add a new record of data in the staff table?**
    
    * INSERT staff INTO;
        
    * ADD INTO staff;
        
    * <mark>INSERT INTO staff;</mark>
        
4. **Which is the right command syntax to update the staff table in SQL?**
    
    * <mark>UPDATE staff;</mark>
        
        UPDATE Table staff;
        
5. **EDIT command is used to modify data in a database table.**
    
    * <mark>False</mark>
        
    * True
        
6. **Which one of the following SQL statements updates the staff email address for the individual named “Karl” in the staff table?**
    
    * UPDATE staff WHERE ID = 16 SET email = '[Karl@email.com](mailto:Karl@email.com)';
        
    * <mark>UPDATE staff SET email = '</mark>[<mark>Karl@email.com</mark>](mailto:Karl@email.com)<mark>' WHERE name = 'Karl';</mark>
        
    * UPDATE staff SET name = '[Karl@email.com](mailto:Karl@email.com)' WHERE email = 'Karl';
        
7. **Select the right keyword to complete the missing part of the following statement:**
    
    `INSERT INTO staff (ID, name) ___ (7, “Tom”);`
    
    * <mark>VALUES</mark>
        
    * DATA
        
8. **A staff table consists of three columns called name, email and age. Which of the following SQL statements selects all available data in all three columns in the staff table?**
    
    *Select all correct answers.*
    
    * <mark>SELECT name, email, age FROM staff;</mark>
        
    * <mark>SELECT * FROM staff;</mark>
        
    * SELECT name, email AND age FROM staff;
        
9. **The following SQL statement returns all staff phone numbers from the staff table:**
    
    `SELECT phoneNumber FROM staff;`
    
    * False
        
    * <mark>True</mark>
        
10. **Which of the following SQL statements deletes all records of data from the staff table without deleting the table itself?**
    
    *Select all correct answers.*
    
    * <mark>TRUNCATE TABLE staff;</mark>
        
    * DROP TABLE staff;
        
    * <mark>DELETE FROM staff;</mark>
        

---

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731149178941/20465b35-6e05-4327-9883-663e6a56fd22.png align="center")