What is a 'weak entity' in a database?

An entity that depends on another entity for its existence

An entity that does not have a primary key

An entity that has multiple primary keys

An entity that cannot be linked to another entity

What is a surrogate key in a database?

A unique identifier for each record in a table, which is not derived from the application data

What is the main purpose of a surrogate key in a database?

To provide a unique identifier for each record, independent of all other data

To encrypt the data in the database

To establish a link between two tables

What is the difference between a primary key and a surrogate key in a database?

A primary key is a unique identifier for each record in a table, while a surrogate key is a unique identifier for each record in a table, which is not derived from the application data

A primary key is a unique identifier for each record in a table, while a surrogate key is a key used to unlock foreign data

A primary key is a key that is only used for data encryption, while a surrogate key is a unique identifier for each record in a table

A primary key is the last record added to the table, while a surrogate key is a key used to unlock foreign data

What is an 'entity occurrence' in the context of databases?

A specific instance of an entity in a database

What does the 'cardinality' of a relationship in a database entity diagram represent?

The number of entities on each side of the relationship

The speed of the database query

The security level of the database

What is the purpose of an 'entity relationship diagram' in database design?

To visualize the structure of the database

To encrypt the data in the database

To increase the speed of database queries

To reduce the size of the database

What does the SQL datatype VARCHAR represent in a database?

A type of data that represents variable character strings.

A type of data that represents integer numbers.

A type of data that represents floating point numbers.

A type of data that represents date and time values.

What is the purpose of the INT datatype in SQL?

To store floating point numbers.

How does the DATE datatype in SQL differ from the TIME datatype?

The DATE datatype is used to store date values, while the TIME datatype is used to store time values.

The DATE datatype is used to store time values, while the TIME datatype is used to store date values.

The DATE datatype is used to store integer numbers, while the TIME datatype is used to store floating point numbers.

The DATE datatype is used to store text strings, while the TIME datatype is used to store binary data.

What is the purpose of the FLOAT datatype in SQL?

To store floating point numbers.

How does the FLOAT datatype in SQL differ from the INT datatype?

The FLOAT datatype is used to store floating point numbers, while the INT datatype is used to store integer numbers.

The FLOAT datatype is used to store integer numbers, while the INT datatype is used to store floating point numbers.

The FLOAT datatype is used to store text strings, while the INT datatype is used to store binary data.

The FLOAT datatype is used to store date values, while the INT datatype is used to store time values.

What is the purpose of the CREATE TABLE statement in SQL?

To create a new table in the database.

To delete a table from the database.

To update an existing table in the database.

To retrieve data from a table in the database.

What is the role of the datatype in the CREATE TABLE statement in SQL?

To specify the type of data that can be stored in a column.

To specify the name of the column.

To specify the size of the table.

To specify the name of the table.

What is the correct syntax for the CREATE TABLE statement in SQL?

CREATE TABLE table_name (column1 datatype, column2 datatype, ...);

CREATE TABLE (column1 datatype, column2 datatype, ...) table_name;

TABLE CREATE table_name (column1 datatype, column2 datatype, ...);

TABLE (column1 datatype, column2 datatype, ...) CREATE table_name;

What is the purpose of the NOT NULL constraint in the CREATE TABLE statement in SQL?

To specify that a column must always have a value.

To specify that a column must never have a value.

To specify that a column can have any value.

To specify that a column can have duplicate values.

What is the role of the PRIMARY KEY constraint in the CREATE TABLE statement in SQL?

To specify a column that uniquely identifies each record in the table.

To specify a column that can have duplicate values.

To specify a column that can have any value.

To specify a column that must never have a value.

What does the AUTO_INCREMENT keyword in SQL do when creating a table?

It automatically increments the value in a column for each new record.

It automatically decreases the value in a column for each new record.

It automatically duplicates the value in a column for each new record.

It automatically deletes the value in a column for each new record.

Advanced Higher Databases: Relational Databases

Authored by Claire Newham

Computers

10th Grade

Used 2+ times

Advanced Higher Databases: Relational Databases

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

26 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a relational database?

A type of database that only stores unconnected data points

A type of database that does not allow access to the stored data

A type of database that stores and provides access to data points that are related to one another.

A type of database that is only used for storing images and videos

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are the key features of a relational database?

Files, folders, paths, and directories

Arrays, objects, functions, and loops

Tables, relationships and SQL

Graphs, nodes, edges, and traversal

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a primary key in a relational database?

The last record added to the table

A random number assigned to each record

A unique identifier for each record in a table

A value that can be duplicated in the table

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a foreign key in a relational database?

A type of key used to unlock foreign data

A key that is only used for data encryption

A key that is used to access a foreign language database

A field in a table that establishes a link between two tables

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Discuss the concept of relationships in a relational database.

Relationships in a relational database are established between columns using keys.

Relationships in a relational database are established between records using keys.

Relationships in a relational database are established between files using keys.

Relationships in a relational database are established between tables using keys.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Discuss the role of SQL in relational databases.

SQL is used to access and manipulate data in relational databases.

SQL is primarily used for graphic design in relational databases

SQL is not compatible with relational databases

SQL is only used for creating tables in relational databases

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the term 'mandatory relationship' mean in the context of databases?

A relationship that must exist between two tables

A relationship that is optional between two tables

A relationship that is forbidden between two tables

A relationship that is temporary between two tables

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

21 questions

CodeHS 3.1 Boolean Expressions-4.2 For Loops Review

Quiz

•

9th - 12th Grade

21 questions

Data protection

Quiz

•

9th - 11th Grade

27 questions

Adobe Illustrator Quiz Review

Quiz

•

9th - 12th Grade

21 questions

CITY & GUILDS PROOF CORRECTION SIGNS

Quiz

•

10th - 12th Grade

26 questions

Keyboard Letters

Quiz

•

1st - 12th Grade

21 questions

P5.js Exam 1

Quiz

•

9th - 12th Grade

23 questions

DDD2 Y10 19th July Networks

Quiz

•

10th Grade

24 questions

WORD Module 2 Review

Quiz

•

9th - 12th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade

10 questions

Exploring Digital Citizenship Essentials

Interactive video

•

6th - 10th Grade

Advanced Higher Databases: Relational Databases

What is a relational database?

What are the key features of a relational database?

What is a primary key in a relational database?

What is a foreign key in a relational database?

Discuss the concept of relationships in a relational database.

Discuss the role of SQL in relational databases.

What does the term 'mandatory relationship' mean in the context of databases?

What is a 'weak entity' in a database?

What does 'optional relationship' mean in the context of databases?

What is a surrogate key in a database?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers