ITE 152 Final Exam 3 Questions and Answers Already Graded A

ITE 152 Final Exam 3 Questions and Answers Already Graded A 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. 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 Graduated One disadvantage of computerized databases is that they limit your ability to arrange information. -True -False False A database is a collection of related information, but a database management system is a type of software program. -True -False True A database is an organized collection of information. -True -False True What are the columns in a Microsoft Access table called? -Rows -Fields -Records -Columns 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 Vendors What does SQL stand for? -Stated question language -Structured query language -System query lingo -Status query language Structured query language Which of the following is LEAST likely to be a field in a Customers table? -LastName -Address -EmploymentDate -PhoneNumber EmploymentDate A relationship is created between how many tables? -Two -Any number -Three -One 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 A question you ask a database A computerized database can store millions of telephone numbers. -True -False True Which data type would be best suited to a field that lists customer email addresses? -Hyperlink -AutoNumber -Date/Time -Number Hyperlink Databases typically store their data in one big table. -True -False False All the pet names in a veterinarian's database are stored in a _______ called PetName. -record -table -worksheet -field Field Malisa is designing a database for a doctor's office where receptionists, office managers, and other office staff will need to manage patient data. Which database object should Malisa create to make it easy for these non-technical users to add patient records? -Forms -Queries -Reports -Tables Forms Queries in access can be used -Both 'a' and 'b' -Only 'a' -as a source of records for forms and reports -to view, change and analyze data in different ways Both 'a' and 'b' What does a filter do? -Make more records available -Hide records from view -Slow