Data Management for Year 7 Computing: Interactive Quizzes and Learning

Question 1

Which of the following is NOT a type of database?

Accepted Answer

Spreadsheet

Answer

Relational database

Answer

Network database

Answer

Hierarchical database

Question 2

What is a database?

Accepted Answer

A collection of data stored in a structured format

Answer

A website for online shopping

Answer

A music player software

Answer

A book with names and addresses

Question 3

Which of the following is a disadvantage of using a database?

Accepted Answer

Databases can duplicate data in different tables.

Answer

Data can be organized and structured for easy retrieval.

Answer

Databases can improve data security.

Answer

Databases can help make data more consistent.

Question 4

Which of these is a disadvantage of using a database?

Accepted Answer

Increased data vulnerability

Answer

Reduced data redundancy

Answer

Improved data consistency

Answer

Enhanced data sharing and collaboration

Question 5

Which of the following is a disadvantage of using a database compared to a spreadsheet?

Accepted Answer

Databases are more complex and difficult to use than spreadsheets.

Answer

Data is stored in a centralized location.

Answer

Data can be shared and updated easily.

Answer

Databases are typically more secure than spreadsheets.

Question 6

What is a key advantage of using a shared database instead of a spreadsheet?

Accepted Answer

Multiple users can access and modify data at the same time.

Answer

Databases are less prone to data loss than spreadsheets.

Answer

Creating a database is faster and easier than creating a spreadsheet.

Answer

Databases do not offer data querying capabilities.

Question 7

What is the primary characteristic of a database?

Accepted Answer

Data organized in tables and columns

Answer

Data stored on a hard drive

Answer

Data accessible only by administrators

Answer

Data not suitable for storing important information

Question 8

Databases offer several advantages. Which of the following is NOT a benefit of using a database?

Accepted Answer

Allows data duplication in multiple locations

Answer

Ensures data accuracy and consistency

Answer

Protects against unauthorized access

Answer

Accelerates searching for specific data

Question 9

What is a potential drawback of using a database?

Accepted Answer

Databases can be expensive to buy and maintain.

Answer

Data can be accessed by multiple users.

Answer

Data is automatically backed up.

Answer

Databases are easy to set up.

Question 10

Which of the following is NOT a type of database that stores data in a structured format?

Accepted Answer

Spreadsheet

Answer

Relational database

Answer

Hierarchical database

Answer

Network database

Question 11

Which of the following is **not** a type of database management system?

Accepted Answer

Spreadsheet

Answer

Relational Database Management System (RDBMS)

Answer

Document Database Management System (DDBMS)

Answer

Graph Database Management System (GDBMS)

Question 12

Which of the following is NOT a type of database?

Accepted Answer

Spreadsheet

Answer

Relational database

Answer

Hierarchical database

Answer

Object-oriented database

Question 13

Which of these is NOT a type of database?

Accepted Answer

Spreadsheet

Answer

Relational database

Answer

NoSQL database

Answer

Object-oriented database

Question 14

In database design, which diagram type shows the connections between tables?

Accepted Answer

Entity-Relationship Diagram (ERD)

Answer

Flowchart

Answer

Use Case Diagram

Answer

State Transition Diagram

Question 15

Which of these is not a type of database?

Accepted Answer

Hypertext database

Answer

Relational database

Answer

Object-oriented database

Answer

Flat-file database

Question 16

Which of these is a tool for visualizing data, rather than managing databases?

Accepted Answer

Tableau

Answer

MySQL

Answer

MongoDB

Answer

SQLite

Question 17

Which of the following is **not** a type of database management system (DBMS)?

Accepted Answer

File system

Answer

Relational DBMS

Answer

NoSQL DBMS

Answer

Cloud DBMS

Question 18

Which type of database stores data in tables and links them using relationships?

Accepted Answer

Relational database

Answer

Hierarchical database

Answer

Network database

Answer

Object-oriented database

Question 19

Which file extension is typically used for database files?

Accepted Answer

.db

Answer

.txt

Answer

.sql

Answer

.zip

Question 20

Which of the following is NOT a database management system?

Accepted Answer

Spreadsheet

Answer

Relational database management system

Answer

NoSQL database management system

Answer

Hierarchical database management system

Question 21

In a database, what is a record?

Accepted Answer

A set of related data items

Answer

A collection of tables

Answer

A unique identifier for each row

Answer

The output of a query

Question 22

When creating a database, what's the best way to name your tables?

