CSCI515-1.3b Workshop 1: Quiz

1.  is the body of information and facts about a specific subject.
A: Knowledge

2. Unstructured and semistructured data can be stored in the databases below except __?
A: Microsoft Access database

3. A database contains how many types of data?
A: Two

4. When identifying types of relationships represented by business rules, consider that relationships between entities are _____.
A: bidirectional

5. Dale’s boss has tasked him with creating a simple representation of the entire employee database including items such a hire date, office contact number, and resume. What type of model should Dale construct?

A: data

6. Which of the answers below is one of the challenges of managing a database system?

A: Vendor dependence


7. A(n) _____ is bidirectional.
A:  relationship

8. Which of the databases below would you recommend for a client that supports a relatively small number of users (usually fewer than 50) or a specific department within the client’s organization?
A: workgroup

9. In explaining data, you could say that the word data covers the collection of ___ stored in the database.
A: Facts

10. Determine which of the following simple-language expressions represents a valid constraint.
A: Each CONTAINER contains between 0 and 100 UNITs.

11. April is a database administrator, she wants to provide a description of the data characteristics and the set of relationships that link the data found within the database. What should she use?
A: Metadata

12. Metadata is ___?
A: Data about data

13. Ali needs to review the metadata of a file system. Where should they look?
A: Name node

14. By examining the _____ in a business rule, a database designer can identify the database as a collection of records in 1:1, 1:M, or M:N relationships.
A: nouns

15. When discovering new business rules, interviews with _____ are faster and more direct, but may be less reliable.
A: end users

16. Omar is constructing a data model. In his model he includes a description of the data structure that will store end-user data and has an enforceable set of rules to ensure data integrity. What component does he need to include to make his data model implementation ready?
A: data manipulation methodology

17. A database management system (DBMS) can be likened to__?

A: A very well-organized electronic filing cabinet

18. Comel, a student, takes four classes with her group of best friends. She sits in the front row with two friends and the others sit behind them. What type of relationship would Comel’s situation be described as? 
A: many-to-many

19. Complete the following statement: Business rules must ______.
A: be rendered in writing

20. Which of the answers below is one of the problems with File system Data Processing?
A: Lengthy development time

Leave a Reply

Your email address will not be published. Required fields are marked *