NEW
Font size
WorksheetsDatabase Module Concepts Quiz
Total questions: 30
Worksheet time: 15mins
What is the purpose of understanding different methods of storing data in a database module?
To learn how each method functions.
To learn how to code in Python.
To understand network protocols.
To design user interfaces.
Which task involves identifying the most common databases and their logical structure?
Analyzing database types and their organization.
Writing a program in Java.
Building a computer from scratch.
Designing a mobile application.
Suppose you are given a dataset and asked to store it efficiently. Which module outcome would help you decide the best method for storing the data?
Understanding the different methods of storing data and how each method functions.
Learning how to create graphics.
Studying operating system commands.
Practicing keyboard shortcuts.
Which of the following is NOT mentioned as something you want to track in managing an ice cream shop?
Which flavors you sell
How much of each flavor is left
The price of each flavor
Which flavors are most popular
How could organizing information about flavors, inventory, and ordering times help you make decisions in an ice cream shop?
It allows you to randomly select flavors to sell.
It makes it easier to find information and make informed decisions.
It helps you ignore customer preferences.
It prevents you from tracking inventory.
Which of the following best describes a database?
An organized storage system based on tables
A type of computer hardware
A programming language
A network protocol
Imagine you are tasked with creating a database for a photo gallery. Which types of information from the list provided would be essential to include in your database tables? (DoK Level 2)
Pictures and comments
Only dates
Only names
Only files
You are planning a database for a company. How would you use tables to organize information such as employee names, hire dates, and profile pictures? (DoK Level 3)
Create separate columns in a table for each type of information
Store all information in a single column
Use only one table for all employees without columns
Avoid using tables and store information randomly
Which of the following best describes the characteristic of "Centralized Access" in a database?
Many users can access it at the same time.
Only one user can access it at a time.
It cannot be accessed remotely.
It is only accessible by administrators.
A company expects its database to grow from a few records to millions over time. Which database characteristic is most important in this scenario?
Scalable
Centralized Access
Secure and Recoverable
Distributed
Why is scalability an important characteristic for modern databases?
It allows the database to handle both small and large amounts of data efficiently.
It ensures only authorized users can access the data.
It allows many users to access the database at the same time.
It prevents data from being backed up.
What ensures accurate records in a database?
Data validation
Simple structure
Small datasets
Single user access
Why might someone need to input records into an online database?
To store and organize information for future use
To delete old files from their computer
To increase the speed of their internet connection
To play online games
After running queries on websites, which of the following is a good way to analyze your results?
Identify the types of data you found
Change your password
Uninstall the browser
Restart your computer
Suppose you run several queries on a website. How could you strategically determine which search terms are most effective?
Compare the results from different search terms and evaluate which ones return the most relevant data
Use only random words and hope for the best
Avoid using any search terms at all
Only use the first word that comes to mind
What is a key requirement for accessing an online database such as Wikipedia?
Internet connection
CD drive
School server access
Account login
If you were designing a database for student records, which type of data structure would be most appropriate for storing names, ages, and grades?
Non-structured data
Structured data
Unordered data
Multimedia data
Which of the following is an example of semi-structured data?
A spreadsheet with only numbers.
A table with dates, senders, recipients, and both text and file attachments.
A list of random words.
A database with only images.
Why might semi-structured data be useful in a database?
It allows for flexibility by storing both organized and unorganized information together.
It only stores organized data, making it less flexible.
It is only used for storing images.
It cannot be used for communication between people.
What does the acronym RDBMS stand for?
Relational Database Management System
Random Data Management System
Reliable Database Management Software
Remote Data Backup Management System
If you were asked to research popular RDBMS applications, which of the following would be a correct approach?
Search for software used to manage relational databases
Look for applications that edit photos
Find programs for video streaming
Research operating systems for mobile devices
Given the key-value pair "Color: Red" in a key-value database, which statement best describes how the data is accessed?
The value "Red" is retrieved by searching for the key "Color"
The value "Color" is retrieved by searching for the key "Red"
The value "Red" is retrieved by searching for the key "Weight"
The value "Color" is retrieved by searching for the key "Year of Release"
Explain why key-value databases are considered suitable for applications requiring quick access to data. Use evidence from the key-value structure shown in the diagram.
Because each piece of data can be accessed directly using its unique key, reducing search time
Because they require complex joins to access data
Because they store data in large blocks, making retrieval slower
Because they use relational tables for data access
Which of the following best describes a document database?
A type of non-relational database
A type of relational database
A spreadsheet application
A programming language
Explain how the flexibility of document databases in storing data differs from traditional relational databases. Provide an example scenario where this flexibility is beneficial.
Document databases allow storage of varied and complex data structures, such as XML files, within a single field, unlike relational databases which require fixed schemas. For example, an e-commerce site can store customer orders with varying attributes (like different shipping addresses or payment methods) in a single document, making it easier to manage diverse data.
Relational databases allow more flexibility than document databases by storing images and videos in every field.
Document databases require all documents to have the same structure, making them less flexible than relational databases.
Relational databases and document databases both store data in the same way, with no difference in flexibility.
What does a database schema show in a relational database?
The database’s architecture, structure, and organization
The physical storage devices used
The programming language of the database
The user interface design
If you wanted to find all employees who have completed their training, which column in the table would you examine?
Training Status
Employee Name
Manager Name
Site
Explain how you would use the information in a relational database table to identify employees who have not completed their training.
Look for rows where the Training Status column does not have a check mark.
Look for rows where the Employee Name column is blank.
Look for rows where the Manager Name column is repeated.
Look for rows where the Site column is "Springfield".
Suppose you are designing a database for a university. The "StudentID" field is unique for each student. Which key would you assign to "StudentID" in the "Students" table, and why?
Primary key, because it ensures each student record is unique
Foreign key, because it links to another table
Secondary key, because it is not unique
Composite key, because it combines multiple fields
Which of the following is a key concept to understand when learning about databases?
Database concepts
Cooking techniques
Historical events
Literary devices
