System Analysis and Design

381. Relationships are identified from the word statement of a problem by

  1. picking words which are adjectives
  2. picking words which are nouns
  3. picking words which are verbs
  4. picking words which are pronouns
Correct answer: (C)
picking words which are verbs

382. The rows of a relation

  1. must be in specified order
  2. may be in any order
  3. in ascending order of key
  4. in descending order of key
Correct answer: (B)
may be in any order

383. Given the following relation
vendor order ( vendor no, order no, vendor name, qty supplied, price/unit) it is not in 2 NF because

  1. it is not in 1 NF
  2. it has a composite key
  3. non-key attribute vendor name is dependent on vendor no. which is one part of the composite key
  4. Qty supplied and price/unit are dependent
Correct answer: (C)
non-key attribute vendor name is dependent on vendor no. which is one part of the composite key

384. Fourth normal form (4 NF) relations are needed when

  1. there are multivalued dependencies between attributes in composite key
  2. there are more than one composite key
  3. there are two or more overlapping composite keys
  4. there are multivalued dependency between non-key attributes
Correct answer: (A)
there are multivalued dependencies between attributes in composite key

385. Data integrity in a file based system may be lost because

  1. the same variable may have different values in different files
  2. files are duplicated
  3. unnecessary data is stored in files
  4. redundant data is stored in files
Correct answer: (A)
the same variable may have different values in different files

386. A DBMS

  1. is a set of procedures
  2. manages a database
  3. is a set of procedures to manage a database to provide data as required by applications
  4. provides data to applications
Correct answer: (C)
is a set of procedures to manage a database to provide data as required by applications

387. Data independence allows

  1. sharing the same database by several applications
  2. extensive modification of applications
  3. no data sharing between applications
  4. elimination of several application programs
Correct answer: (A)
sharing the same database by several applications

388. A conceptual data model is converted using a Relational Data Base Management System to a

  1. logical data model
  2. external data model
  3. internal data model
  4. an entity-relation data model
Correct answer: (A)
logical data model

389. The columns of a relation

  1. must be in specified order
  2. may be in any order
  3. with key field in first column
  4. with largest width column last
Correct answer: (B)
may be in any order

390. Given the following relation it is not 3 NF because
Student (roll no, name, course no, course max. marks, year of study, address)

  1. it is not in 2 NF
  2. it does not have composite key
  3. non-key attributes course no and course max. marks are functionally dependent
  4. it has more than 3 non-key attributes
Correct answer: (C)
non-key attributes course no and course max. marks are functionally dependent
Page 39 of 61