EXPLORED ITE EXAM REVISION QUESTIONS AND ANSWERS

EXPLORED ITE EXAM REVISION QUESTIONS AND ANSWERS A computerized database can store millions of telephone numbers. true or false - CORRECT ANSWER -true A database is an organized collection of information. true or false - CORRECT ANSWER -true 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. Which of the following is LEAST likely to be a field in a Customers table? Address LastName EmploymentDate PhoneNumber - CORRECT ANSWER -EmploymentDate Queries in access can be used as a source of records for forms and reports to view, change and analyze data in different ways Both 'a' and 'b' Only 'a' - CORRECT ANSWER -Both 'a' and 'b' 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? Z to A Smallest to largest A to Z Largest to smallest - CORRECT ANSWER -Smallest to largest Which data type would be best suited to a field that lists customer email addresses? Number Date/Time Hyperlink AutoNumber - CORRECT ANSWER -Hyperlink A field's data type determines what kind of information can be stored there. true or false - CORRECT ANSWER -true What are the different views to display a table? Pivot Table & Pivot Chart View All of the above Datasheet View Design View - CORRECT ANSWER -All of the above What does SQL stand for?