Study Guide for ITE 152 Exam 3 Updated Questions and Answers 100% 2024

Study Guide for ITE 152 Exam 3 Updated Questions and Answers 100% 2024 Which field could serve as the primary key for a list of students in your school? - CORRECT ANSWER-Student ID number A field's data type determines what kind of information can be stored there. - 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 All the pet names in a veterinarian's database are stored in a _______ called PetName. - CORRECT ANSWER-Field Which of the following is a way to sort data? - CORRECT ANSWER-All of the above (Alphabetically, Numerically, Chronologically) What does SQL stand for? - CORRECT ANSWER-Structured Query Language What is a query? - CORRECT ANSWER-A question you ask a database What are the columns in a Microsoft Access table called? - CORRECT ANSWER-Fields In a record, each separate piece of data, such as a last name, a first name, or an address, is called a _____________. - CORRECT ANSWER-Field Which data type would be best suited to a field that lists a product's clearance price? - CORRECT ANSWER-Currency A query lets you speed up the browsing process by finding information that matches specifically to your criteria. - CORRECT ANSWER-True What are the different views to display a table? - CORRECT ANSWER-All of the above (Pivot Table & Pivot Chart View, Datasheet View, Design View) Databases typically store their data in one big table. - CORRECT ANSWER-False 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? - CORRECT ANSWERSmallest to largest In a database, each _________________ contains a collection of related data. - CORRECT ANSWER-Table (?) A database is an organized collection of information. - CORRECT ANSWER-True 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 Xavier is designing a Students table that will continue to track students even after they have completed their programs. Which of the following fields would work best with the Yes/No data type? - CORRECT ANSWER-Graduated 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. One disadvantage of computerized databases is that they limit your ability to arrange information. - CORRECT ANSWER-False Queries in access can be used - CORRECT ANSWER-Both 'a' and 'b' (as a source of records for forms and reports, to view, change and analyze data in different ways) A relationship is created between how many tables? - CORRECT ANSWER-Two What does a filter do? - CORRECT ANSWER-Hide records from view A computerized database can store millions of telephone numbers. - CORRECT ANSWER-True Which of the following is NOT a part of a data