Database Essentials 1
This database exam will test your knowledge of basic concepts and terms associated with creating databases.
- 1.In a database containing information about North Carolina and its counties, how would you find the county with the most people?
- A.
Filter the population field using >10,000
- B.
Rank the counties by name and scroll through the list
- C.
Search each county record
- D.
Sort the records by population in descending order
- 2.When creating a database about African countries, what type of field would the square miles (land size) be?
- A.
Logical
- B.
Miles
- C.
Number
- D.
Text
- 3.What is the arrangement of data in a field in alphabetical order?
- A.
Filing
- B.
Numbering
- C.
Searching
- D.
Sorting
- 4.What is another term for the categories when creating a database?
- A.
Entry
- B.
Field
- C.
File
- D.
Record
- 5.Which is NOT a field type to consider when creating a database?
- A.
Date
- B.
Item
- C.
Number
- D.
Text
- 6.What are the four parts of a database listed in ascending order?
- A.
Entry, field, file, record
- B.
Entry, field, record, file
- C.
File, field, entry, record
- D.
File, record, field, entry
- 7.What term applies to a collection of related records in a database?
- A.
Clipboard
- B.
Field
- C.
File
- D.
Form
- 8.If books are organized from the most expensive to the cheapest, what is the sort order?
- A.
Ascending
- B.
Criterion
- C.
Descending
- D.
Numerical
- 9.What item could an electronic database be compared to?
- A.
Copier
- B.
Fax machine
- C.
File cabinet
- D.
Telephone
- 10.What do you call words like "and" and "or" when you are filtering, querying, or searching records?
- A.
Commands
- B.
Connectors
- C.
Forms
- D.
Operators
- 11.What is a group of related fields known as?
- A.
Characters
- B.
Data
- C.
Files
- D.
Records
- 12.What feature displays records that meet a specific criteria from a database?
- A.
Edit
- B.
Filter
- C.
Recall
- D.
View
- 13.Which is NOT true about database programs?
- A.
Are an excellent way to organize information
- B.
Can be printed
- C.
Can find information quickly
- D.
Can only hold up to 100 records
- 14.What is a wildcard?
- A.
A character to take the place of an unknown
- B.
A symbol such as
- C.
A way of sorting values in a deck of cards
- D.
An ace of spades
- 15.Why might a student use an electronic database?
- A.
Average his or her grades for math class
- B.
Keep tract of friends' names and addresses
- C.
Send an e-mail message to his or her parents
- D.
Write a report for a history class
- 16.What does descending order mean?
- A.
A to Z alphabetical order
- B.
Connecting order
- C.
Search numerical order
- D.
Z to A alphabetical order
- 17.Why would a travel agent use a database?
- A.
Communicate with cruise ships
- B.
Forecast the summer season
- C.
Get airline schedules for clients
- D.
Print vacation brochures
- 18.What type of software is designed to act as an electronic filing cabinet organizing collections of data?
- A.
Database
- B.
Desktop publishing
- C.
Spreadsheet
- D.
Word processing
- 19.How would you find the phone number of one particular student from 500 names and addresses of students enrolled at your school?
- A.
Perform a search of all boys in the database
- B.
Perform a search using the student's name as the criteria
- C.
Sort the database and scroll through the records
- D.
Sort the database in descending order
- 20.What is NOT a reason a business might use a computerized database?
- A.
Designing a brochure for advertising purposes
- B.
Keeping an appointment calendar with patients or customers
- C.
Keeping their inventory up to date
- D.
Maintaining a list of loyal customers
- 21.How do you write the mathematical operator "less than"?
- A.
=/
- B.
=
- C.
>
- D.
- 22.How do you write the mathematical operator "equal to or greater than"?
- A.
=&
- B.
=>
- C.
=
- D.
=+
- 23.If you had a database of names and phone numbers, what would LAST NAME, FIRST NAME, and PHONE NUMBER be examples of?
- A.
Data
- B.
Entries
- C.
Fields
- D.
Records
- 24.What operator would you use for the word "exceeds"?
- A.
- B.
>
- C.
=>
- D.
=
- 25.Which operator would you use for the words "at most"?
- A.
>
- B.
- C.
=>
- D.
=
Back to top