Master Data Management: Learn Databases for Year 8 Computing

Question 1

Which column in this table is the primary key used to uniquely identify each row?

Accepted Answer

CustomerID

Answer

Customer Name

Answer

Customer Address

Answer

Customer Phone Number

Question 2

Which of the following is not considered good practice when designing a database?

Accepted Answer

Storing sensitive data in plain text

Answer

Ensuring data accuracy

Answer

Minimizing data redundancy

Answer

Allowing for easy data retrieval

Question 3

What is the key difference between a SELECT statement and an UPDATE statement in SQL?

Accepted Answer

SELECT retrieves data while UPDATE modifies data

Answer

UPDATE retrieves data while SELECT modifies data

Answer

They perform the same function

Answer

They cannot be used together in the same query

Question 4

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

Accepted Answer

Tabular

Answer

Hierarchical

Answer

Network

Answer

Object-oriented

Question 5

What is the function of a data dictionary in a database?

Accepted Answer

To store information about the database's structure and contents

Answer

To store the actual data in the database

Answer

To manage user access to the database

Answer

To optimize database performance

Question 6

Which data model represents data as a collection of interconnected objects and classes?

Accepted Answer

Object-oriented model

Answer

Hierarchical model

Answer

Network model

Answer

Relational model

Question 7

Which SQL command is used to create a new row in a database?

Accepted Answer

INSERT

Answer

SELECT

Answer

UPDATE

Answer

DELETE

Question 8

Which type of relationship exists when multiple rows in one table are related to a single row in another table?

Accepted Answer

One-to-many

Answer

One-to-one

Answer

Many-to-many

Answer

Recursive

Question 9

What is the difference between an Entity Relationship Diagram (ERD) and a database schema?

Accepted Answer

An ERD is a logical representation of the database, while a schema is a physical implementation.

Answer

A schema is a logical representation of the database, while an ERD is a physical implementation.

Answer

An ERD and a database schema are the same thing.

Answer

A database schema is a logical representation of the database, while an ERD is a physical implementation.

Question 10

What is the role of a transaction in a database?

Accepted Answer

To group a series of database operations that must succeed or fail together

Answer

To store temporary data that is not committed to the database

Answer

To provide a way to access data from multiple tables at the same time

Answer

To enforce security measures for the database

Question 11

What is the importance of indexing in databases?

Accepted Answer

To improve data retrieval speed and performance

Answer

To ensure data accuracy and integrity

Answer

To protect against malicious data input

Answer

To make data easier to understand

Question 12

What is a primary key's purpose in a database table?

Accepted Answer

To uniquely identify each row of data

Answer

To define the order of rows in the table

Answer

To restrict which rows can be deleted

Answer

To store the most important data in the table

Question 13

Which data model represents data as a network of interconnected nodes?

Accepted Answer

Network model

Answer

Relational model

Answer

Hierarchical model

Answer

Object-oriented model

Question 14

What is the key difference between a primary key and a candidate key?

Accepted Answer

A primary key is unique, whereas a candidate key may not be

Answer

A primary key is chosen by the user, whereas a candidate key is generated by the database

Answer

A candidate key can have null values, whereas a primary key cannot

Answer

There is no difference between a primary key and a candidate key

Question 15

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

Accepted Answer

To manage and control databases

Answer

To provide a graphical user interface for accessing databases

Answer

To process and analyze data in databases

Answer

To convert data from one format to another

Question 16

What is the purpose of a WHERE clause in an SQL query?

Accepted Answer

To filter the results based on a specified condition

Answer

To sort the results in a specific order

Answer

To group the results by a particular field

Answer

To update the data in a table

Question 17

What is the primary 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

Answer

To ensure that all data in the table is valid

Question 18

In relational databases, which data model is commonly used?

Accepted Answer

Entity-relationship model

Answer

Hierarchical model

Answer

Network model

Answer

Object-oriented model

Question 19

What is the main function of the SQL SELECT statement?

Accepted Answer

Retrieving data from a database

Answer

Creating a new database

Answer

Updating data in a database

Answer

Deleting data from a database

Question 20

What is the main purpose of a database index?

Accepted Answer

To enhance the speed of data retrieval

Answer

