System Analysis and Design

261. A code is useful to represent a key field because

  1. it is a concise representation of the field
  2. it is usually done by all
  3. it is generally a good idea
  4. it is needed in database design
Correct answer: (A)
it is a concise representation of the field

262. Block codes are

  1. concise
  2. meaningful
  3. expandable
  4. comprehensive
  1. i and ii
  2. ii and iii
  3. iii and iv
  4. i and iii
Correct answer: (B)
ii and iii

263. A modulus-11 check digit is used to detect error in

  1. alphanumeric codes
  2. numeric codes
  3. hexadecimal codes
  4. serial number code
Correct answer: (B)
numeric codes

264. Modulus-17 check character for the hexadecimal code AB4567 is

  1. F
  2. D
  3. 1
  4. 0
Correct answer: (B)
D

265. Radix check for a field representing year is

  1. possible
  2. not possible
  3. not relevant
  4. may be tried
Correct answer: (B)
not possible

266. Batch control totals will detect

  1. incorrect data entry of a field
  2. missing record
  3. data records out of order
  4. inconsistent data
  1. i and ii
  2. i, ii and iii
  3. ii, iii and iv
  4. iii and iv
Correct answer: (A)
i and ii

267. By metadata we mean

  1. very large data
  2. data about data
  3. data dictionary
  4. meaningful data
Correct answer: (B)
data about data

268. Errors occur more often when

  1. data is entered by users
  2. data is entered by operators
  3. when data is handwritten by users and entered by an operator
  4. 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

  1. fields which specify prices
  2. key fields
  3. name fields such as product name
  4. fields which are of variable length
Correct answer: (B)
key fields

270. By the term "comprehensive code" we understand that the code

  1. conveys information on item being coded
  2. is of small length
  3. can add new item easily
  4. includes all relevant characteristics of item being coded
Correct answer: (D)
includes all relevant characteristics of item being coded
Page 27 of 61