Quiz3 Chapter 10-12 Name Multiple Choice Identify the letter of by rogerholland

VIEWS: 1,286 PAGES: 5

									Quiz3 Chapter 10-12                                                   Name: ____________________

Multiple Choice
Identify the letter of the choice that best completes the statement or answers the question.

____    1. Useful information ____.
           a. is available when a decision maker needs it
           b. has an age suited to its use
           c. can be proven as correct or incorrect
           d. has meaning to the person who receives it
____    2. A ____ is the smallest unit of data a computer can process.
           a. bit                                            c. field
           b. character                                      d. record
____    3. ____ is a common data type that consists of dollar and cent amounts or numbers containing decimal values.
           a. AutoNumber                                     c. Currency
           b. Text                                           d. Object
____    4. Generally, users change records in a file ____.
           a. when they obtain new data or to correct inaccurate data
           b. to correct inaccurate data or to update old data with new data
           c. to update old data with new data or when a record no longer is needed
           d. when a record no longer is needed or when they obtain new data
____    5. ____, a user deletes it from a file.
           a. To correct inaccurate data                     c. To update old data with new data
           b. When new data is obtained                      d. When a record no longer is needed
____    6. Deleting unneeded files ____ storage space.
           a. increases the size of files and frees up
           b. increases the size of files and takes up
           c. reduces the size of files but takes up
           d. reduces the size of files and frees up
____    7. A user of a relational database, such as that pictured in the accompanying figure, refers to a field as a ____.
           a. table                                          c. row
           b. column                                         d. relationship
____    8. A ____ stores documents such as schedules, calendars, manuals, memos, and reports.
           a. multimedia database
           b. groupware database
           c. computer-aided design (CAD) database
           d. hypertext database
____    9. The advantage of a multidimensional database is that ____.
           a. there is a common query language
           b. the content of all dimensions is the same regardless of the subject
           c. it can consolidate data much faster than a relational database
           d. all of the above
____   10. Many search engines use databases to store Web site descriptions; thus, the search engine’s home page is the ____
           to the database.
           a. front end                                      c. back end
           b. before image                                   d. after image
____   11. The DA does all of the following except ____.
           a. decide on the proper placement of fields
            b. define the relationships among data
            c. identify users’ access privileges
            d. create and maintain the data dictionary
____ 12.    ____ measures whether the established deadlines for a project are reasonable.
            a. Operational feasibility                      c. Schedule feasibility
            b. Technical feasibility                        d. Economic feasibility
____ 13.    ____ helps system developers to understand exactly how a task is performed.
            a. Reviewing documentation                      c. Research
            b. Observing                                    d. A questionnaire
____ 14.    On a data flow diagram, a ____ is drawn as a circle.
            a. data flow                                    c. data store
            b. source                                       d. process
____ 15.    On a data flow diagram, a rectangle with no sides is a ____.
            a. data flow                                    c. data store
            b. source                                       d. process


____ 16. The concept of lower levels taking over methods and attributes of higher levels is called ____.
         a. imbalance                                      c. susceptance
         b. compliance                                     d. inheritance
____ 17. During ____, a systems analyst builds upon the data dictionary developed during the analysis phase.
         a. storage design                                 c. program design
         b. database design                                d. input and output design
____ 18. The ____ follows these six steps: (1) analyze the requirements, (2) design the solution, (3) validate the design, (4)
         implement the design, (5) test the solution, and (6) document the solution.
         a. program development cycle                      c. system development cycle
         b. post-implementation system review              d. preliminary investigation
____ 19. An integration test ____.
         a. verifies that each individual program works by itself
         b. verifies that all programs in an application work together properly
         c. verifies that an application works with other applications
         d. is performed by end-users and verifies that the new system works with actual data
____ 20. With ____, a user stops using the old system and begins using the new system on a certain date.
         a. phased conversion                              c. parallel conversion
         b. direct conversion                              d. pilot conversion


True/False
Indicate whether the sentence or statement is true or false.

____ 21. In the past, data included sounds, images, and video.
____ 22. Computers process information into data.
____ 23. Each higher level of data consists of one or more items from the lower level.
____ 24. Each record in a data file contains different fields, but each field contains the same data.
____ 25. File maintenance procedures include adding records to, changing records in, and deleting records from a file.
____ 26. Programs that maintain inactive data for a period of time seldom flag records.
____ 27. Data redundancy can increase the chance of error.
____ 28. Data in a database is more vulnerable than data in file processing systems.
____ 29. Displaying a default value increases the possibility of errors.
____ 30. To reduce data entry errors, well-designed forms should validate data as it is entered.
____ 31. In addition to storing data, a relational database also stores data relationships.
____ 32. In a relational database, users can set up a relationship between tables at any time, but the tables must have a
         common column (field).
____ 33. In a relational database, the only data redundancy (duplication) exists in the common columns (fields) used for
         relationships.
____ 34. Applications best suited for relational databases are those whose data can be organized in a two-dimensional
         table.
____ 35. Whereas a relational database can store more than two dimensions, a multidimensional database is a two-
         dimensional table.
____ 36. A relational database typically processes and summarizes large numbers of records efficiently.
____ 37. In addition to accessing information, users can provide information to Web databases.
____ 38. A carefully designed database makes it more difficult for a user to query the database, modify the data, or create
         reports.
____ 39. The system development process should have standards clearly defined.
____ 40. Because they convert user requests into technical specifications, systems analysts must have superior technical
         skills.
____ 41. During the entire system development cycle, project team members produce little documentation.
____ 42. In a feasibility report, the existing system section assesses operational, technical, and economic feasibility of the
         proposed system.
