Question 1

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?
A) The table is sorted.
B) The table is missing a primary key.
C) The table has been deleted.
D) The table is filtered.

Accepted Answer

If the table is appearing to be too short, it is possible that there is a filter applied which is hiding certain records.

Question 2

Which of the following job roles would most likely need permission to delete records in a Customers table?
A) Accountant
B) Customer service representative
C) Receptionist
D) Database administrator

Accepted Answer

The Database administrator role is responsible for managing and maintaining the database, including ensuring data accuracy and security. This role may need to delete records in the Customers table if they are no longer needed or if they contain incorrect information. The other job roles listed, such as Accountant, Customer service representative, and Receptionist, do not typically have a need to delete records from a Customers table.

Question 3

Which of the following requests to Alexa is most likely to get the desired result?
A) Play Journey.
B) Alexa, play Journey songs on Pandora.
C) Alexa, play Pandora music and include a lot of Journey songs.
D) Alexa, I like the Journey albums. Play some of those and make sure you use Pandora.

Accepted Answer

This request specifically tells Alexa to play Journey songs on Pandora, increasing the likelihood of getting the desired result.

Question 4

Which data type would be best suited to a field that lists a product's clearance price?
A) AutoNumber
B) Date/Time
C) Currency
D) Number

Accepted Answer

Currency data type is best suited for a field that lists a product's clearance price as it allows for precise calculations of monetary values and automatically formats the values with currency symbols and decimal points.

Question 5

Which of the following is LEAST likely to be a field in a Customers table?
A) EmploymentDate
B) PhoneNumber
C) LastName
D) Address

Accepted Answer

EmploymentDate is unlikely to be a field in a Customers table since it is a characteristic of an employee, not a customer. The other choices (PhoneNumber, LastName, and Address) are common fields to include in a Customers table.

Question 6

Which field could serve as the primary key for a list of students in your school?
A) Phone number
B) Full name
C) Student ID number
D) Birth date

Accepted Answer

The best choice for a primary key for a list of students in your school would be the student ID number. This is a unique identifier assigned to each student by the school, and ensures that there are no duplicates in the list. Phone numbers and birth dates are not unique and can change over time, while full names may not be unique if there are students with the same name in the school.

Question 7

All the pet names in a veterinarian's database are stored in a _______ called PetName.
A) table
B) record
C) field
D) worksheet

Accepted Answer

In a database, a field is a single piece of information; in this context, PetName would be a field that stores the names of pets.

Question 8

Rafael needs to run a query that will show the name and city of all his clients. Which of the following phrases will determine which fields are returned in the query?
A) FROM Name, City
B) SELECT Name, City
C) VALUES Name, City
D) WHERE Name, City

Accepted Answer

The SELECT statement determines which fields are returned in the query. In this case, Rafael wants to show the name and city of his clients, so the correct statement is SELECT Name, City.

Question 9

Which of these tasks is a non-technical user most likely to have the right to perform in a database?
A) Delete a record.
B) Add new data.
C) Name a field in a table.
D) Create a relationship between two tables.

Accepted Answer

Adding new data is a fairly simple task that does not require technical skills. Deleting a record, naming a field, and creating a relationship between tables all involve more advanced technical knowledge of database management.

Question 10

Which of these file types is optimized for processing calculations of numbers in a budget?
A) Database
B) Presentation
C) Document
D) Spreadsheet

Accepted Answer

A spreadsheet is optimized for processing calculations of numbers in a budget. Spreadsheets allow for easy organization and manipulation of numerical data, making them ideal for budgeting and financial analysis. Other file types, such as databases or documents, may also be useful in certain aspects of budgeting, but a spreadsheet is specifically designed for complex calculations and data analysis.

Question 11

Kim is writing a SQL query that will pull a list of customers with outstanding orders and the sales rep for each order. What should the WHERE phrase say in her query?
A) WHERE Customer = SalesRep
B) WHERE OrderStatus = Pending
C) WHERE CustomerStatus = Active
D) WHERE SalesRep = Kim

Accepted Answer

The WHERE phrase should filter the results for outstanding orders, therefore searching for orders with a status of "Pending" would be most appropriate. None of the other options mentioned would help in filtering for outstanding orders.

Question 12

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?
A) Major
B) Employer
C) Graduated
D) GPA

