System Analysis and Design Online MCQ Set 15

QN01. Serial numbers used as codes are

  1. concise
  2. meaningful
  3. expandable
  4. comprehensive
  1. i and ii
  2. ii and iii
  3. ii and iv
  4. i and iii
Answer

(D)i and iii

QN02. A modulus-11 check digit will detect

  1. single transcription errors
  2. single transposition errors
  3. multiple digit transcription errors
  4. and correct a single error
  1. i and iii
  2. i and iv
  3. i and ii
  4. iii and iv
Answer

(C)i and ii

QN03. For modulus-11 check digit to detect single transposition or single transcription error the number of digits in the codes should not exceed

  1. 9
  2. 10
  3. 11
  4. 99
Answer

(B)10

QN04. If a field is known to represent days of a month, radix used to check should be

  1. 30
  2. 31
  3. 28
  4. 29
Answer

(B)31

QN05. A data element in a data dictionary may have

  1. only integer value
  2. no value
  3. only real value
  4. only decimal value
Answer

(B)no value

QN06. In interactive data input a template is normally used to

  1. enter new data
  2. add/delete data
  3. select one out of many alternatives often by a mouse click
  4. detect errors in data input
Answer

(A)enter new data

QN07. A concise code is necessarily

  1. precise
  2. meaningful
  3. comprehensive
  4. difficult
Answer

(A)precise

QN08. A modulus-17 check will detect single transcription errors in

  1. alphanumeric codes
  2. hexadecimal codes
  3. decimal numerical codes
  4. serial number codes
Answer

(B)hexadecimal codes

QN09. An appropriate range check for marks in an examination paper whose maximum marks 100 is

  1. 100
  2. 0 to 100
  3. - 99 to +99
  4. 99
Answer

(B)0 to 100

QN10. An appropriate range check of age of a tenth standard student in a high school is

  1. 5 to 15
  2. 10 to 25
  3. 8 to 20
  4. 3 to 18
Answer

(C)8 to 20

QN11. A data element in a data flow

  1. may be an integer number
  2. may be a real number
  3. may be binary
  4. may be imaginary
  1. (i),(ii),(iv)
  2. (iii),(iv),(ii)
  3. (i),(ii),(iii)
  4. (i) and (ii)
Answer

(C)(i),(ii),(iii)

QN12. In interactive data input terminal commands are normally used to

  1. enter new data
  2. add/delete data
  3. select one out of many alternatives often by a mouse click
  4. detect errors in data input
Answer

(B)add/delete data

QN13. Group classification codes are

  1. concise
  2. meaningful
  3. expandable
  4. comprehensive
  1. i and ii
  2. i, ii and iii
  3. ii, iii and iv
  4. i, ii and iv
Answer

(C)ii, iii and iv

QN14. Modulus-11 check digit for the code 85672 is

  1. 0
  2. 1
  3. X
  4. 3
Answer

(C)X

QN15. An appropriate range check for month field in a date is

  1. 12
  2. -12 to 12
  3. 1 to 12
  4. 0 to 12
Answer

(C)1 to 12

QN16. Good system design prevents data entry errors by

  1. Designing good forms with plenty of space to write in block capitals>
  2. By giving clear instructions to a user on how to fill a form
  3. Reducing keystrokes of an operator
  4. Designing good keyboard
  1. i, ii, iii
  2. i, ii, iv
  3. i, ii
  4. iii and iv
Answer

(A)i, ii, iii

QN17. Key fields are normally coded

  1. as they provide a unique identification
  2. as they are used for retrieving records
  3. as they facilitate cross referencing between applications which use the key
  4. as it is useful
  1. i and ii
  2. i and iv
  3. ii and iii
  4. i and iii
Answer

(D)i and iii

QN18. Design of error detecting codes requires good

  1. knowledge of mathematics
  2. statistical mechanics
  3. statistics of errors normally committed during data entry
  4. Boolean algebra
Answer

(C)statistics of errors normally committed during data entry

QN19. Sequence numbering of records is used to

  1. Identify each record uniquely
  2. Track a missing record in a batch of records
  3. Count number of records
  4. Sort the records
  1. i, ii
  2. i, ii, iii
  3. i, ii, iii, iv
  4. i and iv
Answer

(C)i, ii, iii, iv

QN20. For modulus-11 check digit to detect a single transposition errors the

  1. weights should all be distinct
  2. weights may all be equal and > 0
  3. weights should be less than 8
  4. weights should all be > 0 and distinct
Answer

(D)weights should all be > 0 and distinct

QN21. An entity is

  1. a collection of items in an application
  2. a distinct real world item in an application
  3. an inanimate object in an application
  4. a data structure
Answer

(B)a distinct real world item in an application

QN22. In an E-R diagram entities are represented by

  1. circles
  2. rectangles
  3. diamond shaped box
  4. ellipse
