Deck 13: Databases

Question 1

Which of the following fields would be most important to encrypt in a customer table?

A)Customer's city
B)Customer's sales representative
C)Customer's status
D)Customer's credit card number

Answer 1

Customer's credit card number

Question 2

Kiera is building a front-end user interface for the database her new website will use. Which of the following languages is NOT used to build a webpage?

A)HTML
B)JavaScript
C)SQL
D)CSS

Answer 2

SQL

Question 3

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

A)AutoNumber
B)Date/Time
C)Number
D)Hyperlink

Answer 3

Hyperlink

Question 4

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?

A)A to Z
B)Smallest to largest
C)Z to A
D)Largest to smallest

Question 5

Jenson needs to update his home address in his health insurance company's database. Which of the following applications can he open on his computer so he can make these changes?

A)A browser
B)A spreadsheet application
C)An RDBMS
D)A DBMS

Question 6

One of Eden's customers has closed his account and moved to a different state. She needs to change his status to Inactive. What SQL command will accomplish this task?

A)DELETE
B)INSERT
C)SELECT
D)UPDATE

Question 7

Darcie has hired a programmer to make some custom changes to a DBMS she plans to move her business database to. What kind of DBMS is she using?

A)Relational
B)Proprietary
C)DBaaS
D)Open source

Question 8

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

A)field
B)record
C)worksheet
D)table

Question 9

What kind of database is needed to hold and organize diverse data types, such as X-ray images and doctors' notes, in a medical database?

A)Relational database
B)Big Data database
C)Backup database
D)Nonrelational database

Question 10

Scarlet needs to create a file to hold a list of expenses for an upcoming project, and she needs to do some basic calculations with the numbers in the budget. Which kind of file is the best fit for this purpose?

A)Spreadsheet
B)Presentation
C)Database
D)Document

Question 11

What characteristic of Big Data indicates how closely that data matches reality?

A)velocity
B)veracity
C)volume
D)variety

Question 12

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?

A)Author
B)PageCount
C)Title
D)ProductID

Question 13

Mindy needs to run a SQL query that will pull the names and birthdates of all her students. What should the FROM phrase say in her query?

A)FROM Students
B)FROM Birthdate
C)FROM Name
D)FROM Schools

Question 14

Raphael is working with a table in Access. He needs to see all the records for customers in Chattanooga so he can check the zip codes in that city. Which database tool will show only these records in the table?

A)Filter
B)Query
C)Sort
D)Report

Question 15

What programming language supports relational databases?

A)HTML
B)NoSQL
C)SQL
D)CSS

Question 16

Aron is building a website that will require a back-end database. He plans to connect the web server on his network in a way that it will be easily accessible from the Internet. He should connect his database server the same way so data in the database is readily accessible to the web server.

Question 17

Casey is looking for a free, open-source RDBMS for his company. Which of the following best meets these requirements?

A)Microsoft SQL Server
B)PostgreSQL
C)MongoDB
D)Oracle Database

Question 18

Melody is building a database for a restaurant. Which pair of tables is least likely to need a direct relationship with each other?

A)Customers, Orders
B)Customers, Ingredients
C)Products, Orders
D)Products, Ingredients

Question 19

Students who complete an online test are not allowed to change their test grades. What aspect of the CIA triad is at work here?

A)Availability
B)Integrity
C)Scalability
D)Confidentiality

Question 20

A database backup can include information on who made what changes and when since the previous database backup.

Question 21

Morgan needs to hire someone to help implement a business intelligence system for her company. What type of professional would be the best fit for this job?

A)Database administrator
B)CEO
C)Data analyst
D)Retailer

Question 22

Which of the following would most likely be the key paired with a value of "Canada" in a nonrelational customer database?

A)Name
B)Product
C)Affiliation
D)Country

Question 23

Which data repository type is most likely to include database tables and primary keys in its internal data structure?

A)Data lake
B)Data dashboard
C)Data warehouse
D)Data mart