iGCSE U9 Terminology Quiz

What are the qualities of a database? (select all)

• Persistent
• Structured
• Unstable
• Unique
• Alphabetical

A database that only contains one table is known as

• A single-table database
• A standard database
• A simple table
• A unique identifier
• They don't exist

A collection of related records in a database is known as

• a table
• a record
• a field
• a datatype
• a multifield

A collection of fields that describe a single item is known as

• A record
• A combiner
• A datatype
• A multifield
• They don't exist

A classification of how data is stored and displayed, and of which operators that can be performed on the stored value is known as

• Data Type
• Value Definer
• Data Classifier
• Data Key
• Field Classifier

A field in a database that is used to uniquely identify a record is called

• A primary key
• A unique identifier
• A unique key
• A primary identifier
• An SQL ID

Which of the following is not a datatype in SQL (select all)

• Boolean
• String
• Array
• Calendar
• Float

Commands that perform a given task on a database. Usually stored in a file so they can be reused.

• SQL Scripts
• Database Scripts
• Database Files
• Primary Keys
• Single-table Databases

The SQL query statement that fetches fields from a table

• SELECT
• FROM
• COUNT
• WHERE
• QUERY

The first word of a query is always

• SELECT
• FROM
• COUNT
• WHERE
• QUERY