Grade 10 Computer Science — Tables, records and fields

1.A table holds one row for each of forty pupils, and every row has six columns. How many records does the table hold?

2.A roll number that is meant to be a table's primary key is typed in twice by mistake, so two different records now hold 41. What can no longer be done?

• a) No further records can be added to the table
• b) One record can no longer be picked out by giving its roll number alone
• c) The table can no longer be sorted by any of its fields
• d) The other records lose their roll numbers

3.A table has eight fields and fifty records. A ninth field is then added, and three records are deleted. How many records does the table hold now?

4.A table holds ninety-six single pieces of information altogether, and it has eight fields. How many records does it have?

5.A table has five fields and a hundred and twenty records. How many single pieces of information does it hold altogether?

6.Put these tables in order of how many single pieces of information each one holds, fewest first.

• 4 records of 3 fields
• 10 records of 3 fields
• 2 records of 12 fields
• 5 records of 4 fields

7.A table of six fields and thirty records is shown on screen with a heading row above it naming the fields. How many rows are on the screen altogether?

8.A table of two hundred records has a field called roll number, and that field is the table's primary key. At most how many records can hold the roll number 57?