Accepted Answer

Use names that describe what the table is about, like "Customer Information" or "Order Details."

Answer

Use short names like "Table1" or "Data."

Answer

Use abbreviations to save space, like "Cust" for "Customer."

Answer

Use names that reflect how the data is stored in the database.

Question 23

What is a primary function of a database management system (DBMS)?

Accepted Answer

Organizes and stores data in a structured manner.

Answer

Allows unrestricted data modification by all users.

Answer

Designed specifically for storing disorganized data.

Question 24

In a database, what is a potential issue caused by excessive data duplication?

Accepted Answer

Data inconsistencies

Answer

Enhanced data protection

Answer

Quicker data retrieval

Question 25

Which SQL command is used to add new data to a table?

Accepted Answer

INSERT INTO

Answer

ADD RECORD

Answer

APPEND

Question 26

Which of the following is NOT a type of database?

Accepted Answer

Spreadsheet

Answer

Relational database

Answer

Hierarchical database

Answer

Network database

Question 27

Which SQL command lets you get specific data from a database table, giving you more control over what data you want?

Accepted Answer

SELECT

Answer

UPDATE

Answer

INSERT

Answer

DELETE

Question 28

In SQL, which operator is used to determine if two values are identical?

Accepted Answer

=

Answer

>

Answer

<

Answer

!=

Question 29

In a database, what is the term for the way data is structured and organized?

Accepted Answer

Data Model

Answer

Data Integrity

Answer

Data Normalization

Answer

Data Manipulation Language

Question 30

What's the primary purpose of a primary key in a database?

Accepted Answer

Ensuring each row in a table is unique

Answer

Setting the highest value allowed in a field

Answer

Setting the lowest value allowed in a field

Answer

Defining the data type of a field

Question 31

What is the main purpose of a database management system (DBMS) like Microsoft Access?

Accepted Answer

Organizing data in tables, queries, forms, and reports within a database.

Answer

Managing hardware devices like printers or keyboards.

Answer

Handling electronic documents and presentations.

Answer

Creating and editing spreadsheets like those in Microsoft Excel.

Question 32

What is the main purpose of a database?

Accepted Answer

To store and organize large amounts of structured data in one place

Answer

To perform complex calculations on large datasets

Answer

To create interactive websites

Answer

To protect sensitive information from unauthorized access

Question 33

What is a structured collection of related data called?

Accepted Answer

Database

Answer

Spreadsheet

Answer

Word Processor

Answer

Presentation Software

Question 34

Which of the following is a database management system (DBMS)?

Accepted Answer

MySQL

Answer

Microsoft Excel

Answer

Google Drive

Question 35

To prevent repeating data in a database, which technique is most effective?

Accepted Answer

Relational database model with normalization

Answer

Flat file structure

Answer

Hierarchical database model

Answer

Network database model

Question 36

What is the primary responsibility of a database management system (DBMS)?

Accepted Answer

Creating and managing databases, including storing and retrieving data

Answer

Designing and developing database software

Answer

Ensuring data security and accuracy

Answer

Providing access and modification capabilities for users

Question 37

Which of the following is **not** a type of database?

Accepted Answer

Spreadsheet

Answer

Relational database

Answer

Object-oriented database

Answer

Graph database

Question 38

Which of these is not a type of database?

Accepted Answer

File system

Answer

Relational

Answer

Hierarchical

Answer

NoSQL

Question 39

What is the purpose of Structured Query Language (SQL)?

Accepted Answer

SQL is a programming language used to create and manage databases.

Answer

SQL is a tool used to design and implement database structures.

Answer

SQL is a type of database management system.

Answer

SQL is only used for retrieving data from databases.

Question 40

What is the main purpose of database relationships?

Accepted Answer

To link related data across tables for efficient retrieval

Answer

To connect multiple databases and share data

Answer

To define rules for data entry and storage

Answer

To create a visual representation of the database structure

Question 41

Why is data integrity important in databases? How do constraints and validation rules help maintain it?

Accepted Answer

Data integrity ensures accurate and consistent data, building trust in the database.

Accepted Answer

Constraints and validation rules prevent incorrect data entry, safeguarding data integrity.

Answer

Data integrity is not a major concern, as data can be easily corrected later.

Answer

Constraints and validation rules hinder data entry and database maintenance.

Question 42

Which of the following best describes the hierarchical database model?

Accepted Answer

A model where data is organized in a tree-like structure, with each parent record having multiple child records and each child record having only one parent.

