Back to marketplace

Databases

No description yet. This curated deck is ready for daily study.

Total cards: 6•Content version: v4•Public deck•Updated: 8/1/2026

Card preview (6)

#1
Front (Question)

What is a database?

Back (Answer)

A way of holding data in an organised way so that searching for data items meeting certain criteria is easy

#2
Front (Question)

In a table, what is the name given to a row

Back (Answer)

Records Each record will have identical record structures

#3
Front (Question)

In a table, what is the name given to a column?

Back (Answer)

Fields Each field has a defined field type, e.g. text, Boolean, numeric

#4
Front (Question)

What is the format of an SQL statement?

Back (Answer)

SELECT - List the filed(s) you want to display FROM - List the table the data will come from WHERE - List search criteria here ORDER BY - Sorts data in ASC or DESC order

#5
Front (Question)

Write an SQL statement for finding the total number of female members in the ClubMember table

Back (Answer)

SELECT COUNT FROM ClubMember WHERE Gender = “F”

#6
Front (Question)

Write an SQL statement for finding the total number of eruptions of volcanoes in Italy recorded in the Volcano table

Back (Answer)

SELECT SUM(TimesErupted) FROM Volcano WHERE County = “Italy”