WorksheetsDatabase Quiz
Total questions: 11
Worksheet time: 11mins
Advantages of relational databases over flat files include:
Efficiency
Flexibility
Accuracy
All of the above
Which database component feeds data into tables?
form
query
report
vlookup
Large databases in organizations must be scalable, support many concurrent users, and
protect access to data
use Linux operating systems
have more than 100000 tables
compress stored data to half its original size
Which character is used in queries to designate any text string (any characters of any length)? Hint: wildcard symbol
?
^
*
!
&
Which of the following choices can appear only once (no duplicates) in a table?
Queries
Calculated data
Foreign Key
Primary key
Which of the following is an appropriate primary key for a student record in the WMU student database?
Birth date
WIN number
Major
Home town
What database component stores data?
Table
Form
Query
Report
Databases do all of the following except
Retrieve Data
Create Data
Organize and Filter Data
Store Data
Which of the following choices is a field?
Name
John Fetzer
7-2332
123 Sesame St
All of the above
Which database component filters data and returns a subset of the data stored in the database responding to a question asked of the data?
Table
Form
Query
Report
Given the relationship diagram shown, which are primary tables?
Customers and Cars
Customers and SalesTransaction
Cars and SalesTransaction
Cars Only
SalesTransaction Only
