Basics of Databases - Quiz

What is a database?

• A programming language

• A collection of data stored in an organised manner

• A type of computer software

• A network connection

Which of the following is an example of database software?

• Microsoft Excel

• Microsoft Access

• Adobe Photoshop

• Google Chrome

What is a primary key in a database?

• A field that can have duplicate values

• A unique identifier for each record

• A field that stores the largest value

• A key used to unlock the database

Which of these is NOT a database management system (DBMS)?

• MySQL

• Oracle

• Linux

• PostgreSQL

What is the purpose of a query in a database?

• To delete records

• To input data into the database

• To retrieve specific data from the database

• To create a new database

A database table is made up of rows and columns.

A foreign key is used to uniquely identify each record in a table.

You can store images and videos in a database.

A relational database organises data into a single large table.

SQL (Structured Query Language) is used to communicate with databases.