System Analysis and Design

361. Pick entity set from the following

  1. all vendors supplying to an organization
  2. vendors and organizations they supply
  3. vendors and transporters
  4. a vendor supplying to many organizations
Correct answer: (A)
all vendors supplying to an organization

362. If an entity appears in N relationships then it is

  1. a 1:1 relationship
  2. a 1:N relationship
  3. a N:1 relationship
  4. a N:M relationship
Correct answer: (B)
a 1:N relationship

363. A relation which is in a higher normal form

  1. implies that it also qualifies to be in lower normal form
  2. does not necessarily satisfy the conditions of lower normal form
  3. is included in the lower normal form
  4. is independent of lower normal forms
Correct answer: (A)
implies that it also qualifies to be in lower normal form

364. A relation is said to be in BCNF when

  1. it has overlapping composite keys
  2. it has no composite keys
  3. it has no multivalued dependencies
  4. it has no overlapping composite keys which have related attributes
Correct answer: (D)
it has no overlapping composite keys which have related attributes

365. TEACHER-STUDENT relation in Mini-case example 2 is required because

  1. it is in 3 NF
  2. it has a multivalued key
  3. it has a composite key with multivalued dependency relation
  4. Without this relation database is incomplete and some queries cannot be answered
Correct answer: (D)
Without this relation database is incomplete and some queries cannot be answered

366. A DBMS is

  1. another name for database system
  2. independent of a database
  3. dependent on application programs
  4. is a set of procedures which manage a database
Correct answer: (D)
is a set of procedures which manage a database

367. DBMS

  1. does not allow replication of data
  2. allows controlled replication of data if it improves performance
  3. does not allow common data to be duplicated
  4. does not allow replication as it adversely affects reliability
Correct answer: (B)
allows controlled replication of data if it improves performance

368. A DBMS has the following components

  1. a data definition language
  2. a query language
  3. a security system
  4. audit trail
  1. i, ii
  2. i, ii, iii
  3. i, ii, iii, iv
  4. i, ii, iv
Correct answer: (C)
i, ii, iii, iv

369. Access right to a database is controlled by

  1. top management
  2. system designer
  3. system analyst
  4. database administrator
Correct answer: (D)
database administrator

370. The attributes of relationship teaches in teacher teaches course should be

  1. teacher code, teacher name, dept, phone no
  2. course no, course name, semester offered, credits
  3. teacher code, course no, semester no
  4. teacher code, course no, teacher name, dept, phone no
Correct answer: (C)
teacher code, course no, semester no
Page 37 of 61