ICT - 10 Quick Revision

What you need to do to arrange in order the contents of the database?

• Field

• Descending

• Filter

• Sort

Which of the following statements is correct,

A. Data can be duplicated by using only one table to store data.

B. Data must be in the field that belongs to the primary key in a table.

C. Re-entry of data in each field in a table is called as data duplication

• A and B

• A and C

• B and C

• A , B and C

Which of the following should be used to change the layout of form in a database?

• Design view

• Layout View

• Form Wizard

• Query view

What is the relationship between the item table and the customer table according to the following figure?

• One-to-one Relationship

• Many-to-many Relationship

• One-to-many Relationship

• None of the above.

The result that can be obtained by using the query below

• Displays customer names that purchased more than 2 books

• Displays customer names that purchased more than 2 books and the purchased

  quantity

• Displays the type of item that purchased more than 2 books and the purchased

  quantity

• Displays customer names that purchased more than 2 books, the type of item and quantity purchased.

Which answer shows the appropriate data type for the fields shown in the table below?

• Number, Boolean, Currency, Number

• Text, Boolean, Currency, Number

• Text, Number, Currency, Number

• Number, Boolean, Currency, text

In a database if the primary key in one table is used as a field in another table ,which

name is used to call it in that table,

• Foreign key

• Composite Primary Key

• Record

• index

A …….X…….. is the unit information of a ……..Y……... The most appropriate words for X and Y is,

• Database/ Table

• Primary key/ foreign key

• Field/ record

• Field/ page

Which of the following statements is incorrect?

• When inserting new records into tables, the data must first be entered into the table where the foreign key is located.

• A foreign key is always associated with the primary key in another table.

• A foreign key is required to build a connection between tables.

• Database table may have several foreign keys.

Consider the following table regarding the borrowing books for students from the school

library.

According to the data in the table above,

• All data in the table are duplicated.

• All member details and book names are duplicated.

• Members' details and borrowing dates of books are duplicated.

• All member details are duplicated.