____ 43. Unlike ERDs, systems analysts seldom use DFDs to review processes with users.
____ 44. On a class diagram, each superclass inherits the operations and attributes of the objects in its subclasses.
____ 45. Acquiring the necessary hardware and software for a system consists of four major tasks: (1) identify technical
         specification, (2) solicit vendor proposals, (3) test and evaluate vendor proposals, and (4) make a decision.
____ 46. Demonstration copies of a product specified in a vendor proposal usually are expensive and have unlimited
         functionality.
____ 47. With relational database systems, during database design the systems analyst defines the structure of each table in
         the system, as well as relationships among the tables.
____ 48. After users approve a layout chart, the systems analyst develops a mockup for programmers.
____ 49. Several people should review the detailed design specifications before they are given to the programming team.
____ 50. The advantage of the direct conversion strategy is that it is extremely safe and will not disrupt operations
         seriously if the new system does not work correctly the first time.
Quiz3 Chapter 10-12
Answer Section

MULTIPLE CHOICE

      1.   ANS:   D   DIF:   Secondary   REF:   10.04   OBJ:   1
      2.   ANS:   A   DIF:   Secondary   REF:   10.05   OBJ:   3
      3.   ANS:   C   DIF:   Primary     REF:   10.06   OBJ:   3
      4.   ANS:   B   DIF:   Secondary   REF:   10.09   OBJ:   4
      5.   ANS:   D   DIF:   Secondary   REF:   10.10   OBJ:   4
      6.   ANS:   D   DIF:   Secondary   REF:   10.10   OBJ:   4
      7.   ANS:   B   DIF:   Primary     REF:   10.21   OBJ:   7
      8.   ANS:   B   DIF:   Secondary   REF:   10.22   OBJ:   7
      9.   ANS:   C   DIF:   Primary     REF:   10.24   OBJ:   7
     10.   ANS:   A   DIF:   Secondary   REF:   10.25   OBJ:   8
     11.   ANS:   D   DIF:   Primary     REF:   10.27   OBJ:   9
     12.   ANS:   C   DIF:   Secondary   REF:   12.07   OBJ:   3
     13.   ANS:   B   DIF:   Secondary   REF:   12.07   OBJ:   3
     14.   ANS:   D   DIF:   Secondary   REF:   12.15   OBJ:   6
     15.   ANS:   C   DIF:   Secondary   REF:   12.15   OBJ:   6
     16.   ANS:   D   DIF:   Secondary   REF:   12.18   OBJ:   7
     17.   ANS:   B   DIF:   Secondary   REF:   12.24   OBJ:   8
     18.   ANS:   A   DIF:   Secondary   REF:   12.27   OBJ:   9
     19.   ANS:   C   DIF:   Secondary   REF:   12.27   OBJ:   10
     20.   ANS:   B   DIF:   Secondary   REF:   12.28   OBJ:   10


TRUE/FALSE

     21.   ANS:   F   DIF:   Primary     REF:   10.02   OBJ:   2
     22.   ANS:   F   DIF:   Primary     REF:   10.02   OBJ:   2
     23.   ANS:   T   DIF:   Secondary   REF:   10.05   OBJ:   3
     24.   ANS:   F   DIF:   Primary     REF:   10.07   OBJ:   3
     25.   ANS:   T   DIF:   Primary     REF:   10.08   OBJ:   4
     26.   ANS:   F   DIF:   Secondary   REF:   10.10   OBJ:   4
     27.   ANS:   T   DIF:   Secondary   REF:   10.12   OBJ:   5
     28.   ANS:   T   DIF:   Primary     REF:   10.14   OBJ:   5
     29.   ANS:   F   DIF:   Secondary   REF:   10.14   OBJ:   6
     30.   ANS:   T   DIF:   Primary     REF:   10.17   OBJ:   6
     31.   ANS:   T   DIF:   Primary     REF:   10.21   OBJ:   7
     32.   ANS:   T   DIF:   Primary     REF:   10.21   OBJ:   7
     33.   ANS:   T   DIF:   Primary     REF:   10.21   OBJ:   7
     34.   ANS:   T   DIF:   Primary     REF:   10.21   OBJ:   7
     35.   ANS:   F   DIF:   Primary     REF:   10.23   OBJ:   7
     36.   ANS:   T   DIF:   Primary     REF:   10.24   OBJ:   7
     37.   ANS:   T   DIF:   Secondary   REF:   10.26   OBJ:   8
     38.   ANS:   F   DIF:   Secondary   REF:   10.26   OBJ:   9
39.   ANS:   T   DIF:   Secondary   REF:   12.03   OBJ:   2
40.   ANS:   T   DIF:   Primary     REF:   12.05   OBJ:   3
41.   ANS:   F   DIF:   Primary     REF:   12.07   OBJ:   3
42.   ANS:   F   DIF:   Secondary   REF:   12.13   OBJ:   5
43.   ANS:   F   DIF:   Primary     REF:   12.15   OBJ:   6
44.   ANS:   F   DIF:   Secondary   REF:   12.18   OBJ:   7
45.   ANS:   T   DIF:   Secondary   REF:   12.21   OBJ:   8
46.   ANS:   F   DIF:   Secondary   REF:   12.23   OBJ:   8
47.   ANS:   T   DIF:   Secondary   REF:   12.24   OBJ:   8
48.   ANS:   F   DIF:   Secondary   REF:   12.24   OBJ:   8
49.   ANS:   T   DIF:   Secondary   REF:   12.26   OBJ:   8
50.   ANS:   F   DIF:   Secondary   REF:   12.28   OBJ:   10

								
To top