Search Header Logo

10 CT Analysing Data Wk7 PostQuiz

Authored by Alex Song

Computers

9th Grade

Used 1+ times

10 CT Analysing Data Wk7 PostQuiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

21 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When modelling a Student entity, which of the following is an attribute?

Enrolment

Course

Date of Birth

Registration event

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In an event-based model, “Payment Received” is best classified as a(n):

Entity

Attribute

Event

Relationship

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In a relational database, the link between Customer and Order tables is usually implemented with:

Identical primary keys in both tables

A foreign key in Order referencing Customer

A lookup list in Customer

A composite key of Product attributes

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

“One department employs many employees” exemplifies which cardinality?

1:1

1:Many

Many:Many

Recursive

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A spreadsheet is more usable than a database when you need to:

Perform multi-table joins

Create a quick pivot chart on one table

Enforce referential integrity

Handle millions of rows

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A core usability advantage of a relational DB over a spreadsheet is its ability to:

Spell-check automatically

Visualise data instantly

Enforce data types and relationships

Edit multiple cells at once

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL statement returns all distinct customer regions from Sales?

SELECT UNIQUE region FROM Sales;

SELECT DISTINCT region FROM Sales;

SELECT region UNIQUE FROM Sales;

SELECT region FROM Sales DISTINCT;

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?