Y12IPT9.2-1RevisionQuiz

Which statement describes how a search robot works on a search engine?

• Keeps a list of URLs for web pages containing keywords

• Sends appropriate URLs back to the indexing database

• Provides a directory structure for the user

• Conducts keyword searches

A local council wants to find out from its residents the issues that are most important to them. An online survey is to be designed to collect data. Each resident will be presented with a list of issues and they can select three issues from the list relevant to them. Which of the following screen elements should be used to capture the response?

• Diagram A

• Diagram B

• Diagram C

• Diagram D

A librarian wants to use SQL to generate a list of people who borrowed books in January 2023, including the book title and author. Which combination of SELECT and WHERE statements will achieve this?

• SELECT Name, Title, Author WHERE Date_Borrowed >= 1/1/2023 AND Date_Borrowed <= 31/1/2023

• SELECT Name, Date_Borrowed, Title, Author WHERE Date_Borrowed <= 1/1/2023 AND Date_Borrowed >= 31/1/2023

• SELECT Name, Title, Author WHERE Date_Borrowed < 1/1/2023 AND Date_Borrowed > 31/1/2023

• SELECT Name, Date_Borrowed, Title, Author WHERE Date_Borrowed > 1/1/2023 AND Date_Borrowed < 31/1/2023

Copy the following table into your writing booklet. In your table, recommend an appropriate field size and data type for SenderPhone and MessageRead. Justify each choice of data type.

The flat-file database is to be converted into a relational database. In addition to the phone number, more information such as name and email address will be stored for each user. Draw a schematic diagram to show how the database can be normalized. Clearly label the names of the tables, primary and foreign keys, and any relationships.

The messaging system will be further enhanced to allow users to send images and attach files. Describe ethical and technical issues that may result from this further enhancement.

Explain how the data stored in the data warehouse can be used by both the technology company and their customers.

Which of the following best represents the relationship between a system and external entities?

• Storyboards

• Decision tree

• Context diagram

• Data flow diagram

Which of the following specifies field names, field sizes and descriptions?

• Data dictionary

• Structured query

• Journals and diaries

• Scheduling of tasks

Which of the following is an example of a user within an information system?

• Managers collecting customer details for a membership database

• Students downloading their class timetable from the school database

• Researchers checking the validation of data for entry into a scientific database

• Gallery owners recording the relationship between an artist and their artwork in a database