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
Correct Answer
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
Correct Answer
C. Number -
- 3.
What is the arrangement of data in a field in alphabetical order?
- A.
Filing
- B.
Numbering
- C.
Searching
- D.
Sorting
Correct Answer
D. Sorting -
- 4.
What is another term for the categories when creating a database?
- A.
Entry
- B.
Field
- C.
File
- D.
Record
Correct Answer
B. Field -
- 5.
Which is NOT a field type to consider when creating a database?
- A.
Date
- B.
Item
- C.
Number
- D.
Text
Correct Answer
B. Item -
- 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
Correct Answer
A. Entry, field, file, record -
- 7.
What term applies to a collection of related records in a database?
- A.
Clipboard
- B.
Field
- C.
File
- D.
Form
Correct Answer
C. File -
- 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
Correct Answer
C. Descending -
- 9.
What item could an electronic database be compared to?
- A.
Copier
- B.
Fax machine
- C.
File cabinet
- D.
Telephone
Correct Answer
C. File cabinet -
- 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
Correct Answer
B. Connectors -
- 11.
What is a group of related fields known as?
- A.
Characters
- B.
Data
- C.
Files
- D.
Records
Correct Answer
D. Records -
- 12.
What feature displays records that meet a specific criteria from a database?
- A.
Edit
- B.
Filter
- C.
Recall
- D.
View
Correct Answer
B. Filter -
- 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
Correct Answer
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
Correct Answer
A. A character to take the place of an unknown -
- 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
Correct Answer
B. Keep tract of friends' names and addresses -
- 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
Correct Answer
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
Correct Answer
C. Get airline schedules for clients -
- 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
Correct Answer
A. Database -
- 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
Correct Answer
B. Perform a search using the student's name as the criteria -
- 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
Correct Answer
A. Designing a brochure for advertising purposes -
- 21.
How do you write the mathematical operator "less than"?
- A.
=/
- B.
=
- C.
>
- D.
Correct Answer
D. -
- 22.
How do you write the mathematical operator "equal to or greater than"?
- A.
=&
- B.
=>
- C.
=
- D.
=+
Correct Answer
B. => -
- 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
Correct Answer
C. Fields -
- 24.
What operator would you use for the word "exceeds"?
- A.
- B.
>
- C.
=>
- D.
=
Correct Answer
B. > -
- 25.
Which operator would you use for the words "at most"?
- A.
>
- B.
- C.
=>
- D.
=
Correct Answer
D. = -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Dec 20, 2012Quiz Edited by
ProProfs Editorial Team -
Feb 23, 2009Quiz Created by
Gthomp
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top