Access and Use Database Application

1. What is the definition of a database according to the document?

A. A collection of unrelated files for storage. B. A system for graphic design and image manipulation. C. An integrated collection of logically related records or files consolidated into a common pool. D. Software that manages computer hardware components.

2. Which database model is described as the most common?

A. Network model B. Relational model C. Object model D. Hierarchical model

3. What does a Database Management System (DBMS) primarily consist of?

A. Hardware components and network cables. B. Physical storage devices only. C. User interface and application programs. D. Software that organizes the storage of data.

4. Which query language is commonly used for relational databases?

A. SQL B. Python C. Java D. HTML

5. What type of tool is MS Access?

A. A word processing tool B. A database management tool C. A spreadsheet application D. A presentation software

6. Which of the following are the key objects within an MS Access database file?

A. Documents, Spreadsheets, Slides, and Media files B. Folders, Shortcuts, Drivers, and Plugins C. Tables, Queries, Forms, and Reports D. Pages, Sections, Headers, and Footers

7. In database basic concepts, what are "raw facts" called?

A. Information B. Records C. Metadata D. Data

8. Which database design principle ensures that the information system can adopt new business requirements without major breaking changes?

A. Usability B. Extensibility C. Performance D. Availability

9. Which principle ensures that a small mistake in data does not lead to major issues for an organization's key decisions?

A. Data Integrity B. Performance C. Availability D. Security

10. Which type of integrity involves the structure of the entity (primary key and its attributes)?

A. Domain Integrity B. Referential Integrity C. Entity Integrity D. User-defined Integrity

11. Which integrity defines that data should be of the correct type and optional data should be handled correctly, often through Nullability and proper data types?

A. Entity Integrity B. Referential Integrity C. User-defined Integrity D. Domain Integrity

12. Which type of integrity is implemented using foreign keys to ensure dependent entities have a uniquely identifiable parent entity in the system?

A. Entity Integrity B. Referential Integrity C. Domain Integrity D. User-defined Integrity

13. Which aspect of good database design is highlighted as crucial due to the risk of data leaks and loss of faith?

A. Security B. Performance C. Usability D. Extensibility

14. What is the fifth step in the database design process as described?

A. Divide the information into tables. B. Turn information items into columns. C. Specify primary keys. D. Set up the table relationships.

15. What is a database object in a relational database?

A. A physical server where data is stored. B. A data structure used to either store or reference data. C. Software used for creating user interfaces. D. A programming language for database interaction.

16. What is a table technically defined as in a database?

A. A container or a worksheet-like container for data collection. B. A report used for printing data. C. A query used to ask questions about data. D. A form for data entry and display.

17. What is "data about data" or table structure called?

A. Record B. Fieldname C. Information D. Metadata

18. What is the purpose of Queries in MS Access?

A. To create visual reports only. B. To define table structures and relationships. C. To view, change, and analyze data in different ways and as a source for forms/reports. D. To primarily enter or display data in a database.

19. Which type of key is used to uniquely identify each record in a table and does not allow duplication?

A. Foreign key B. Primary key C. Composite key D. Candidate key

20. Which type of key contains values that correspond to values in the primary key of another table?

A. Primary key B. Candidate key C. Super key D. Foreign key

21. In which type of relationship is each row in one database table linked to exactly one other row in another table?

A. One-to-one relationship B. One-to-many relationship C. Many-to-many relationship D. Self-referencing relationship

22. In a one-to-many relationship between Table A and Table B, how are the rows related?

A. Each row in Table A is linked to exactly one row in Table B. B. Each row in Table A is linked to many rows in Table B, and vice versa. C. Each row in Table A can be related to many rows in Table B. D. The number of rows in Table A must equal the number of rows in Table B.

23. What additional component is required to implement a many-to-many relationship?

A. A primary key from both tables B. An additional foreign key C. A composite key D. A 3rd table called a mapping table

24. What is the primary purpose of Field Properties settings in Access?

A. To enhance the visual appearance of the table. B. To safeguard data from being entered incorrectly. C. To automatically generate reports from the table. D. To link the table to external data sources.

25. For Text fields, what does the Field Size property determine?

A. The maximum number of characters that can be entered in the field. B. The format in which text is displayed. C. Whether the field is required or optional. D. The default value for the field.

Exam: Access and Use Database Application

Exam Results