Y12Revision9.2-2Quiz

A website sells fresh flowers. After a purchase is made, information about the purchase is entered into a database and distributed to a delivery driver via email. Which combination of information processes is carried out immediately after a purchase is made?

• Storing and displaying

• Storing and transmitting

• Collecting and displaying

• Collecting and transmitting

In a free text search, the symbols ? and * are used to replace characters in a word. Using the search query ?O*, which word could be found?

• NETWORK

• OPTICAL

• RADIO

• TOPICS

A student is converting a movie flat-file database to a relational database. The following diagram shows two possible tables in the database. What is a main purpose of the DirectorID key in the Movie table?

• To link the Movie and Director tables

• To provide another unique key for searching

• To allow local and foreign movies to be stored

• To create a unique identifier for the Movie table

A student is converting a movie flat-file database to a relational database. The following diagram shows two possible tables in the database. Which of the following describes the relationship between the Movie table and the Director table?

• One to one

• One to many

• Many to one

• Many to many

The contents of four text fields are 34, 17, 6 and 20. Which of the following shows the output after an ascending text sort is performed?

• 6, 17, 20, 34

• 17, 20, 34, 6

• 17, 6, 34, 20

• 34, 20, 17, 6

What is data redundancy in a database? Include an example in your answer.

A database is to be developed to manage a graduation dinner. Students will be able to invite guests to the dinner. The data dictionary for the booking table is shown. Some information about the fields is missing. Copy the table below into your writing booklet. In your table, recommend an appropriate data type and field size for Phone_Number and Deposit_Paid, and justify each choice of data type.

If there are 200 records, show how the size of the booking table (in megabytes) can be calculated.

Write a SQL statement to list the names in alphabetical order (A–Z) by Last_Name of the students who have more than one guest. Use the following keywords in your answer: SELECT, FROM, WHERE.

A webpage displays the following information. Each underlined word is a link to another webpage. Which method of data organisation is being used?

• HTML

• Hypertext

• Storyboard

• Data schema