System Analysis and Design
261. A code is useful to represent a key field because
- it is a concise representation of the field
- it is usually done by all
- it is generally a good idea
- it is needed in database design
Correct answer: (A)
it is a concise representation of the field
262. Block codes are
- concise
- meaningful
- expandable
- comprehensive
- i and ii
- ii and iii
- iii and iv
- i and iii
Correct answer: (B)
ii and iii
263. A modulus-11 check digit is used to detect error in
- alphanumeric codes
- numeric codes
- hexadecimal codes
- serial number code
Correct answer: (B)
numeric codes
264. Modulus-17 check character for the hexadecimal code AB4567 is
- F
- D
- 1
- 0
Correct answer: (B)
D
265. Radix check for a field representing year is
- possible
- not possible
- not relevant
- may be tried
Correct answer: (B)
not possible
266. Batch control totals will detect
- incorrect data entry of a field
- missing record
- data records out of order
- inconsistent data
- i and ii
- i, ii and iii
- ii, iii and iv
- iii and iv
Correct answer: (A)
i and ii
267. By metadata we mean
- very large data
- data about data
- data dictionary
- meaningful data
Correct answer: (B)
data about data
268. Errors occur more often when
- data is entered by users
- data is entered by operators
- when data is handwritten by users and entered by an operator
- the key board design is bad
Correct answer: (C)
when data is handwritten by users and entered by an operator
269. Data inputs which required coding are
- fields which specify prices
- key fields
- name fields such as product name
- fields which are of variable length
Correct answer: (B)
key fields
270. By the term "comprehensive code" we understand that the code
- conveys information on item being coded
- is of small length
- can add new item easily
- includes all relevant characteristics of item being coded
Correct answer: (D)
includes all relevant characteristics of item being coded