James has just inserted his grade for a quiz into a new database table. Which operation has James just performed?
adding a record
Deleting a record
sorting a record
updating the record
2. Multiple Choice
15 minutes
1 pt
Which database component is commonly referred to as a table row within a database
Field
Column
Title
Record
3. Multiple Choice
15 minutes
1 pt
Study this example of a database. Which field uses the Number format?
Name
Age
Favorite Color
Birthdate
4. Multiple Choice
15 minutes
1 pt
Which of the following is used by advertisers to determine the best method to reach their target markets?
Big data
A list of phone numbers to call
Mass mailing
A spreadsheet of customer names
5. Multiple Choice
15 minutes
1 pt
Which statement is true about records when they are deleted from a database table?
Records cannot be deleted from a database table.
Records are removed completely from the table.
Records are hidden within the table.
Records are saved for later use.
6. Multiple Choice
15 minutes
1 pt
Which of the following allows a user to create a table or report based on specific fields within a database?
Table
Field
Query
Record
7. Multiple Choice
15 minutes
1 pt
Which of the following consists of multiple tables of information that are related through common fields?
Text document
Presentation
Relational database
Spreadsheet
8. Multiple Choice
15 minutes
1 pt
Johann is creating a database field which will store descriptive text about products. Which data type should he set for this field?
Numeric
Text
Yes/No
Memo
9. Multiple Choice
15 minutes
1 pt
What kind of data would an art gallery retail store need to store in a database?
Inventory, prices, sales, customer information
Schedules of demonstrations, classes and special events
Marketing flyers, post cards and advertisements
Artist biographies, resumes, and art techniques
10. Multiple Choice
15 minutes
1 pt
Lisa changes her home address in a database field to her new address. This is an example of what type of operation
Deleting a record
Updating a record
Adding a record
Sorting a record
11. Multiple Choice
15 minutes
1 pt
Which type of software is considered the most difficult to learn
Text document software
Database software
Basic image-editing software
Presentation software
12. Multiple Choice
15 minutes
1 pt
Which operation allows you to arrange database records in alphabetical order
Adding
Updating
Sorting
Filtering
13. Multiple Choice
15 minutes
1 pt
Which of the following is an advantage of using databases instead of spreadsheets
Multiple people can use the same database data at a time.
Databases consist simply of worksheets.
Databases are easier to learn than spreadsheets
Only one person can use the same database data at a time.
14. Multiple Choice
15 minutes
1 pt
Which database component is used to organize information by data type?
Row
Title
Field
Record
15. Multiple Choice
15 minutes
1 pt
Study this example of a database. Which field is sorted in numerical order?
id
Zip Code
name
birthdate
16. Multiple Choice
15 minutes
1 pt
Which of the following is used to retrieve specific information from a database?
Keyword
Table
Instance
Query
17. Multiple Choice
15 minutes
1 pt
Study this example of a database. Which database component is shown outlined in red
Record
Heading
Row
Field
18. Multiple Choice
15 minutes
1 pt
Which tool allows a user to store organized information that can easily be accessed, edited and queried?
Database
Calculator
Text document
Pen and paper
19. Multiple Choice
15 minutes
1 pt
Yes/No, Date/Time and Number are examples of:
data types.
tabs you can select.
data queries.
records in a data table.
20. Multiple Choice
15 minutes
1 pt
Study this example of a database. Which database component is shown outlined in red
Record
Column
Field
Heading
21. Multiple Choice
15 minutes
1 pt
Which data type may contain text, numbers and/or certain special characters?
Number
Text
Date/time
Currency
22. Multiple Choice
15 minutes
1 pt
Which term describes a single entry of information of a particular data type in a database table?
Row
Field
Range
Record
23. Multiple Choice
15 minutes
1 pt
Bethany is preparing the data in her database to be used in another program. Which operation is she performing?
Importing
Exporting
Creating
Updating
24. Multiple Choice
15 minutes
1 pt
Which operation will alter the "look and feel" of a report?
Creating a form
Adding a report theme
Inserting a new field
Creating a query
25. Multiple Choice
15 minutes
1 pt
Brian has converted a spreadsheet into a database. Which operation did he perform?
Exporting
Importing
Updating
Creating
26. Multiple Choice
15 minutes
1 pt
Which type of database relationship allows one record in Table A to relate to many matching records in Table B, and many records in Table B to relate to only one matching record in Table A?
One-to-one
Many-to-many
One-to-many
Primary-to-foreign
27. Multiple Choice
15 minutes
1 pt
Which language is used to develop and manage databases?
Java
SQL
HTML
C++
28. Multiple Choice
15 minutes
1 pt
Which query type allows you to retrieve, view and print data?
Action query
Select query
Macro query
Menu query
29. Multiple Choice
15 minutes
1 pt
Jennifer needs to create a presentation that summarizes the data in her database. Which of the following does she need to create?
Query
Report
Field
Record
30. Multiple Choice
15 minutes
1 pt
Study this example of a database. Which database component is shown outlined in red?
Field
Record
Heading
Column
31. Multiple Choice
15 minutes
1 pt
What kinds of data types can be used in relational databases?
Memory
Images
Processes
Queries
32. Multiple Choice
15 minutes
1 pt
Which of the following is a unique identifier that is assigned to a field when a user creates a database table?
Report
Primary key
Query
Foreign key
33. Multiple Choice
15 minutes
1 pt
Which tool allows a user to store organized information that can easily be accessed, edited and queried?
Pen and paper
Database
Calculator
Text document
34. Multiple Choice
15 minutes
1 pt
Yes/No, Date/Time and Number are examples of:
data queries.
data types.
tabs you can select.
records in a data table.
35. Multiple Choice
15 minutes
1 pt
Which database error commonly occurs when a user is creating a database that can result in data errors?
Failing to add a foreign key
Entering the wrong data type in a field
Forgetting to assign each record an ID
Failing to identify a common field
36. Multiple Choice
15 minutes
1 pt
Databases used by organizations such as Google, Amazon, and Facebook are typically referred to as "big data." What does "big data" mean?
Data sets that contain 2 gigabytes of data
Data sets that cannot be stored or processed using traditional database software
Data sets that require multiple tables and records to store all the information
Data sets that contain multiple data types
37. Multiple Choice
15 minutes
1 pt
Daniel works at a hospital. He is creating a database for his patient care department. Which type of information would be included in his database?
Teacher contact numbers
Patient allergy notes
Web page descriptions
Sports game schedules
38. Multiple Choice
15 minutes
1 pt
Brandon is creating a database that includes all of his friends' names, birthdates and ages. Which three data types does Brandon need to use?
Date/Time, Number and Currency
Text, Date/Time and Memo
Text, Date/Time and Number
Text, Currency and Date/Time
39. Multiple Choice
15 minutes
1 pt
Justine was adding data records to her database when she noticed that her brother’s birthdate was listed incorrectly. She immediately corrected the error and saved her database. Which database operation did Justine perform?
Sorting a record
Deleting a record
Updating a record
Adding a record
40. Multiple Choice
15 minutes
1 pt
Spencer has a database of 2000 customers. He needs to print mailing labels. He can get a discount on the postage, if he delivers the labeled mail in an organized way. Which field should he sort his list by, to take advantage of the discount?
Phone number
E-mail address
Zip/postal code
Last name
41. Multiple Choice
30 seconds
1 pt
You are helping a friend build a query for his database. His database has five tables and no table relationships exist. You add three tables to the query. Before you can proceed with selecting fields for the query, which task must you complete?
Creating a table join
Inserting a primary key
Inserting a foreign keyInserting a foreign key
Merging two tables
42. Multiple Choice
30 seconds
1 pt
Your relational database tracks your cookie sales to your local customers. A member of your staff has received a request to remove a customer from the Customers table. What is the first step taken before the customer record is removed?
Confirm that the customer record can be deleted without adversely affecting any other objects in the database.
Create a new report that excludes the customer record from all of your sales reports.
Contact your bank to notify them that you are removing a customer record.
Send a letter to the customer notifying them that their record is being removed from your database.
43. Multiple Choice
30 seconds
1 pt
When entering a student’s information in a table, you must enter a Name, Street Address, City, State, Zip code and Phone number. If you enter this information for a student, how many records have you created?
One
Five
three
Six
44. Multiple Choice
30 seconds
1 pt
Mary has created a table that contains the following fields of information: Class Number, Class Description, Room Assignment, Assignment Date and Teacher ID. Which field would require a text data type?
Class Description
Assignment Date
Room Assignment
Teacher ID
45. Multiple Choice
30 seconds
1 pt
You are reviewing a collection of data about cookie sales for the Good Cookie Company. You need to group the data by month, calculate the total sales, define the average sales per quarter and show your results in a chart. Which application would be the best for performing all of these tasks?
Excel
Access
Word
PowerPoint
46. Multiple Choice
30 seconds
1 pt
Nadia is creating a table of financial transactions. In each record, she will capture the date and type of transaction, the person who recorded it and the amount. Which data type should she set for the field containing the transaction amount?
Currency
Text
Number
Date/time
47. Multiple Choice
30 seconds
1 pt
You have a large collection of related data. You want to use a relational database but your partner wants to use a spreadsheet. Which of the following would you share with your partner as an advantage of using databases instead of spreadsheets?
Databases remove the need for redundant data.
Databases consist simply of worksheets.
Databases are easier to learn than spreadsheets.
Only one person can use the same database data at a time.
48. Multiple Choice
30 seconds
1 pt
The information in your table is not appearing correctly. You entered the date “10/1/2015” but what appears is the number “42278”. Which database component should be inspected to determine why the data does not display correctly?
Field
Table
Column
Record
49. Multiple Choice
30 seconds
1 pt
Your team is complaining about entering data into your table using the Datasheet view. They are asking your help to make data entry easier. Which database component can you use to help your team with data entry?
Form
Table
Field
Record
50. Multiple Choice
30 seconds
1 pt
A Groups and Totals report is used to group information by one or more fields. In most reports, the fields being used to group the data will be displayed above the records that are contained in the group. What is the name of report section that stores and displays these fields in a report?