Module13 Computer Concepts Exam Questions And Solved Solutions.

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? - Answer filter 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? - Answer FROM Students Melody is building a database for a restaurant. Which pair of tables is least likely to need a direct relationship with each other? - Answer Customers, Ingredients 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? - Answer SQL Which of the following scenarios would most likely rely on Big Data? Choose two. - Answer Evaluating applications for disability benefits and Calculating traffic delays during rush hour 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? - Answer smallest to largest 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? - Answer ProductID 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? - Answer UPDATE Students who complete an online test are not allowed to change their test grades. What aspect of the CIA triad is at work here? - Answer integrity