Final Exam for ITE 152 Study Guide Q&A 2024

Final Exam for ITE 152 Study Guide Q&A 2024 Which field could serve as the primary key for a list of students in your school? - CORRECT ANSWER-Student ID number Databases typically store their data in one big table. - CORRECT ANSWER-False What is a query? - CORRECT ANSWER-A question you ask a database One disadvantage of computerized databases is that they limit your ability to arrange information. - CORRECT ANSWER-False What does a filter do? - CORRECT ANSWER-Hide records from view A database is an organized collection of information. - CORRECT ANSWER-True A query lets you speed up the browsing process by finding information that matches specifically to your criteria. - CORRECT ANSWER-True 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? - CORRECT ANSWER-ProductID Sawyer is looking at a table of students in his class, but it seems like the list is way too short. What is the most likely problem? - CORRECT ANSWER-The table is filtered. What does SQL stand for? - CORRECT ANSWER-Structured query language Contact information for all the people taking a class at a school are stored in a ________ called Students. - CORRECT ANSWER-table A relationship is created between how many tables? - CORRECT ANSWER-Two A field's data type determines what kind of information can be stored there. - CORRECT ANSWER-True Which of the following is a way to sort data? - CORRECT ANSWER-All of the above What are the different views to display a table? - CORRECT ANSWER-All of the above Which data type would be best suited to a field that lists customer email addresses? - CORRECT ANSWER-Hyperlink 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? - CORRECT ANSWER-Vendors Which of the following is NOT a part of a database? - CORRECT ANSWER-Worksheets What are the columns in a Microsoft Access table called? - CORRECT ANSWER-Fields All the pet names in a veterinarian's database are stored in a _______ called PetName. - CORRECT ANSWER-field A computerized database can store millions of telephone numbers. - CORRECT ANSWER-True In a database, each _________________ contains a