Ch. 13 Quiz

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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


Ensembles d'études connexes

Geometry - QUIZ 3: SLOPE AND LINES

View Set

Sherpath Lesson - Nursing Management: Infection

View Set

Math Lesson 60 Equations With Fractions

View Set

EXAM #2: Chapter 5.1 Stoichiometry

View Set

High-Risk Antepartum Nursing Care

View Set

Treble Clef, Bass Clef, Whole, Half, Quarter

View Set