To guarantee data integrity

Answer

To store additional data about the table

Answer

To link the table to other tables

Question 21

Which of the following is NOT considered an advantage of using a database management system (DBMS)?

Accepted Answer

Data redundancy

Answer

Data sharing

Answer

Data security

Answer

Data integrity

Question 22

Can you describe the difference between a record and a field in a database table?

Accepted Answer

A record is a row of data, while a field is a column of data

Answer

A field is a row of data, while a record is a column of data

Answer

Records and fields are the same thing

Answer

There is no difference between a record and a field

Question 23

What is the primary objective of a database transaction?

Accepted Answer

To ensure consistency and accuracy of data

Answer

To increase the speed of data processing

Answer

To protect data from unauthorized access

Answer

To store data temporarily

Question 24

Which of the given options is not a type of database?

Accepted Answer

Electronic spreadsheet

Answer

Relational database

Answer

NoSQL database

Answer

Hierarchical database

Question 25

In a table, what is a primary key?

Accepted Answer

A column that identifies each row uniquely

Answer

A column that holds the most significant data

Answer

A column that arranges the data

Answer

A column that filters the data

Question 26

In the context of databases, what is the primary purpose of a SQL query?

Accepted Answer

To retrieve, insert, update, or delete data

Answer

To create or alter database tables

Answer

To manage user permissions

Answer

To optimize database performance

Question 27

Which of the listed software is NOT a database management system?

Accepted Answer

Google Sheets

Answer

MySQL

Answer

Oracle

Answer

Microsoft Access

Question 28

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 link the table to other tables

Answer

To ensure that data is entered correctly

Question 29

Which SQL command is used to create a new database?

Accepted Answer

CREATE DATABASE

Answer

NEW DATABASE

Answer

MAKE DATABASE

Answer

ADD DATABASE

Question 30

What is the purpose of a foreign key?

Accepted Answer

To establish a relationship between tables

Answer

To ensure that data is unique within a table

Answer

To prevent data from being deleted

Answer

To index data for faster retrieval

Question 31

Which data model represents data in a hierarchical structure, with parent-child relationships?

Accepted Answer

Hierarchical

Answer

Relational

Answer

Object-oriented

Answer

Network

Question 32

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

Accepted Answer

A record is a row of data, while a field is a column of data

Answer

A field is a row of data, while a record is a column of data

Answer

A record is a group of related fields, while a field is a single piece of data

Answer

A field is a group of related records, while a record is a single piece of data

Question 33

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

Accepted Answer

To speed up data retrieval by creating a direct path to specific data

Answer

To ensure that data is stored in a specific order

Answer

To prevent duplicate data from being entered

Answer

To compress data for storage efficiency

Question 34

Which of the following is a disadvantage of database normalization?

Accepted Answer

Increases database complexity

Answer

Reduces data redundancy

Answer

Improves data quality

Answer

Enhances database performance

Question 35

Which data type is best suited for storing customer phone numbers in a database?

Accepted Answer

String

Answer

Integer

Answer

Date

Answer

Boolean

Question 36

Which of the following is NOT a type of database model used in data management?

Accepted Answer

Spreadsheet

Answer

Relational

Answer

NoSQL

Answer

XML

Question 37

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

Accepted Answer

To uniquely identify each row

Answer

To store the most important data

Answer

To link tables together

Answer

To sort the data

Question 38

Which SQL command is used to establish a new table in a database?

Accepted Answer

CREATE TABLE

Answer

INSERT

Answer

SELECT

Answer

UPDATE

Question 39

What is the primary purpose of a foreign key in a database relationship?

Accepted Answer

To establish connections between tables

Answer

To limit data entry

Answer

To generate unique indexes

Answer

To store supplementary information

Question 40

Which of the following data types in SQL is intended to store dates and times?

Accepted Answer

DATETIME

Answer

INTEGER

Answer

VARCHAR

Answer

FLOAT

Question 41

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

Accepted Answer

A primary key is unique, while a candidate key is not.

Answer

A candidate key is unique, while a primary key is not.

Answer

There is no distinction between them.

Answer

A primary key can consist of multiple fields, but a candidate key cannot.

Question 42

Which of the mentioned options represents a logical data model?

