CHAPTER 14 AIS

CHAPTER 14 AIS - Multiple-Choice Questions 51. The process...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Multiple-Choice Questions 51. The process of data normalization refers to: )a Eliminating data errors and other problems from “normal data” b) Scaling data to values between zero and one c) Storing data in normal storage media such as hard disks d) none of these TB 14.1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
52. As described in the chapter, all of these are normalization “forms” except : )a) First normal form )b) Second normal form )c) Third normal form )d) all of these are normal forms 52.2. The reason why database designers normalize data is: )a) To eliminate data errors )b) To scale data properly )c) To create backup copies of data )d) To create efficient database tables 52.3. In the context of databases, the term data redundancy refers to: )a) Storing the same information in several records )b) Repeating data on multiple reports )c) Using foreign keys which duplicate the values of primary keys )d) all of these are possible examples of data redundancy 52.4. A database is in third normal form if it is second normal form and: )a) It contains no data redundancies )b) It contains no foreign keys )c) It contains no transitive dependencies )d) all of these 52.5. An example of a transitive dependency in a database is: )a) Student grade )b) Telephone area code phone number )c) Airline flight number )d) Parking Code parking fine 52.6. An example of a transitive dependency in a database is: )a) Student university course number )b) Parking ticket code total of student parking fines )c) Product number product price )d) Age social security number 52.7. A database management system is: )a) A set of computer files )b) A set of one or more computer programs )c) A set of data to be processed by a computer )d) A manual accounting information system 52.8. Database management systems are important to accountants because: )a) They automate file storage tasks and enable managers to generate worthwhile financial reports )b) They eliminate data redundancy )c) They are unique data structures which accountants have never used before )d) They are easy to develop and therefore save money TB 14.2
Background image of page 2
)e) They are energy efficient 52.9. Database management systems can be implemented on: a) Mainframe computers only b) Mainframe and minicomputers only c) Mainframes, minicomputers, and microcomputers d) Microcomputers only 52.10. A disadvantage of database management systems is that: )a) They are not flexible )b) They cannot be implemented on microcomputers )c) They rarely support file inquiries )d) They are often machine dependent (e.g., not all DBMSs can run on all types of computers) 52.11. You are defining a database table. Which of the following best explains why you would assign a Social Security number field as a text field? )a)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/14/2011 for the course AC 100 taught by Professor Strickland during the Spring '11 term at Alabama.

Page1 / 8

CHAPTER 14 AIS - Multiple-Choice Questions 51. The process...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online