WorksheetsDatabase Test Prep A
Total questions: 52
Worksheet time: 26mins
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
What is a simple way to create a flat-file database?
Using a spreadsheet
Using a word processor
Using a graphic design tool
Using a web browser
What type of data works great with flat-file databases?
Small lists of related data
Large, complex datasets
Unrelated random data
Multimedia files
How is information stored in a flat-file database?
In cells created by using columns and rows of data
In a single continuous text file
In a series of interconnected nodes
In a cloud-based storage system
What is one advantage of using spreadsheets?
Difficult to learn and use
Great for analyzing and sorting related data
Unsuitable for storing numerical data
Cannot present data graphically
How are spreadsheets suitable for handling data?
Suitable for storing and "crunching" large volumes of data
Suitable for storing and "crunching" relatively small volumes of numerical data
Not suitable for storing any data
Only suitable for text data
What is a feature of spreadsheets in terms of data presentation?
Unable to present data graphically
Able to present numerical data in the graphical form to quickly analyze data
Only presents data in text form
Only suitable for manual calculations
What is one disadvantage of using spreadsheets?
They allow for complex data analysis.
They require entering the same information in multiple places.
They have unlimited storage capacity.
They automatically save changes.
Which of the following is true about the sorting and querying capabilities of spreadsheets?
They are highly advanced.
They are simplistic.
They are non-existent.
They are customizable.
What happens to changes made to data in a spreadsheet before the file is saved?
They are automatically saved.
They are lost.
They remain in computer memory.
They are backed up.
What is a limitation of spreadsheets regarding the number of records?
They can store an infinite number of records.
They contain only a finite number of records.
They have no limit on records.
They can store records indefinitely.
What does the phrase "Garbage in, garbage out" imply in terms of data integrity?
Data should be stored in garbage bins.
Incorrect input leads to incorrect output.
Data should be recycled.
Garbage data is useful.
Which of the following is NOT a correct representation of the state of Arizona?
ARIZONA
Ariz
AZ
ARZ
What is the first step in creating tables according to the document?
Create a separate table for each data type
Identify duplicate data
Relate data back to the original table
Delete duplicate data
What should you do if duplicate data exists?
Delete the duplicate data
Ignore the duplicate data
Create a separate table just for that data
Merge the duplicate data
What is the final step in the process of creating tables?
Identify duplicate data
Create a separate table for duplicate data
Relate it back to the original table
Delete the original table
What is a relational database?
A single table of data
A database with no relationships
Consists of multiple tables of information related through common fields
A database with only one field
What is the maximum amount of data that can be held, as mentioned in the advantages?
1 gigabyte
2 gigabytes
5 gigabytes
10 gigabytes
What advantage allows multiple individuals to access and query data simultaneously?
Data redundancy
Manual data entry
Simultaneous access
Data corruption
How is data protected according to the advantages listed?
By keeping redundant data
Against inadvertent corruption
By manual entry
By increasing processing time
What is reduced by minimizing the entering of information?
Data redundancy
Processing time
Input time, resources, and opportunities for human error
Data corruption
What is one of the benefits of reduced processing time?
Increased data redundancy
Increased manual entry
Reduced cost and increased data integrity
Increased data corruption
What is one disadvantage of using relational tables compared to spreadsheets?
They are easier to learn and use.
They are less complex.
Designing them is more difficult and time-consuming.
They have lower software and hardware costs.
Why might software and hardware costs be considered a disadvantage of relational tables?
They are lower than spreadsheets.
They are the same as spreadsheets.
They are higher than spreadsheets.
They are negligible.
How do relational tables compare to spreadsheets in terms of complexity?
They are less complex.
They are equally complex.
They are more complex.
They have no complexity.
What is Microsoft Access primarily used for?
Creating and manipulating large, complex databases
Creating and manipulating fairly small and uncomplicated databases
Designing websites
Developing mobile applications
Which of the following is a feature of Microsoft Access?
Command-line interface
Graphical user interface
Cloud storage
Real-time collaboration
Which of the following is NOT a high-end DBMS program?
Oracle
MySQL
Microsoft Access
IBM’s DB2
What type of databases are Oracle, MySQL, IBM’s DB2, and Microsoft SQL Server used for?
Small and uncomplicated databases
Large, complex databases
Personal databases
Temporary databases
What does SQL stand for?
Structured Query Language
Simple Query Language
Standard Query Language
Sequential Query Language
How is SQL pronounced?
Sequel
Squeal
S-QL
Squeak
What is SQL primarily used for?
Developing and managing databases
Designing websites
Creating graphics
Writing software code
Which of the following tasks can SQL perform?
Retrieve, update, insert, or remove information
Edit videos
Design user interfaces
Create animations
What does ODBC stand for?
Open Database Connectivity
Open Data Connection
Online Database Connection
Open Data Communication
What is the primary function of ODBC?
To provide an open standard API for accessing DBMS data
To create databases
To manage network connections
To encrypt data
Which tool does ODBC allow us to use to access DBMS data?
MS Access
Excel
Word
PowerPoint
What is a benefit of using a simplified GUI like MS Access?
It allows novices to build queries and reports easily
It requires advanced programming skills
It is only for professional developers
It is used for graphic design
Diagram showing ODBC as a standard platform interacting with various databases like Oracle, SQL Server, MySQL, and DB2.
ODBC interacts with Oracle, SQL Server, MySQL, and DB2.
ODBC is a database itself.
ODBC only works with SQL Server.
ODBC is a programming language.
What is a characteristic of big data compared to regular database data?
It is structured and related.
It is unstructured and unrelated.
It is smaller in volume.
It requires no specialized tools for analysis.
What is required for the analysis of big data?
Regular database programs.
No tools are needed.
Specialized tools.
Simple spreadsheets.
What is a key benefit of using SQL in database management?
It is only used for creating databases.
It allows for efficient data retrieval and manipulation.
It is a programming language for web development.
It is used for graphic design.
Which of the following is a common feature of relational databases?
They store data in a flat file format.
They use tables to organize data.
They are only used for text data.
They do not support data relationships.
What is a primary use of data normalization in databases?
To increase data redundancy.
To simplify data entry.
To reduce data redundancy and improve data integrity.
To make databases more complex.