Accepted Answer

The Graduated field would work best with the Yes/No data type as it is a binary field with only two possible values - Yes (indicating that the student has graduated) or No (indicating that the student has not yet graduated or has dropped out). The other fields (Major, Employer, and GPA) would require other data types such as text or numeric.

Question 13

How can you get the attention of a personal assistant app on your phone?
A) Pause briefly before stating the command.
B) Complete the voice training process.
C) Say the wake word.
D) Reduce background noise.

Accepted Answer

To get the attention of a personal assistant app on your phone, you need to say the wake word. The most common wake words are "Hey Siri," "Okay Google," and "Alexa."

Question 14

Rhea receives a text informing her that her credit card might have been compromised. The text asks her to confirm whether she made a purchase 15 minutes ago at a store that is over 2,000 miles away from her current location and that carries products she has never bought before. What technology was used to compare the purchase to Rhea's normal shopping habits and identify it as credit card fraud?
A) Data analytics
B) Chatbot
C) Robotic process automation
D) Natural language processing (NLP)

Accepted Answer

Data analytics would analyze Rhea's normal shopping habits and detect any unusual purchases.

Question 15

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?
A) Forms
B) Queries
C) Tables
D) Reports

Accepted Answer

Forms allow non-technical users to easily input and manage data without having to directly interact with the underlying tables. Queries are used to search, filter, and analyze data, but they do not provide a user-friendly interface for data entry. Tables contain the actual data but may be difficult for non-technical users to input data directly. Reports are used to present data in a formatted and organized manner, but they do not provide data entry functionality.

Question 16

Which of the following is NOT a risk to a company or its employees as a result of a data breach?
A) Loss of trust with customers
B) Increased database efficiency
C) Negative media exposure
D) Jailtime

Accepted Answer

Increased database efficiency is not a risk but a potential benefit that could come from a data breach if the breach exposes vulnerabilities or inefficiencies in the database system that can be corrected. The other options all represent potential negative consequences of a breach.

Question 17

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?
A) Customers
B) Inventory
C) Vendors
D) Employees

Accepted Answer

Vendors are the suppliers and manufacturers of the products that the store carries. The vendor table would contain contact information for companies the store uses to purchase new instruments or restock inventory.

Question 18

Open source DBMSs are insecure because users are allowed to see the software's code.

Accepted Answer

Open source DBMSs can actually be more secure because users are allowed to review and contribute to the code, identifying and fixing vulnerabilities. The transparency of the code allows for a community of developers to work together to enhance security measures.

Question 19

Which of the following is NOT an RDBMS?
A) MySQL
B) PostgreSQL
C) Microsoft SQL Server
D) Oracle NoSQL Database

Accepted Answer

MySQL, PostgreSQL, and Microsoft SQL Server are all examples of relational database management systems (RDBMS). Oracle NoSQL Database, on the other hand, is not an RDBMS but rather a NoSQL database system, which uses a different data model than RDBMSs.

Question 20

Many chatbot services provide support to employees and management rather than to customers.

Accepted Answer

Many chatbot services are used to provide support to employees and management by handling tasks such as scheduling, HR inquiries, and IT support. This helps to free up time and resources for human employees to focus on more complex tasks.

Quiz 7: Technology and IT: From CAM to IoT and Digital Citizenship

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?

Which of the following job roles would most likely need permission to delete records in a Customers table?

Which of the following requests to Alexa is most likely to get the desired result?

Which data type would be best suited to a field that lists a product's clearance price?

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

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

All the pet names in a veterinarian's database are stored in a _______ called PetName.

Rafael needs to run a query that will show the name and city of all his clients. Which of the following phrases will determine which fields are returned in the query?

Which of these tasks is a non-technical user most likely to have the right to perform in a database?

Which of these file types is optimized for processing calculations of numbers in a budget?

Kim is writing a SQL query that will pull a list of customers with outstanding orders and the sales rep for each order. What should the WHERE phrase say in her query?

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?

How can you get the attention of a personal assistant app on your phone?

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?

Which of the following is NOT a risk to a company or its employees as a result of a data breach?

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?

Open source DBMSs are insecure because users are allowed to see the software's code.

Which of the following is NOT an RDBMS?

Many chatbot services provide support to employees and management rather than to customers.