Accepted Answer

Entity-Relationship Diagram

Answer

Relational Model

Answer

Hierarchical Model

Answer

Network Model

Question 43

What is the main advantage of using an index in a database?

Accepted Answer

Improved data retrieval speed

Answer

Ensuring data consistency

Answer

Storing supplementary data

Answer

Creating connections between tables

Question 44

What is the purpose of the SQL WHERE clause?

Accepted Answer

To select specific rows from a table

Answer

To create new rows in a table

Answer

To modify existing rows in a table

Answer

To delete rows from a table

Question 45

Which part of a table defines a unique identifier for each record?

Accepted Answer

Primary key

Answer

Foreign key

Answer

Attribute

Answer

Record

Question 46

What is the software that helps create, manage, and interact with databases called?

Accepted Answer

Database Management System (DBMS)

Answer

Database Editor

Answer

Query Processor

Answer

Data Manipulation Language (DML)

Question 47

Which data model arranges data into tables, where each table consists of rows and columns?

Accepted Answer

Relational model

Answer

Hierarchical model

Answer

Network model

Answer

Object-oriented model

Question 48

Which command in SQL is used to display data from a table?

Accepted Answer

SELECT

Answer

CREATE

Answer

UPDATE

Answer

INSERT

Question 49

Which type of database is designed to store vast amounts of unstructured data, like text or multimedia?

Accepted Answer

NoSQL database

Answer

Relational database

Answer

Object-oriented database

Answer

Hierarchical database

Question 50

In a database, what is the difference between a field and a record?

Accepted Answer

A field is a column, while a record is a row.

Answer

A field is a row, while a record is a column.

Answer

A field and a record are the same thing.

Answer

A field is a collection of records.

Question 51

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

Accepted Answer

To create a connection between two tables

Answer

To make sure data in a table is unique

Answer

To prevent unauthorized changes to data

Answer

To create an index for faster data retrieval

Question 52

Which type of data in a database is best suited for storing text, like names or addresses?

Accepted Answer

String

Answer

Integer

Answer

Boolean

Answer

Date

Question 53

What is the main purpose of using a query in a database?

Accepted Answer

To view or retrieve data from a table

Answer

To create a new table

Answer

To add new data to a table

Answer

To delete data from a table

Question 54

What is the primary purpose of a primary key?

Accepted Answer

To uniquely identify each record in a table.

Answer

To establish relationships between tables.

Answer

To ensure data accuracy.

Answer

To store the most important data in a table.

Question 55

Which data model represents data as a hierarchical structure?

Accepted Answer

Hierarchical

Answer

Relational

Answer

Entity-Relationship

Answer

Network

Question 56

What is the main function of the SQL SELECT statement?

Accepted Answer

To retrieve data from a table.

Answer

To create a new table.

Answer

To update data in a table.

Answer

To delete data from a table.

Question 57

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

Accepted Answer

Microsoft Access

Answer

Google Sheets

Answer

Microsoft Word

Answer

Adobe Photoshop

Question 58

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

Accepted Answer

A record is a row of data, while a field is a column of data.

Answer

A field is a row of data, while a record is a column of data.

Answer

A record and a field are the same thing.

Answer

There is no difference between a record and a field.

Question 59

Which of the following is NOT a benefit of using a database?

Accepted Answer

Unlimited data complexity.

Answer

Improved data accuracy.

Answer

Increased data accessibility.

Answer

Reduced data duplication.

Question 60

What is a database schema?

Accepted Answer

The structure and organization of a database.

Answer

The data stored in a database.

Answer

The software used to create a database.

Answer

The users who have access to a database.

Question 61

What is the purpose of a data model in a database?

Accepted Answer

To show the structure and relationships of data.

Answer

To store data in a specific format.

Answer

To ask questions about the data.

Answer

To make reports from the data.

Question 62

Which SQL command do we use to get data from a database?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 63

What is a primary key?

Accepted Answer

A field that makes each record in a table unique.

Answer

A field that holds the most important information in a table.

Answer

A field that connects tables together.

Answer

A field that we can use to sort data.

Question 64

Which data type do we use to store text in a database?

Accepted Answer

String

Answer

Integer

Answer

Boolean

Answer

Date