Databases

Question 1

• Question: Dana is creating a table that will show books for sale on a bookstore’s website. Which field in the table would best serve as its primary key?

• Correct Answer: ProductID

• Explanation: A primary key uniquely identifies each record in a table. A ProductID is the best choice for a primary key because it ensures each product can be uniquely identified.

Question 2

• Question: Which data type would be best suited to a field that lists a product’s clearance price?

• Correct Answer: Currency

• Explanation: The Currency data type is best for fields dealing with monetary values as it ensures proper formatting and precision for financial calculations.

Question 3

• Question: What is a query?

• Correct Answer: A question you ask a database

• Explanation: A query is a request for data or information from a database, formatted to retrieve specific results based on criteria.

Question 4

• Question: A database is a collection of related information, but a database management system is a type of software program.

• Correct Answer: True

• Explanation: A database management system (DBMS) is software that interacts with end users, applications, and the database itself to capture and analyze data.

Question 5

• Question: In a database, each _________________ contains a collection of related data.

• Correct Answer: Table

• Explanation: In a database, a table contains a collection of related data organized in rows and columns.

Question 6

• Question: What are the different views to display a table?

• Correct Answer: Datasheet View, Design View, Pivot Table & Pivot Chart View

• Explanation: Tables can be viewed in different ways, such as Datasheet View for entering and editing data, Design View for defining structure, and Pivot views for data analysis.

Question 7

• Question: A relationship is created between how many tables?

• Correct Answer: Two

• Explanation: A relationship in a database typically connects two tables through a common field to establish associations between their data.

Question 8

• Question: In a record, each separate piece of data, such as a last name, a first name, or an address, is called a _____________.

• Correct Answer: Field

• Explanation: A field is a specific piece of data or attribute in a record, such as a name or address.

Question 9

• Question: One disadvantage of computerized databases is that they limit your ability to arrange information.

• Correct Answer: False

• Explanation: Computerized databases offer extensive capabilities to sort, arrange, and filter data, providing flexibility in data management.

Question 10

• Question: Malisa is designing a database for a doctor’s office where receptionists, office managers, and other office staff will need to manage patient data. Which database object should Malisa create to make it easy for these non-technical users to add patient records?

• Correct Answer: Forms

• Explanation: Forms allow non-technical users to easily add, edit, or view records in a user-friendly interface.

Question 11

• Question: A database is an organized collection of information.

• Correct Answer: True

• Explanation: A database is an organized collection of data that can be accessed, managed, and updated.

Question 12

• Question: Sawyer is looking at a table of students in his class, but it seems like the list is way too short. What is the most likely problem?

• Correct Answer: The table is filtered.

• Explanation: A filter restricts the data displayed based on specific criteria, making it seem like data is missing.

Question 13

• Question: Which data type would be best suited to a field that lists customer email addresses?

• Correct Answer: Hyperlink

• Explanation: The Hyperlink data type is suitable for storing email addresses because it allows for clickable links.

Question 14

• Question: What are the columns in a Microsoft Access table called?

• Correct Answer: Fields

• Explanation: In Microsoft Access, columns in a table are referred to as fields, representing individual pieces of data.

Question 15

• Question: A computerized database can store millions of telephone numbers.

• Correct Answer: True

• Explanation: Computerized databases are capable of storing large volumes of data efficiently.

Question 16

• Question: Xavier is designing a Students table that will continue to track students even after they have completed their programs. Which of the following fields would work best with the Yes/No data type?

• Correct Answer: Graduated

• Explanation: A Yes/No data type is ideal for fields that store binary information, such as whether a student has graduated.

Question 17

• Question: Ibraheem works for a music store. Which of the following tables will give him the company contact information he needs to place a custom order for a guitar?

• Correct Answer: Vendors

• Explanation: A Vendors table typically contains information about suppliers, including their contact details.

Question 18

• Question: Which of the following is NOT a part of a database?

• Correct Answer: Worksheets

• Explanation: Unlike records, tables, and fields, worksheets are not a native part of a database.

Question 19

• Question: A field's data type determines what kind of information can be stored there.

• Correct Answer: True

• Explanation: A field's data type specifies the kind of information it can store, such as numbers, text, or dates.

Question 20

• Question: Which of the following is a way to sort data?

• Correct Answer: All of the above

• Explanation: Sorting data can be done in various ways, including alphabetically, numerically, or chronologically.

Question 21

• Question: Contact information for all the people taking a class at a school are stored in a ________ called Students.

• Correct Answer: Table

• Explanation: In a database, contact information for a group of people is typically organized in a table.

Question 22

• Question: Databases typically store their data in one big table.

• Correct Answer: False

• Explanation: Databases typically organize data across multiple related tables rather than in one large table.

Question 23

• Question: Which of the following is LEAST likely to be a field in a Customers table?

• Correct Answer: EmploymentDate

• Explanation: EmploymentDate is less likely to be a field in a Customers table compared to Address, LastName, or PhoneNumber.

Question 24

• Question: What does a filter do?

• Correct Answer: Hide records from view

• Explanation: A filter temporarily excludes records from view based on specified criteria.

Question 25

• Question: Kian needs to sort a list of patients by birthdate to show the oldest patients first. What sort order on the birthdate field will give him this result?

• Correct Answer: Largest to smallest

• Explanation: Sorting a birthdate field from largest to smallest will display the oldest records first.

Question 26

• Question: What does SQL stand for?

• Correct Answer: Structured query language

• Explanation: SQL, or Structured Query Language, is used to manage and manipulate relational databases.

Question 27

• Question: A query lets you speed up the browsing process by finding information that matches specifically to your criteria.

• Correct Answer: True

• Explanation: Queries are used to quickly find and retrieve specific data based on defined criteria.

Question 28

• Question: All the pet names in a veterinarian’s database are stored in a _______ called PetName.

• Correct Answer: Field

• Explanation: A field in a database is used to store a specific type of information, such as pet names.

Question 29

• Question: Queries in Access can be used

• Correct Answer: All of the options are correct

• Explanation: Queries can serve multiple purposes, including data analysis and serving as a record source for forms and reports.

Question 30

• Question: Which field could serve as the primary key for a list of students in your school?

• Correct Answer: Student ID number

• Explanation: A Student ID number is a unique identifier, making it the best choice for a primary key.