Ch. 13 Quiz
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. Tables B. Forms C. Reports D. Queries
Forms
What characteristic of Big Data indicates how closely that data matches reality? A. veracity B. variety C. velocity D. volume
Veracity
During a thunderstorm, the database server for Jason's store loses power. This is an example of failed _________. A. encryption B. integrity C. availability D. confidentiality
Availability
Which of the following scenarios would most likely rely on Big Data? Choose two. A. Calculating a student's course average B. Calculating traffic delays during rush hour C. Evaluating applications for disability benefits D. Budgeting for a home renovation
B. Calculating traffic delays during rush hour C. Evaluating applications for disability benefits
Chantelle wants to change the color scheme for her company's web app, and she needs to get the logos updated. What kind of developer should she talk to? A. Back-end B. DBA C. Front-end D. Mobile
Back-end
Which of the following would most likely be the key paired with a value of "Canada" in a nonrelational customer database? A. Affiliation B. Product C. Country D. Name
Country
Which of the following is LEAST likely to be a field in a Customers table? A. LastName B. PhoneNumber C. Address D. EmploymentDate
Employment Date
(True or False) Open source DBMSs are insecure because users are allowed to see the software's code.
False
(True or False)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.
False
All the pet names in a veterinarian's database are stored in a _______ called PetName. A. record B. field C. table D. worksheet
Field
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. Query B. Sort C. Report D. Filter
Filter
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. Integrity B. Scalability C. Availability D. Confidentiality
Integrity
Carlos's small start-up company can't afford their own servers, but they need a robust database for their new web app. Which of the following is the best fit for Carlos's needs? A. Microsoft SQL Server B. Google Docs C. Amazon Aurora D. Microsoft Excel
Microsoft SQL Server
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. Proprietary B. Relational C. Open source D. DBaaS
Open source
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. SQL B. HTML C. CSS D. JavaScript
SQL (A front-end database user interface is built using web languages such as HTML, CSS, and JavaScript. SQL, however, is used to run queries in a database)
Which of the following tables in a database would NOT need to be encrypted? A. Customer_Payments B. Employee_Passwords C. Store_Locations D. Patient_Records
Store location
Which field could serve as the primary key for a list of students in your school? A. Phone number B. Full name C. Birth date D. Student ID number
Student ID number
Aimee works for a martial arts studio. Which of the following tables will give her contact information for the mother of a student who requested more information about a new class being offered? A. Classes B. Locations C. Instructors D. Students
Students
Contact information for all the people taking a class at a school are stored in a ________ called Students. A. field B. table C. worksheet D. record
Table
(True or False)Some nonrelational databases support SQL-based languages.
True
A national bank processes approximately 1,500 transactions per second. The fact that the bank's database must add this many Big Data records every second refers to its high _________. A. velocity B. variety C. value D. veracity
Velocity
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. Employees C. Inventory D. Vendors
Vendors
The volume of Big Data generated over time is typically measured in terms of ____________. A. terabytes B. kilobytes C. characters D. records
terabytes