What a database is in Intro to Computing - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding the purpose of a database

Imagine you have a large collection of books at home. Which of the following best describes what a database does?

A It is like a bookshelf that organizes books so you can find any book quickly.

B It is like a notebook where you write stories by hand.

C It is like a television that shows movies.

D It is like a backpack that carries books around.

💡 Hint

Think about how you find a book quickly when you have many books.

A database organizes and stores data so you can easily find and use it, just like a bookshelf organizes books.

❓ trace

intermediate

Tracing data retrieval from a database

Look at the flowchart below that shows how a database retrieves information when you ask for it.

What is the correct order of steps when you search for a contact's phone number in a database?

A 2,1,3,4

B 1,3,2,4

C 1,2,3,4

D 1,2,4,3

💡 Hint

Think about what happens first: the user action or the database action.

The user first inputs the search, then the database looks up, finds, and returns the data in order.

❓ Comparison

advanced

Comparing databases and spreadsheets

Which statement correctly explains a key difference between a database and a spreadsheet?

A A spreadsheet stores data in tables, but a database stores data only as text files.

B A spreadsheet automatically backs up data, but a database never saves data.

C A database cannot sort data, but a spreadsheet can sort data easily.

D A database can handle large amounts of data efficiently and supports multiple users at once, while a spreadsheet is mainly for smaller data and single users.

💡 Hint

Think about how many people can use each tool and how much data they can handle.

Databases are designed for large data and multiple users; spreadsheets are simpler and usually for individual use.

❓ identification

advanced

Identifying database components

Which of the following is NOT a typical component of a database system?

A Query processor that interprets user requests.

B Spreadsheet formulas for calculations.

C Storage engine that saves data on disk.

D Transaction manager that ensures data consistency.

💡 Hint

Consider which component is more related to spreadsheets than databases.

Spreadsheet formulas are not part of database systems; databases use query processors, storage engines, and transaction managers.

🚀 Application

expert

Choosing the right database for a scenario

You are designing an app that needs to store user profiles with flexible fields that can change often. Which type of database is best suited for this?

A NoSQL database that allows flexible data structures.

B Spreadsheet software like Excel.

C Flat file database stored in plain text files.

D Relational database with fixed tables and columns.

💡 Hint

Think about which database type handles changing data structures easily.

NoSQL databases allow flexible, changing data fields, making them ideal for user profiles with varying information.