SQA Higher Computing Science Database Design and Development overview quiz quiz

A single field in another table

A table, with its attributes as the fields

A foreign key only

An SQL SELECT query

One-to-one

Many-to-many

One-to-many

There is no relationship

It is left as a single direct link between the two tables

It is stored entirely in one compound field

It is ignored because it cannot be represented

It is resolved by adding a link entity, giving two one-to-many relationships

The primary key

A wildcard

An alias

The ORDER BY clause

That every query uses a join condition

That every record has a unique, non-empty primary key

That all fields are stored in Unicode

That a DELETE always includes a WHERE clause

That it is always the largest value in the column

That it is computed from two other fields

That it matches an existing primary-key value in the referenced table (or is empty where allowed)

That it is stored in two's complement

A presence check

A field length check

A two's complement check

A restricted choice check

By matching a foreign key to the primary key in the WHERE clause

By listing them both in ORDER BY

By using a wildcard in the SELECT

By running two separate INSERT statements

Names that are exactly the letter B

Names that begin with the letter B

Names that contain no letter B

Names that end with the letter B

COUNT

MAX

AVG

SUM

It sorts the results into ascending order

It deletes duplicate records permanently

It joins two tables together

It calculates the aggregate separately for each group

INSERT

SELECT

ORDER BY

UPDATE

Nothing changes, because a WHERE is compulsory

Only the first record is changed

Every record in the table is updated

The table is deleted entirely

Permanently stores a new column in the table

Calculates a new column in the query output and names it with an alias

Deletes the price and quantity fields

Enforces referential integrity on the order

To enforce referential integrity and avoid orphan order records

Because DELETE is not a valid SQL operation

Because customers can never be deleted in SQL

To save storage in the data dictionary

The history of every query ever run

The physical location of the server

The current contents of every table

Each attribute's name, data type, size, key role and validation