Florida International University

CGS 3300

CGS MIDTERM 1 CHAPTER 3

TRUE/FALSE

1)Although a database can consist of only a single file, it is usually a group of files.

2. A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

3. Data redundancy is eliminated or minimized in a flat file system.

4. Updating a flat file system is efficient and consumes less time.

5. An advantage that a database has over a flat file system is that more information can be generated from the same data.

6. The database component of an information system can generate sufficient business intelligence by accessing just the internal data of an organization.

7. Labor and population statistics are sources of internal data that are accessed by a database.

8. The sequential access file structure method is effective when a large number of records are processed less frequently, perhaps on a quarterly or yearly basis.

9. Disks are sequential access devices, whereas tapes are random access devices.

10. The indexed sequential access method (ISAM) is slow and becomes increasingly useful as the number of records becomes larger.

11. With the indexed sequential access method (ISAM), records cannot be accessed randomly.

12. For each database, there can be more than one physical view of data.

13. The integrity rules component of a data model defines the boundaries of a database, constraints, and access methods.

14. In a hierarchical data model, nodes with the same parents are called siblings.

15. The network data model is similar to the hierarchical data model because records are organized in the same way

16. In a relational model, the rows are called attributes and the columns are called tuples.

17. Redundant data is eliminated by a process called normalization.

18. A select operation pares down a table by eliminating columns according to certain criteria

19. Any changes to a database's structure, such as adding a field, deleting a field, changing a field's size, or changing the data type stored in a field, are made with the data manipulation component.

20. A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

21. The use of OR operator means that only one of the conditions in an SQL statement must be met.

22. In the context of data administration component, the acronym CRUD stands for copy, revise, undo, and define

23. A database administrator is responsible for developing recovery procedures in case data is lost or corrupted.

24. In well-designed data-driven Web sites, changes are made to the HTML code every time a Web site's data content changes.

25. An e-commerce site that needs frequent updates would benefit from the use of a static Web site.

26. A distributed database is not limited by the data's physical location.

27. In contrast to the query languages used to interact with a relational database, interaction with an object-oriented database takes places via methods.

28. Data in a database is used for analytical purposes, whereas data in a data warehouse is used for capturing and managing transactions.

29. As compared to data warehouses, consolidating information from different departments or functional areas is easier in data marts.