1.
It refers to the processed data
Explanation
The given statement suggests that the answer is "Information" because it refers to processed data. Information is the result of processing raw data, where it is organized, structured, and presented in a meaningful way. Therefore, the statement implies that the correct answer is "Information" as it aligns with the concept of processed data.
2.
A collection of related information that is organized in a table with rows and columns
Explanation
A database is a collection of related information that is organized in a table with rows and columns. It is a structured way to store and manage data, allowing for efficient retrieval, modification, and analysis of the information. The data in a database is organized into tables, with each table representing a specific entity or concept. The rows in the table represent individual instances or records, while the columns represent the attributes or characteristics of those instances. By organizing data in this way, a database provides a structured and efficient method for storing and accessing information.
3.
Its store and organize data in a database
Explanation
Microsoft Access is a database management system that allows users to store and organize data in a database. It provides a user-friendly interface and various tools for creating tables, forms, reports, and queries. Users can input, edit, and retrieve data easily using Access. It also supports the creation of relationships between tables and offers features like data validation and data encryption. Overall, Microsoft Access is a powerful tool for managing and manipulating data in a database environment.
4.
____________ ask questions.
5.
The row in the table is ____________
Explanation
The correct answer is "Record" because the question is asking for the missing word to complete the sentence "The row in the table is ________." The word "Record" fits logically in this context as it is a common term used to describe a row of data in a table or database.
6.
Microsoft Access is a
Correct Answer
C. Database Management System
Explanation
Microsoft Access is a database management system. It is a software tool that allows users to store, organize, and manipulate large amounts of data. With Microsoft Access, users can create and manage databases, design forms and reports, and write queries to extract specific information from the database. It is commonly used for small to medium-sized projects and is part of the Microsoft Office suite of applications.
7.
____________ Ensures that the relationship between a primary and related tables is maintained
Correct Answer
C. Referential Integrity
Explanation
Referential Integrity ensures that the relationship between a primary and related tables is maintained. It ensures that any foreign key value in a related table must match a primary key value in the primary table. This ensures that data integrity is maintained and prevents inconsistencies or errors in the database. Referential Integrity also ensures that if a primary key value is deleted or updated, the corresponding foreign key values in related tables are also updated or deleted to maintain the integrity of the relationship between the tables.
8.
A report header will display
Correct Answer
B. On the first page of the report
Explanation
The report header will display on the first page of the report. This means that the header will only be visible at the beginning of the report and will not appear on any subsequent pages.
9.
Which of he following is NOT a part of a database?
Correct Answer
D. Worksheets
Explanation
Worksheets are not a part of a database. A database is a collection of organized data stored and accessed electronically. It typically consists of tables, which contain records and fields. Worksheets, on the other hand, are a feature of spreadsheet software like Microsoft Excel, used for organizing and analyzing data but not typically considered a part of a database.
10.
In a database, each _________________ contains a collection of related data.
Correct Answer
A. Table
Explanation
In a database, a table contains a collection of related data. Tables are used to organize and store data in a structured manner. Each row in a table represents a record, which contains a set of related data. Therefore, the correct answer is "table".
11.
In a database, a _____________ is a unit of information about one individual or item.
Correct Answer
C. Field
Explanation
In a database, a field is a unit of information about one individual or item. It represents a specific attribute or characteristic of the individual or item being stored in the database. For example, in a database of employees, a field could represent the employee's name, age, or job title. Each field holds a specific piece of data and together, multiple fields make up a record, which contains all the information about a single individual or item. Therefore, a field is a fundamental component of a database that helps organize and categorize data efficiently.
12.
In a record, each separate piece of data, such as a last name, a first name, or an address, is called a _____________.
Correct Answer
B. Field
Explanation
In a record, each separate piece of data, such as a last name, a first name, or an address, is called a field.
13.
What does GIGO stand for?
Correct Answer
B. Garbage in, garbage out
Explanation
GIGO stands for "garbage in, garbage out." This means that if you input incorrect or low-quality data into a system, the output or results will also be incorrect or of low quality. The term is often used in the context of computer programming and data analysis to emphasize the importance of ensuring accurate and reliable input to obtain meaningful and accurate output.
14.
Which of the following is a way to sort data?
Correct Answer
D. All of the above
Explanation
All of the options mentioned - chronologically, alphabetically, and numerically - are valid ways to sort data. Chronological sorting arranges data based on the order in which it occurred, alphabetically sorting arranges data based on the alphabetical order of the letters or words, and numerical sorting arranges data based on numerical values. Therefore, all of the given options are correct ways to sort data.
15.
If you sort data in order of decreasing value such as Z-A, or 10-1, what type of sort are you using?
Correct Answer
B. Descending
Explanation
When you sort data in order of decreasing value, such as Z-A or 10-1, you are using a descending sort. In a descending sort, the values are arranged from highest to lowest, or in reverse alphabetical order. This is the opposite of an ascending sort, where the values are arranged from lowest to highest or in alphabetical order.
16.
What is a query?
Correct Answer
A. A question you ask a database
Explanation
A query is a question that you ask a database. It is a request for specific information or data from the database. By asking a query, you can retrieve, modify, or delete data from the database based on certain criteria or conditions. Queries are used to extract meaningful insights and generate reports from the database.
17.
What does SQL stand for?
Correct Answer
A. Structured query language
Explanation
SQL stands for Structured Query Language. It is a programming language used for managing and manipulating relational databases. SQL allows users to create, modify, and retrieve data from databases. It is widely used in the field of database management systems and is considered the standard language for interacting with relational databases.
18.
A database is an organized collection of information.
Correct Answer
A. True
Explanation
The statement is true because a database is indeed an organized collection of information. It is designed to store, manage, and retrieve data efficiently. Databases are commonly used in various applications and industries to store and organize large amounts of data, allowing for easy access and manipulation of information.
19.
A field's data type determines what kind of information can be stored there.
Correct Answer
A. True
Explanation
The statement is true because a field's data type defines the type of data that can be stored in that field. For example, a field with a data type of "text" can store alphanumeric characters, while a field with a data type of "number" can only store numeric values. The data type ensures that the correct format and range of data is stored in the field, preventing any incompatible or incorrect data from being entered.
20.
A computerized database can store millions of telephone numbers.
Correct Answer
A. True
Explanation
A computerized database has the capability to store and manage large amounts of data efficiently. Telephone numbers are relatively small and simple pieces of information, so a database can easily store millions of them. Therefore, it is true that a computerized database can store millions of telephone numbers.
21.
A database is a collection of related information, but a database management system is a type of software program.
Correct Answer
A. True
Explanation
A database is a collection of related information, which can be organized and stored in various formats. It can include tables, records, and fields that hold data. On the other hand, a database management system (DBMS) is a software program that allows users to create, access, and manage databases. It provides tools and functionalities to perform tasks such as data entry, retrieval, manipulation, and security. Therefore, the statement that a database management system is a type of software program is true.
22.
A query lets you speed up the prowsing process by finding information that matches specifically to your criteria.
Correct Answer
A. True
Explanation
A query is a request for information from a database or search engine. It allows you to search for specific information that matches your criteria, which helps in speeding up the browsing process. By using a query, you can filter out irrelevant results and only retrieve the information that is relevant to your search. Therefore, the statement that a query lets you speed up the browsing process by finding information that matches specifically to your criteria is true.
23.
It is a relationship that can be established when one record in a table has only one matching
record in another table.
Correct Answer
C. One-to-many Relationship
Explanation
A one-to-many relationship is a type of relationship that can be established when one record in a table can have multiple matching records in another table. In this type of relationship, the primary key of the "one" table is used as a foreign key in the "many" table to establish the connection between the two tables. This means that for every record in the "one" table, there can be multiple related records in the "many" table.
24.
It is an association between two tables in which one record in either table can relate to many
records in other table.
Correct Answer
D. Many-to-many Relationship
Explanation
A many-to-many relationship is an association between two tables where one record in either table can relate to many records in the other table. This means that multiple records in one table can be associated with multiple records in the other table. It is a common type of relationship in database design when there is a need to represent a complex relationship between entities.
25.
It is an association established between common fields in two tables.
Correct Answer
D. Relationship
Explanation
The correct answer is "Relationship". In a database, a relationship is established between two tables based on common fields. This allows for the connection and interaction between the data in these tables. Relationships can be of different types such as one-to-one, one-to-many, or many-to-many, depending on the nature of the data and the desired database structure.
26.
This is where all objects such as tables, queries, forms, reports, and other objects are displayed.
Correct Answer
D. Navigation pane
Explanation
The navigation pane is the correct answer because it is the location where all objects such as tables, queries, forms, reports, and other objects are displayed. It provides a convenient way for users to navigate and access different objects within the database. The ribbon is a toolbar that contains various commands and options for working with the objects, but it does not display the objects themselves. The databases window is not a standard term in database management systems and may not be applicable in this context. The objects pane is also not a standard term and does not accurately describe the location where objects are displayed.
27.
Angela Dane, 18, October 12, 1991 is an example of______.
Correct Answer
C. Record
Explanation
The given information "Angela Dane, 18, October 12, 1991" represents a set of data that includes a person's name, age, and date of birth. This set of data is commonly referred to as a record, which is a collection of related information. Therefore, the correct answer is "record".
28.
. First name, last name, age, and phone number are examples of________.
Correct Answer
B. Field names
Explanation
The given examples, such as first name, last name, age, and phone number, are all commonly used as field names in databases or data structures. Field names are labels or identifiers that are used to represent specific data within a record or structure. They help to organize and categorize data, making it easier to understand and retrieve information. Therefore, field names is the correct answer in this context.
29.
It is an association established between common fields in two tables.
Correct Answer
D. Relationship
Explanation
The correct answer is "Relationship". In the context of databases, a relationship refers to the association established between common fields in two tables. This association allows for the connection and interaction between the related data in the tables. Relationships are crucial in relational databases as they enable the organization and retrieval of data based on the connections between different tables.
30.
Angela Dane, 18, October 12, 1991 is an example of______.
Correct Answer
C. Record
Explanation
The given information "Angela Dane, 18, October 12, 1991" represents a set of data that includes a person's name, age, and date of birth. This set of data is commonly referred to as a "record" in database terminology. Therefore, the correct answer is "record".