SQL exercise

TRUE/FALSE 1. A database is a physical storage device for data. ANS: F REF: 2 2. A field is a basic unit of data and can consist of a number, letter, or special symbol. ANS: F REF: 2 3. A character is a basic unit of data and can consist of a number, letter, or special symbol. ANS: T REF: 2 4. A collection of fields is a file. ANS: F REF: 2 5. A collection of records is a file. ANS: T REF: 2 6. A field in the logical design of a database corresponds to a row in the physical table of a relational database. ANS: F REF: 2 7. A record in the logical design of a database corresponds to a row in the physical table of a relational database. ANS: T REF: 2 8. The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system. ANS: T REF: 3 9. An entity is represented by a column in the Entity-Relationship Model. ANS: F REF: 4 10. Only one type of relationship can be represented in an Entity-Relationship Model. ANS: F REF: 4 11. The following types of relationships can be included in an Entity-Relationship Model: one-to-one, one-to-many, many-to-many. ANS: T REF: 4-5 12. A one-to-many relationship cannot be included in a relational database. ANS: F REF: 5 13. A one-to-many relationship means that an occurrence of a specific entity can only exist once in each table. ANS: F REF: 5 14. Data redundancy is created through a process known as normalization. ANS: F REF: 6 15. If a primary key has been identified for the data, then the data is considered to be in first normal form (1NF). ANS: F REF: 7 16. Partial dependency can only exist if the data is uniquely identified by a composite primary key. ANS: T REF: 8 17. Transitive dependency can only exist if the data is uniquely identified by a composite primary key. ANS: F REF: 8 18. Data is in second normal form (2NF) if it contains no repeating groups and has a primary key to uniquely identify each record. ANS: F REF: 8 19. Partial dependency means that at least one of the data values is dependent on only a portion of the table. ANS: F REF: 8 20. The simplest approach to remove a partial dependency is to use each portion of the primary key to create a separate table. ANS: T REF: 8 21. A foreign key uniquely identifies each row in a table. ANS: F REF: 9 22. A foreign key appears on the many side of a one-to-many relationship. ANS: T REF: 9 23. A bridging table can be used to eliminate a many-to-many relationship in a relational database. ANS: T REF: 9 24. A many-to-many relationship cannot exist in a relational database. ANS: T REF: 9 25. Two tables can be linked or joined together through a common field. ANS: T REF: 9 26. Tables can be linked or joined together through their primary keys. ANS: F REF: 9 27. A column represents a field in the physical database table. ANS: T REF: 9 28. Data mining refers to analyzing historical data stored in a database. ANS: T REF: 12 29. Data mining refers to storing vast amounts of data in a database. ANS: F REF: 12 30. Structured Query Language (SQL) is generally used to interact with a database. ANS: T REF: 14