<=Back
Viewed: 419 times
Share in:
<=CDACC ICT Technician Level 5 : Manage Database System past paper July 2023
Database design is a crucial step in building a robust and efficient database system. Explain THREE types of database design:
(i) Conceptual design (3 Marks)
(ii) Logical design (3 Marks)
(iii) Physical design (3 Marks)
(i) Conceptual design (3 Marks)
(ii) Logical design (3 Marks)
(iii) Physical design (3 Marks)
Viewed: 419 times
Share in:
Questions List:
1. Which statement below correctly defines a database? A. A collection of data B. A collection of data stored in a structured format C. A software used to store data D. A system software used to search and store data
2. The following is a list of database models except: A. Sequential B. Network C. Relational D. Hierarchical
3. Identify the statement that correctly describes referential integrity in a database relation: A. The ability of the database to refer to an external data source B. The ability to ensure data consistency and maintain relationships between tables C. The ability of the database to be secure and available for data D. The ability to query data from respective tables simultaneously
4. Carrying out database auditing is necessary because? A. It helps perform regular data backup from the database B. It aids in implementing organization policies C. It secures physical database servers D. It helps to monitor and record database activities for security and compliance
5. The process of removing redundancy from a database is called: A. Normalization B. Compilation C. Modelling D. Macros
6. Which of the following objects is used to store and organize data in a structured format? A. Table B. View C. Index D. Trigger
7. A software which provides a platform for other software to run on is known as ______: A. Application software B. System software C. Utility software D. Firmware
8. _______ is a database object used to enforce referential integrity between related tables: A. View B. Stored procedure C. Index D. Trigger
9. State the key benefit of implementing software configuration: A. Increase software development time B. Enhance software security C. Reduce software functionality D. Limit software scalability
10. A database model that represents data as a collection of objects, each with its own properties and behaviors is: A. Object-oriented model B. Relational model C. Hierarchical model D. Network model
11. The primary objective of database testing is to ___________: A. Ensure data availability B. Ensure data security C. Ensure data integrity D. Ensure data accuracy
12. Highlight the correct list of data types in MS Access: A. OLE, Text, Autonumber B. Memo, String, Currency C. Hyperlink, Number, Lookup Wizard D. Lookup, Text, OLE
13. Which of the following is NOT a step in the database design process: A. Conceptual design B. Logical design C. Physical design D. Implementation
14. What database operation is used to add new records to a table? A. Insert B. Update C. Select D. Delete
15. In a one-to-many relationship, where should the foreign key be placed? A. In the table that has the "one" side of the relationship B. In the table that has the "many" side of the relationship C. In a separate junction table D. In both tables, as a composite key
16. _______ is a database operation that is used to retrieve specific records from a table based on certain conditions: A. Insert B. Update C. Select D. Delete
17. Which of the following is not a type of MS Access data object? A. Table B. Form C. Modules D. Worksheet
18. How can you define a field so that when you are entering data hashes (symbols) are displayed? A. Validation rule B. Input mask C. Indexed D. IME mode
19. A database operation used to change the structure of a table, such as adding or removing columns: A. Alter B. Rename C. Truncate D. Drop
20. Which design phase involves determining the storage structures, indexing, and access methods? A. Conceptual design B. Logical design C. Physical design D. Implementation
21. A database has many components, Describe any TWO such components. (4 Marks)
22. John, an ICT student studying database MS Access wanted to enter data in MS Access database. Outline THREE ways he may achieve his goal. (3 Marks)
23. Using MS Access query language, describe how a multi-join query can be achieved. (4 Marks)
24. The figure below shows icons found on the standard toolbar of a MS Access. Describe the functions of the two icons shown. (4 Marks)
25. Distinguish between schema and instances as used in database management systems. (4 Marks)
26. Outline THREE benefits of macros in MS Access. (3 Marks)
27. Differentiate between bound and unbound controls as used in Microsoft Access. (4 Marks)
28. Khainga, a database designer, opted to use conceptual modeling to design a database. Highlight FOUR advantages of this model. (4 Marks)
29. John has been advised to use a database management system to store students’ marks. State FOUR disadvantages of a database management system. (4 Marks)
30. Differentiate between attribute and entity as used in database management systems. (4 Marks)
31. Explain the term data replication as used in a database. (2 Marks)
32. A company in Nairobi has opted to use a database in managing their data. Explain THREE benefits the database system would serve to the company. (6 Marks)
33. Vilani was planning to acquire a database management system for his company. Describe FOUR factors he should consider before doing the purchase. (8 Marks)
34. Describe THREE forms of normalization in a database. (6 Marks)
35. Koech, a database administrator, realized that their company database experienced a system failure. (i) Describe TWO data recovery techniques the company used to recover their data. (4 Marks) (ii) During the recovery process they experienced logical and system error. Differentiate between the TWO types of errors. (4 Marks)
36. Database design is a crucial step in building a robust and efficient database system. Explain THREE types of database design: (i) Conceptual design (3 Marks) (ii) Logical design (3 Marks) (iii) Physical design (3 Marks)
37. Differentiate between a field and a record as used in a database. (4 Marks)
38. Action Queries in MS Access perform actions on the records specified by criteria when the query is run. Explain the action of the following action queries: (i) Update (2 Marks) (ii) Delete (2 Marks) (iii) Append (2 Marks)
39. Describe the process of creating a query in MS Access 2013. (10 Marks)
40. The figure below shows a join property dialog box. Use it to answer questions that follow:
1. Which statement below correctly defines a database? A. A collection of data B. A collection of data stored in a structured format C. A software used to store data D. A system software used to search and store data
2. The following is a list of database models except: A. Sequential B. Network C. Relational D. Hierarchical
3. Identify the statement that correctly describes referential integrity in a database relation: A. The ability of the database to refer to an external data source B. The ability to ensure data consistency and maintain relationships between tables C. The ability of the database to be secure and available for data D. The ability to query data from respective tables simultaneously
4. Carrying out database auditing is necessary because? A. It helps perform regular data backup from the database B. It aids in implementing organization policies C. It secures physical database servers D. It helps to monitor and record database activities for security and compliance
5. The process of removing redundancy from a database is called: A. Normalization B. Compilation C. Modelling D. Macros
6. Which of the following objects is used to store and organize data in a structured format? A. Table B. View C. Index D. Trigger
7. A software which provides a platform for other software to run on is known as ______: A. Application software B. System software C. Utility software D. Firmware
8. _______ is a database object used to enforce referential integrity between related tables: A. View B. Stored procedure C. Index D. Trigger
9. State the key benefit of implementing software configuration: A. Increase software development time B. Enhance software security C. Reduce software functionality D. Limit software scalability
10. A database model that represents data as a collection of objects, each with its own properties and behaviors is: A. Object-oriented model B. Relational model C. Hierarchical model D. Network model
11. The primary objective of database testing is to ___________: A. Ensure data availability B. Ensure data security C. Ensure data integrity D. Ensure data accuracy
12. Highlight the correct list of data types in MS Access: A. OLE, Text, Autonumber B. Memo, String, Currency C. Hyperlink, Number, Lookup Wizard D. Lookup, Text, OLE
13. Which of the following is NOT a step in the database design process: A. Conceptual design B. Logical design C. Physical design D. Implementation
14. What database operation is used to add new records to a table? A. Insert B. Update C. Select D. Delete
15. In a one-to-many relationship, where should the foreign key be placed? A. In the table that has the "one" side of the relationship B. In the table that has the "many" side of the relationship C. In a separate junction table D. In both tables, as a composite key
16. _______ is a database operation that is used to retrieve specific records from a table based on certain conditions: A. Insert B. Update C. Select D. Delete
17. Which of the following is not a type of MS Access data object? A. Table B. Form C. Modules D. Worksheet
18. How can you define a field so that when you are entering data hashes (symbols) are displayed? A. Validation rule B. Input mask C. Indexed D. IME mode
19. A database operation used to change the structure of a table, such as adding or removing columns: A. Alter B. Rename C. Truncate D. Drop
20. Which design phase involves determining the storage structures, indexing, and access methods? A. Conceptual design B. Logical design C. Physical design D. Implementation
21. A database has many components, Describe any TWO such components. (4 Marks)
22. John, an ICT student studying database MS Access wanted to enter data in MS Access database. Outline THREE ways he may achieve his goal. (3 Marks)
23. Using MS Access query language, describe how a multi-join query can be achieved. (4 Marks)
24. The figure below shows icons found on the standard toolbar of a MS Access. Describe the functions of the two icons shown. (4 Marks)
25. Distinguish between schema and instances as used in database management systems. (4 Marks)
26. Outline THREE benefits of macros in MS Access. (3 Marks)
27. Differentiate between bound and unbound controls as used in Microsoft Access. (4 Marks)
28. Khainga, a database designer, opted to use conceptual modeling to design a database. Highlight FOUR advantages of this model. (4 Marks)
29. John has been advised to use a database management system to store students’ marks. State FOUR disadvantages of a database management system. (4 Marks)
30. Differentiate between attribute and entity as used in database management systems. (4 Marks)
31. Explain the term data replication as used in a database. (2 Marks)
32. A company in Nairobi has opted to use a database in managing their data. Explain THREE benefits the database system would serve to the company. (6 Marks)
33. Vilani was planning to acquire a database management system for his company. Describe FOUR factors he should consider before doing the purchase. (8 Marks)
34. Describe THREE forms of normalization in a database. (6 Marks)
35. Koech, a database administrator, realized that their company database experienced a system failure. (i) Describe TWO data recovery techniques the company used to recover their data. (4 Marks) (ii) During the recovery process they experienced logical and system error. Differentiate between the TWO types of errors. (4 Marks)
36. Database design is a crucial step in building a robust and efficient database system. Explain THREE types of database design: (i) Conceptual design (3 Marks) (ii) Logical design (3 Marks) (iii) Physical design (3 Marks)
37. Differentiate between a field and a record as used in a database. (4 Marks)
38. Action Queries in MS Access perform actions on the records specified by criteria when the query is run. Explain the action of the following action queries: (i) Update (2 Marks) (ii) Delete (2 Marks) (iii) Append (2 Marks)
39. Describe the process of creating a query in MS Access 2013. (10 Marks)
40. The figure below shows a join property dialog box. Use it to answer questions that follow:
