# Module quiz: Introduction to Databases

1. **What is the most used database type in computing?**
    
    * NoSQL Database
        
    * <mark>Relational Database</mark>
        
    * Flat File Database
        
2. **Which one of the following is an advantage of storing data in tables?**
    
    * Tables let you store large amounts of data.
        
    * <mark>Tables provide a simple and clear view of data</mark>
        
    * Tables offer the ability to encrypt data.
        
3. **In a bookshop database, the complete information about one specific book is referred to as a \_\_\_\_\_\_\_\_\_\_\_\_\_\_.**
    
    * Table
        
    * <mark>Record</mark>
        
    * Column
        
4. **What makes SQL a very popular database language?** *Select all that apply.*
    
    * SQL is a portable programming language.
        
    * <mark>SQL works with different relational database management systems.</mark>
        
    * <mark>SQL requires very little coding skills to use.</mark>
        
5. **Which SQL command is used to update data in a database table?**
    
    * <mark>UPDATE command</mark>
        
    * MODIFY command
        
    * EDIT command
        
6. **Which of the following database management systems uses the SQL language?** *Select all that apply.*
    
    * <mark>Oracle</mark>
        
    * <mark>MySQL</mark>
        
    * <mark>PostgreSQL</mark>
        
7. **What is the importance of a candidate key in a database?**
    
    * A candidate key can be used to drop a table.
        
    * <mark>A candidate key can be used to uniquely identify rows in a table.</mark>
        
    * A candidate key can be used to encrypt data in a table.
        
8. **In the following student table, which attribute could be used as a primary key?**
    
    | **Student first name** | **Student last name** | **Mobile number** |
    | --- | --- | --- |
    | Carl | Merlo | 07445532123 |
    | Mark | Nero | 07456532327 |
    
    * Student last name
        
    * Mobile number
        
    * Student first name
        
9. **'CREATE TABLE student;' is the right syntax to create a student table in SQL.**
    
    * <mark>False</mark>
        
    * True
        
10. **Choose the right syntax to create a club database in SQL.** *Select all correct answers.*
    
    * create club database;
        
    * <mark>create database club;</mark>
        
    * <mark>CREATE DATABASE CLUB;</mark>
        
    * CREATE CLUB DATABASE;
        

---

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731148300199/67383f14-b7a5-43bc-9fd9-5f5f648a3c02.png align="center")