Computer Concepts Module 13 Exam

Computer Concepts Module 13 Exam 1.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 ANS update 2.A database backup can include information on who made what changes and when since the previous database backup ANS true 3.Melody is building a database for a restaurant. Which pair of tables is least likely to need a direct relationship with each other ANS customers, ingredients 4.What characteristic of Big Data indicates how closely that data matches reality ANS veracity 5.Which of the following is a key aspect of database security according to the CIA triad security model? Choose two ANS Availability and 1 / 2

Integrity 6.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 ANS data analyst 7.Which data repository type is most likely to include database tables and primary keys in its internal data structure ANS data warehouse 8.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 ac- cessible from the Internet. He should connect his database server the same way so data in the database is readily accessible to the web server ANS false 9.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 ANS SQL 10.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