Answer

(B)rectangles

QN23. A student can take not more than 5 subjects in a semester. The number of students allowed in a subject in a semester is not more than 40. The student

- subject relationship is:

  1. 5:40
  2. 40:5
  3. N:5
  4. 40:M
Answer

(B)40:5

QN24. The relation given in Exercise 10.4.4 may be converted to 1 NF relation by

  1. eliminating composite attributes
  2. eliminating common attributes
  3. duplicating common attributes as many times as lines in corresponding attributes
  4. putting composite attributes in a separate table
Answer

(C)duplicating common attributes as many times as lines in corresponding attributes

QN25. Given the relation of Exercise 10.7.5 it is reduced to the following BCNF relation

  1. Supplier (s_ids, s_name)
    Purchase (s_id, p_order, qty)
  2. Supplier (s_id, s_name)
    Purchase (p_order, qty)
  3. Purchase (s_id, p_order)
    Supplier (s_name, qty)
  4. Supplier (s_id, s_name, qty)
    Purchase (s_id, p_order)
Answer

(A)Supplier (s_ids, s_name) Purchase (s_id, p_order, qty)

QN26. The ORDER PLACED FOR relation in Mini-case example 1 has the composite key order no, item code because

  1. item code has a multivalued dependency with order no.
  2. the non-key attributes are dependent on the composite key order no, item code
  3. if order no is the only key we cannot find qty. ordered, price/unit, delivery time
  4. if item code is the only key we cannot find order no. uniquely
Answer

(A)item code has a multivalued dependency with order no.

QN27. By data independence we mean application programs

  1. do not need data
  2. may be developed independent of data
  3. may be developed without knowing the organization of data
  4. may be developed with independent data
Answer

(C)may be developed without knowing the organization of data

QN28. By data security in DBMS we mean

  1. preventing access to data
  2. allowing access to data only to authorized users
  3. preventing changing data
  4. introducing integrity constraints
Answer

(B)allowing access to data only to authorized users

QN29. Designing physical model of DBMS requires information on

  1. data volume
  2. frequency of access to data
  3. programming language used
  4. secondary memory characteristics
  1. i, ii
  2. i, ii, iii
  3. i, ii, iii, iv
  4. i, ii, iv
Answer

(D)i, ii, iv

QN30. Pick entities from the following:

  1. vendor
  2. student
  3. attends
  4. km/hour
  1. i, ii, iii
  2. i, ii, iv
  3. i and ii
  4. iii and iv
Answer

(C)i and ii

QN31. Attributes are

  1. properties of relationship
  2. attributed to entities
  3. properties of members of an entity set
  1. i
  2. i and ii
  3. i and iii
  4. iii
Answer

(C)i and iii

QN32. A relation is

  1. an entity
  2. a relationship
  3. members of a relationship set
  4. members of an entity set or a relationship set
Answer

(D)members of an entity set or a relationship set

QN33. Normalization is a process of restructuring a relation to

  1. minimize duplication of data in a database
  2. maximize duplication of data to ensure reliability
  3. make it of uniform size
  4. allow addition of data
Answer

(A)minimize duplication of data in a database

QN34. A second Normal Form (2 NF) relation should

  1. be in 1 NF
  2. not have a composite key
  3. not have attributes dependent on key attribute
  4. not have attributes dependent on one another
Answer

(A)be in 1 NF

QN35. A relationship is

  1. an item in an application
  2. a meaningful dependency between entities
  3. a collection of related entities
  4. related data
Answer

(B)a meaningful dependency between entities

QN36. One entity may be

  1. related to only one other entity
  2. related to itself
  3. related to only two other entities
  4. related to many other entities
Answer

(D)related to many other entities

QN37. Rows of a relation are called

  1. tuples
  2. a relation row
  3. a data structure
  4. an entity
Answer

(A)tuples

QN38. The process of normalization

  1. is automatic using a computer program
  2. requires one to understand dependency between attributes
  3. is manual and requires semantic information
  4. is finding the key of a relation
Answer

(B)requires one to understand dependency between attributes

QN39. An attribute y may be functionally dependent on

  1. a composite attribute x,y
  2. a single attribute x
  3. no attribute
  1. i and ii
  2. i and iii
  3. ii and iii
  4. iii
Answer

(A)i and ii

QN40. A relation is said to be in 3 NF if

  1. it is in 2 NF
  2. non-key attributes are independent of one another
  3. key attribute is not dependent on part of a composite key
  4. has no multi-valued dependency
  1. i and iii
  2. i and iv
  3. i and ii
  4. ii and iv
Answer

(C)i and ii

ed010d383e1f191bdb025d5985cc03fc?s=120&d=mm&r=g

DistPub Team

Distance Publisher (DistPub.com) provide project writing help from year 2007 and provide writing and editing help to hundreds student every year.