NEW
Font size
S
M
L
XL
WorksheetsDatabase - Intermediate Level Review
Total questions: 37
Worksheet time: 1hrs 17mins
Name
Class
Date
1.
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?
a)
Class Number
b)
Class Description
c)
Room Assignment
d)
Assignment Date
2.
Which of the following is an advantage of using a database to manage information?
a)
Numeric data can be presented in graphical form for quick analysis.
b)
Databases limit data to smaller, manageable amounts of records.
c)
Databases are easy to learn and use.
d)
Data is protected against accidental corruption.
3.
Brian has converted a spreadsheet into a database. Which operation did he perform?
a)
Exporting
b)
Importing
c)
Updating
d)
Creating
4.
Which database error commonly occurs when a user is creating a database that can result in data errors?
a)
Failing to identify a common field
b)
Forgetting to assign each record an ID
c)
Failing to add a foreign key
d)
Entering the wrong data type in a field
5.
Bethany is preparing the data in her database to be used in another program. Which operation is she performing?
a)
Exporting
b)
Updating
c)
Importing
d)
Creating
6.
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?
a)
One
b)
Three
c)
Five
d)
Six
7.
Which operation will create a join in a query?
a)
Creating a query using the Customer table
b)
Creating a query using multiple records
c)
Adding more than one table to a query
d)
Adding a query in the Table view
8.
You have been managing a database of classes, teachers, and students. The Atheltics department has asked you to include information about sports that the students participate in. They have provided a list of sports, and the students who participate, for you to import into your existing database. What will this create?
a)
A join
b)
A table
c)
A query
d)
A form
9.
Justine was reviewing a database report she generated for last month's cookie sales. One order was for 1,000 boxes of cookies – an extremely large request compared to all the other orders. Justine looked into the order and discovered the actual quantity ordered was 100 not 1,000 and changed that value in her database. What task did Justine complete?
a)
Deleting a record
b)
Sorting a record
c)
Adding a record
d)
Updating a record
10.
Brandon is creating a database that includes all of his friends' names, birthdates and ages. Which three data types does Brandon need to use?
a)
Date/Time, Number and Currency
b)
Text, Currency and Date/Time
c)
Text, Date/Time and Memo
d)
Text, Date/Time and Number
11.
Which statement is true about the data types that can be used in relational databases?
a)
Data types can only consist of text and numbers.
b)
Data types can consist of text, numbers and some graphic formats.
c)
Data can consist of any data types except for sound clips.
d)
Data can consist of multiple data types, including text, numbers, graphics, sound clips and video.
12.
Glenn is creating a database to store information about classes. Users complain that the class name is not appearing correctly when they enter and view records. What is the most likely cause of the problem?
a)
The class field has not been joined to the Instructor table
b)
The class table has not been sorted in alphabetical order
c)
The class table does not have a primary key
d)
The length of the class field is not long enough
13.
Steve has been given a list of products that are no longer being manufactured by his company. He needs to update the product database. What task will he be performing?
a)
Adding records
b)
Updating records
c)
Deleting records
d)
Sorting records
14.
Which statement is true about the functions of relational databases?
a)
Information can be related among multiple tables.
b)
You must enter the same data in multiple tables.
c)
All data is stored in one table.
d)
Records are not available in relational databases.
15.
What kinds of data types can be stored in relational databases?
a)
Memory
b)
Images
c)
Processes
d)
Queries
16.
As part of a research project about World War I, you are recording facts and statistics about each country's economy and social structure. Your information may be in a variety of formats: numbers, text, graphics, audio and video. In a relational database, data types can:
a)
Consist of multiple data types, including text, numbers, graphics, sound clips and video.
b)
Only consist of text and numbers.
c)
Consist of text, numbers and some graphic formats.
d)
Consist of any data types except for sound clips.
17.
Which is a function (use) of a relational database for a school?
a)
Teachers can keep a calendar of assignments.
b)
Student assignments can be saved and graded efficiently.
c)
Teachers can organize students by grade level and class period.
d)
Teachers can create a seating chart.
18.
Which language is used to develop and manage databases?
a)
SQL
b)
C++
c)
HTML
d)
Java
19.
Louis will be using his database to support his new web-based trading card shop. The database will need to insert, update and delete information about his customers, the trading cards he buys and sells and orders for the cards themselves. What language will he use to access and modify the information in his database through his website?
a)
SQL
b)
Java
c)
HTML
d)
C++
20.
You work for Google as a data analyst, researching and reviewing "big data" to better match a user's interests to the advertisements shown on the search results pages. Which answer below best defines the "big data" you are working with?
a)
Data sets that contain 2 gigabytes of data
b)
Large data sets of web addresses stored in a spreadsheet.
c)
Small data sets of Google user names in school's relational database.
d)
Large amounts of user-specific search criteria collected over time that cannot be stored or analyzed using traditional database tools.
21.
Databases used by organizations such as Google, Amazon, and Facebook are typically referred to as "big data." What does "big data" mean?
a)
Data sets that require multiple tables and records to store all the information
b)
Data sets that contain multiple data types
c)
Data sets that cannot be stored or processed using traditional database software
d)
Data sets that contain 2 gigabytes of data
22.
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?
a)
Field
b)
Column
c)
Table
d)
Record
23.
You have a table containing information about each course offered at your school. Within each record you want to capture a brief description of the course – less than 200 characters. Which data type should you select for your course description field?
a)
Currency
b)
Date/time
c)
Text
d)
Number
24.
Rajesh wants to compile a list of Italian language teachers and the students registered in each class. He has stored all the teacher, student and class information separately. Which of the following would Rajesh use to compile his list?
a)
Query
b)
Table
c)
Instance
d)
Keyword
25.
Lena needs to connect two tables in her database using database keys. In her first table, she has the following student information: First Name, Last Name, ID, Grade Level. The second table contains class information: Student ID, Class Number, Class Description, Room number. Which field is Lena's primary key for student information?
a)
Last Name
b)
Class Number
c)
Student ID
d)
ID
26.
Many-to-many relationships between tables are created using a junction table. Which table in the Relationships window below is the junction table?
a)
Aircraft Technical Specifications
b)
Engines
c)
Airlines
d)
Customers
27.
Which term describes a single entity composed of several data types in a database table?
a)
Column
b)
Field
c)
Record
d)
Row
28.
Which term describes a single entry of information of a particular data type in a database table?
a)
Range
b)
Field
c)
Row
d)
Record
29.
Which data type may contain text, numbers and/or certain special characters?
a)
Date/Time
b)
Text
c)
Number
d)
Currency
30.
Which type of database relationship allows one record in Table A to relate to many matching records in Table B, and vice versa?
a)
Primary-to-foreign
b)
Many-to-many
c)
One-to-one
d)
One-to-many
31.
Which operation will alter the "look and feel" of a report?
a)
Adding a report theme
b)
Creating a form
c)
Creating a query
d)
Inserting a new field
32.
Jennifer needs to create a presentation that summarizes the data in her database. Which of the following does she need to create?
a)
Record
b)
Report
c)
Query
d)
Field
33.
Which of the following occurs when you delete a record in the database?
a)
The record is deleted but may be restored from the Recycle Bin.
b)
The record is marked for deletion and will be overwritten by new data eventually.
c)
The record is permanently deleted and cannot be retrieved.
d)
The record is moved to the Deleted Items table.
34.
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?
a)
Updating a record
b)
Adding a record
c)
Sorting a record
d)
Deleting a record
35.
Which query type allows you to retrieve, view and print data?
a)
Select query
b)
Menu query
c)
Macro query
d)
Action query
36.
Which of the following is a unique identifier that is assigned to a field when a user creates a database table?
a)
Foreign key
b)
Primary key
c)
Report
d)
Query
37.
Which operation will create a join in a query?
a)
Creating a query using multiple records
b)
Adding more than one table to a query
c)
Adding a query in the Table view
d)
Creating a query using the Customer table
Reset
