ITE 152 Final Exam 3 / Strategies Review of Key quizzes & Correct Answers.Quiz____?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. - Answer✓✓ The table is filtered.Quiz____?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 - Answer✓✓ Graduated Quiz____?Page 1 of 34 1 / 4
One disadvantage of computerized databases is that they limit your ability to arrange information.-True -False - Answer✓✓ False Quiz____?A database is a collection of related information, but a database management system is a type of software program.-True -False - Answer✓✓ True Quiz____?A database is an organized collection of information.-True -False - Answer✓✓ True Quiz____?What are the columns in a Microsoft Access table called?-Rows -Fields -Records Page 2 of 34 2 / 4
-Columns - Answer✓✓ Fields Quiz____?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 - Answer✓✓ Vendors Quiz____?What does SQL stand for?-Stated question language -Structured query language -System query lingo -Status query language - Answer✓✓ Structured query language Quiz____?Which of the following is LEAST likely to be a field in a Customers table?-LastName Page 3 of 34 3 / 4
-Address -EmploymentDate -PhoneNumber - Answer✓✓ EmploymentDate Quiz____?A relationship is created between how many tables?-Two -Any number -Three -One - Answer✓✓ Two Quiz____?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 - Answer✓✓ A question you ask a database Quiz____?A computerized database can store millions of telephone numbers.Page 4 of 34
- / 4