1.
Which occupation would most likely use a database on the job?
Correct Answer
C. TelepHone information operators
Explanation
Telephone information operators would most likely use a database on the job because they need to access and provide accurate information to callers quickly. A database would allow them to efficiently search and retrieve information such as phone numbers, addresses, and business listings. This would enable them to provide accurate and up-to-date information to callers in a timely manner.
2.
Which of the following is not a good use for a database program?
Correct Answer
B. Completing a paper for English class
Explanation
Completing a paper for English class is not a good use for a database program because a database program is designed to store, organize, and retrieve large amounts of data efficiently. It is typically used for tasks such as managing records, organizing information, and performing complex queries. However, completing a paper for English class involves writing and formatting text, which can be easily done using word processing software like Microsoft Word or Google Docs. A database program would not be suitable or necessary for this task.
3.
A database program replaces what piece of office equipment?
Correct Answer
D. Filing cabinet
Explanation
A database program replaces the need for a filing cabinet in an office setting. With a database program, all the information can be stored digitally and organized in a structured manner, eliminating the need for physical files and cabinets. This allows for easier and more efficient access to information, as well as saving physical space in the office.
4.
In a database program, a set of related information is called a:
Correct Answer
A. Field
Explanation
A field in a database program refers to a single piece of information within a record. It represents a specific attribute or characteristic of the data being stored. For example, in a database of customer information, a field could be the customer's name, address, or phone number. Therefore, a set of related information would be referred to as a record, which is a collection of fields that together represent a complete set of data for a particular entity or item.
5.
Which of the following is not true of database programs?
Correct Answer
C. They are limited to the amount of information they can hold.
Explanation
Database programs are not limited to the amount of information they can hold. In fact, one of the main advantages of database programs is their ability to handle large amounts of data. They can store and manage vast amounts of information, making them highly scalable and suitable for use in various industries and applications.
6.
Searching a database of North Carolina counties by using the statement, “all counties with a population of greater that two million” will include:
Correct Answer
C. Counties with more than two million
Explanation
Using the statement "all counties with a population of greater than two million" will include counties with more than two million people. This means that it will include counties with populations greater than two million, but not those with exactly two million or less than two million people.
7.
If a student sorted the following in descending order, which international capital would be first?
Correct Answer
A. Moscow
Explanation
In summary, if the student sorted the international capitals in descending order, meaning from highest to lowest, the first capital on the list would be Moscow. This indicates that Moscow is considered to have the highest ranking or value among the given international capitals.
8.
All of the following are examples of electronic databases except which
one?
Correct Answer
A. Collection of country music CDs
Explanation
The correct answer is "collection of country music CDs" because it is not an electronic database. Electronic databases typically refer to organized collections of digital information that can be easily accessed and searched. In contrast, a collection of country music CDs is a physical collection of music recordings, which does not fit the definition of an electronic database.
9.
Which search of an electronic phone directory would find only the Doe
families living on Main Street in area code 919?
Correct Answer
B. Name = Doe and Address = Main
Street and Area Code = 919
Explanation
The correct answer is "Name = Doe and Address = Main Street and Area Code = 919" because this search includes all three criteria (name, address, and area code) that need to be met in order to find only the Doe families living on Main Street in area code 919.
10.
What would you do to generate a hard copy of a database of North Carolina?
Correct Answer
B. Print the file
Explanation
To generate a hard copy of a database of North Carolina, the most appropriate action would be to print the file. This would involve sending the file to a printer connected to the computer or network, which would then produce a physical copy of the database. Editing the file, retrieving the file, or saving it to a floppy disk would not result in a hard copy of the database.
11.
In what order has the field “Hours” been sorted?
Correct Answer
D. Descending
Explanation
Use the database above to answer Question.
12.
If a search was completed to determine “Year” = 1968, how many records would match?
Correct Answer
B. 3
Explanation
Use the database above to answer Question.
13.
Finding USA flights in the Year 1968 would require a:
Correct Answer
A. Compound search with AND
Explanation
Use the database above to answer Question.
14.
The following search was performed: “Country” = USSR or “Country” = USA
How many records matched?
Correct Answer
C. 7
Explanation
Use the database above to answer Question.
15.
If you wanted to rank the flights in order of most recent to oldest, you
would:
Correct Answer
C. Search “Year” descending
Explanation
Use the database above to answer Question.
16.
In a database containing information about North Carolina and its counties, how would you find the county with the most people?
Correct Answer
D. Sort the records by population in descending order
Explanation
To find the county with the most people in the database, sorting the records by population in descending order would be the most effective approach. This would arrange the counties in descending order based on their population, allowing us to easily identify the county with the highest population at the top of the list. By sorting the records in this manner, we can quickly determine which county has the most people without having to manually search through each county record or filter the population field using a specific threshold.
17.
What does searching a database mean?
Correct Answer
B. Looking for records that meet certain conditions
Explanation
Searching a database refers to the process of looking for records that fulfill specific criteria or conditions. It involves querying the database to retrieve information that matches the specified parameters. By searching a database, one can narrow down the results and find the relevant records that meet the desired conditions, allowing for efficient and targeted retrieval of data.
18.
What would be the most efficient way to locate the records for all students born before 08/29/90?
Correct Answer
C. Search
Explanation
The most efficient way to locate the records for all students born before 08/29/90 would be to perform a search. By searching for the specific criteria of students born before that date, the system can quickly filter and retrieve the relevant records, saving time and effort compared to other options like replacing, scrolling, or sorting.