Module quiz: Introduction to Databases

What is the most used database type in computing?
- NoSQL Database
- Relational Database
- Flat File Database
Which one of the following is an advantage of storing data in tables?
- Tables let you store large amounts of data.
- Tables provide a simple and clear view of data
- Tables offer the ability to encrypt data.
In a bookshop database, the complete information about one specific book is referred to as a ______________.
- Table
- Record
- Column
What makes SQL a very popular database language? Select all that apply.
- SQL is a portable programming language.
- SQL works with different relational database management systems.
- SQL requires very little coding skills to use.
Which SQL command is used to update data in a database table?
- UPDATE command
- MODIFY command
- EDIT command
Which of the following database management systems uses the SQL language? Select all that apply.
- Oracle
- MySQL
- PostgreSQL
What is the importance of a candidate key in a database?
- A candidate key can be used to drop a table.
- A candidate key can be used to uniquely identify rows in a table.
- A candidate key can be used to encrypt data in a table.
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
'CREATE TABLE student;' is the right syntax to create a student table in SQL.
- False
- True
Choose the right syntax to create a club database in SQL. Select all correct answers.
- create club database;
- create database club;
- CREATE DATABASE CLUB;
- CREATE CLUB DATABASE;

Module quiz: Introduction to Databases

Comments

Tip & Tricks

More from this blog

Daily Tech Brief — 01/08/2026

Daily Tech Brief — 31/07/2026

Daily Tech Brief — 30/07/2026

Get Started with Vibe Coding and Gemini CLI - GSP1348

Build an AI Image Recognition app using Gemini on Agent Platform - bb-ide-genai-001

Command Palette

Comments

Tip & Tricks

More from this blog