Database Software Basics Answers

20 verified answers2 views
1
Free Preview

Which of the following is the most compelling reason to use a database?

A
to compare data
B
to organize data into columns and rows
C
to perform complex calculations
D
to store large amounts of information
2
Free Preview

Suppose you switched from using a single spreadsheet to multiple data tables in a database. Which of the following advantages are you most likely going to experience by making the switch?

A
You can group information by category.
B
You can organize data into fields and records.
C
You can avoid updating records in multiple places.
D
You can search for specific data.
8

Why is a database the best tool for managing the social media website’s data? Choose all that apply.

A
The website needs to process credit card payments.
B
The website has a large amount of information that needs to be stored.
C
There are many relationships between different types of information.
D
There is an increasing number of users.
9

Which of the following describes the first step to creating a database?

A
Organize data into logical tables and fields.
B
Create relationships within tables.
C
Determine data to be stored.
D
Create relationships between tables.
10

How should you set up the database?

A
Use one large table containing all information.
B
Use several interrelated tables.
C
Use one table for each city and each state.
12

What is the primary key in the Products table?

Answers:
Selection 1:Product ID
Selection 2:Store ID
Selection 3:Store ID
Selection 4:Store ID
Selection 5:Employee ID
15

In which of the following steps do you assign a primary key to each table?

A
Create relationships within tables.
B
Create relationships between tables.
C
Organize data into logical tables and fields.
D
Determine data to be stored.
16

Which of the following should you choose for the tables?

A
one table called Populations and another table called Cities
B
one table called Primary Industry, a second table called States, and a third table called Cities
C
one table called States and another table called Cities

Did you find these answers helpful?