Database Terminology · CSEC Information Technology

22 past-paper questions on Database Terminology, part of Database Management, from every CSEC Information Technology paper on Quelpr.

1. 8(a)1 mark· CSEC Information Technology · 2011 · Paper 2What field in the COURSE table is used to sort the records?
2. 8(b)1 mark· CSEC Information Technology · 2011 · Paper 2State the primary key in the COURSE table.
3. 8(a)2 marks· CSEC Information Technology · 2015 · Paper 2Name TWO data types other than the TEXT data type used in the stock table.
4. 8(b)2 marks· CSEC Information Technology · 2015 · Paper 2State the field MOST appropriate for use as the primary key and indicate the reason for your choice.
5. 3(b)(i)1 mark· CSEC Information Technology · 2022 · Paper 2State the feature that is used to establish and maintain the accuracy of data between the two database tables.
6. 3(b)(ii)1 mark· CSEC Information Technology · 2022 · Paper 2State why it is necessary to maintain the accuracy of data between the two database tables.
7. 3(b)(iii)2 marks· CSEC Information Technology · 2022 · Paper 2Outline how the one-to-many relationship is formed between the two database tables.
8. 7(a)3 marks· CSEC Information Technology · January 2013 · Paper 2State an appropriate data type for EACH of the fields: Name, DOB and Phone.
9. 7(b)1 mark· CSEC Information Technology · January 2013 · Paper 2State the MOST appropriate field that should be a primary key.
10. 8(a)1 mark· CSEC Information Technology · January 2014 · Paper 2State the name of the table used to store data in the database.
11. 8(b)1 mark· CSEC Information Technology · January 2014 · Paper 2Which field in the table can be used as the primary key?
12. 8(b)1 mark· CSEC Information Technology · May/June 2013 · Paper 2State a field name from the list you have provided in (a) above that can be used as a primary key.
13. Q411 mark · multiple choice· CSEC Information Technology · May/June 2017 · Paper 1Which of the following characteristics must two database tables have in order for them to be linked?
14. Q361 mark · multiple choice· CSEC Information Technology · May/June 2018 · Paper 1Which of the following is NOT a valid data type in Microsoft Access?
15. Q411 mark · multiple choice· CSEC Information Technology · May/June 2019 · Paper 1Which of the following characteristics must two database tables have in order for them to be linked?
16. Q441 mark · multiple choice· CSEC Information Technology · May/June 2019 · Paper 1Which of the following CANNOT be specified as a data type in a database table?
17. 7(a)2 marks· CSEC Information Technology · May/June 2019 · Paper 2Identify the field that could be used as a primary key, and state ONE reason why it may NOT be a suitable primary key.
18. 7(b)(ii)1 mark· CSEC Information Technology · May/June 2019 · Paper 2Identify the field name from the Instructor table that would be MOST suitable as a primary key.
19. 12(a)(i)1 mark· CSEC Information Technology · May/June 2019 · Paper 2State the reference for the student who has to make three payments.
20. 12(a)(ii)1 mark· CSEC Information Technology · May/June 2019 · Paper 2State the number of payments for the student with reference 56.
21. 12(a)(iii)1 mark· CSEC Information Technology · May/June 2019 · Paper 2State the maximum number of students whose information can be stored in the array.
22. 12(a)(iv)2 marks· CSEC Information Technology · May/June 2019 · Paper 2State the meaning of '...' as shown in the array.