Database Test Prep A

What is one of the functions of a relational database?

• To create graphics

• To store and organize data

• To edit videos

• To design websites

How can you distinguish between databases and spreadsheets?

• Databases are used for calculations, spreadsheets are not

• Databases store data in tables, spreadsheets do not

• Databases can handle large amounts of data efficiently, spreadsheets are limited

• Databases are only used for text data, spreadsheets are not

What is an advantage of using a database instead of spreadsheets?

• Databases are more expensive

• Databases are less secure

• Databases allow for better data management and retrieval

• Databases are harder to use

Which of the following is a real-world use for databases?

• Drawing illustrations

• Managing search engine data

• Composing music

• Writing novels

Which of the following is a database application?

• Adobe Photoshop

• Microsoft Access

• Final Cut Pro

• AutoCAD

What does SQL stand for?

• Simple Query Language

• Structured Query Language

• Standard Query Language

• Systematic Query Language

How is "big data" used in advertising?

• To create small-scale campaigns

• To analyze consumer behavior and target ads

• To reduce advertising costs

• To limit the reach of advertisements

What is a database?

• A file that stores data in an organized fashion so that information can be retrieved from it.

• A program that deletes unnecessary files.

• A tool for creating graphics.

• A type of computer virus.

Which of the following is an example of a database?

• iPod playlist

• A printed book

• A handwritten letter

• A painting

What is a flat-file database?

• A collection of data organized in rows and columns that can be used to store and manage information

• A complex database with multiple tables and relationships

• A type of database that uses hierarchical structures

• A database that only stores images