ITE 152 Final Exam 3 Questions and Answers 2024 Verified

ITE 152 Final Exam 3 Questions and Answers 2024 Verified 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? -The table is missing a primary key. -The table is sorted. -The table is filtered. -The table has been deleted. - CORRECT ANSWER-The table is filtered. 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? -Employer -Graduated -GPA -Major - CORRECT ANSWER-Graduated One disadvantage of computerized databases is that they limit your ability to arrange information. -True -False - CORRECT ANSWER-False A database is a collection of related information, but a database management system is a type of software program. -True -False - CORRECT ANSWER-True A database is an organized collection of information. -True -False - CORRECT ANSWER-True What are the columns in a Microsoft Access table called? -Rows -Fields -Records -Columns - CORRECT ANSWER-Fields 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? -Inventory -Employees -Customers -Vendors - CORRECT ANSWER-Vendors What does SQL stand for? -Stated question language -Structured query language -System query lingo -Status query language - CORRECT ANSWER-Structured query language Which of the following is LEAST likely to be a field in a Customers table? -LastName -Address -EmploymentDate -PhoneNumber - CORRECT ANSWER-EmploymentDate A relationship is created between how many tables? -Two -Any number -Three -One - CORRECT ANSWER-Two What is a query? -A question you ask a table -A question you ask a record -A question you ask a database -A question you ask a field - CORRECT ANSWER-A question you ask a database A computerized database can store millions of telephone numbers. -True -False - CORRECT ANSWER-True Which data type would be best suited to a field that lists customer email addresses? -Hyperlink -AutoNumber -Date/Time -Number - CORRECT ANSWER-Hyperlink Databases typically store their data in one big table. -True -False - CORRECT ANSWER-False All the pet names in a veterinarian's database are stored in a _______ called PetName. -record -table -worksheet -field - CORRECT ANSWER-Fiel