Answer

A model where data is stored in a flat structure, with all records at the same level and no parent-child relationships.

Answer

A model where records can have multiple parents and multiple children.

Answer

A model where nodes and edges are used to represent relationships between data items.

Question 43

Which database constraint guarantees that every value in a particular field is one-of-a-kind?

Accepted Answer

Primary key

Answer

Foreign key

Answer

Check constraint

Answer

Data integrity constraint

Question 44

In a database, which fundamental data structure stores organized information?

Accepted Answer

Table

Answer

Function

Answer

Loop

Answer

Array

Question 45

Which SQL command is used to retrieve data from a database?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 46

In a database, which data type is suitable for storing text information?

Accepted Answer

String

Answer

Integer

Answer

Boolean

Answer

Date

Question 47

Which database normalization technique involves breaking down a table into smaller tables?

Accepted Answer

Decomposition

Answer

Denormalization

Answer

Aggregation

Answer

Replication

Question 48

Which of the following is a fundamental principle in database design?

Accepted Answer

Data normalization

Answer

Data reliability

Answer

Data duplication

Answer

Data inconsistency

Question 49

What is the primary purpose of a primary key in a database table?

Accepted Answer

To uniquely identify each record in the table

Answer

To store the most important data in the table

Answer

To establish relationships between tables

Answer

To ensure that all data in the table is correct

Question 50

Which SQL command is used to select data from a database?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 51

What is the distinction between a field and a record in a database?

Accepted Answer

A field is a single data element, while a record is a collection of related fields.

Answer

A record is a single data element, while a field is a collection of related records.

Answer

A field and a record are the same thing.

Answer

A record is a subset of a field.

Question 52

Which data type would be most appropriate for storing a customer's address in a database?

Accepted Answer

String

Answer

Integer

Answer

Date

Answer

Boolean

Question 53

What is the primary function of a database management system (DBMS)?

Accepted Answer

To manage, create, and retrieve data from databases

Answer

To secure data from unauthorized access

Answer

To optimize database performance

Answer

To convert data from one format to another

Question 54

What is the key difference between a relational database and a non-relational database?

Accepted Answer

Relational databases organize data in tables, while non-relational databases do not.

Answer

Non-relational databases are generally more efficient than relational databases.

Answer

Relational databases are more scalable than non-relational databases.

Answer

There is no fundamental difference between relational and non-relational databases.

Question 55

What type of data is used to store whole numbers in a database?

Accepted Answer

Integer

Answer

Text

Answer

Boolean

Answer

Float

Question 56

What's the purpose of a primary key in a database table?

Accepted Answer

Identifies each record uniquely

Answer

Stores the most important data

Answer

Allows sorting of table data

Answer

Enforces data integrity

Question 57

To create a new database in SQL, which command would you use?

Accepted Answer

CREATE DATABASE

Answer

CREATE TABLE

Answer

INSERT INTO

Answer

SELECT FROM

Question 58

What's the primary purpose of a foreign key in a database table?

Accepted Answer

Establishes a link between two tables

Answer

Stores additional details about a record

Answer

Guarantees data consistency across tables

Answer

Enhances query performance

Question 59

What's the key distinction between a logical database model and a physical database model?

Accepted Answer

Logical models represent data, while physical models show storage methods

Answer

Physical models represent data, while logical models show storage methods

Answer

Logical models are created before physical models, while physical models come after

Answer

Physical models are created before logical models, while logical models come after

Question 60

What's the purpose of a database schema?

Accepted Answer

Defines the structure of a database

Answer

Stores data within the database

Answer

Queries data stored in the database

Answer

Manages users and their permissions for the database

Question 61

Which of the following is NOT a common data type in a database?

Accepted Answer

List

Answer

Integer

Answer

String

Answer

Boolean

Question 62

What is the main purpose of a primary key in a database table?

Accepted Answer

To uniquely identify each row in the table

Answer

To store the most important data in the table

Answer

To link the table to other tables in the database

Answer

To ensure that the data in the table is always accurate

Question 63

What is the primary purpose of a SQL query?

Accepted Answer

To retrieve data from an existing database

Answer

To create a new database

Answer

To modify data in an existing database

Answer

To delete data from an existing database

Question 64

What is the main purpose of an index in a database table?

Accepted Answer

To speed up data retrieval

Answer

To ensure that data is always sorted in a specific order

Answer

To prevent duplicate data from being inserted into the table

Answer

To enforce data integrity