System Analysis and Design Online MCQ Set 17

QN01. 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

Answer

(A)all vendors supplying to an organization

QN02. 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

Answer

(B)a 1:N relationship

QN03. 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

Answer

(A)implies that it also qualifies to be in lower normal form

QN04. 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

Answer

(D)it has no overlapping composite keys which have related attributes

QN05. 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

Answer

(D)Without this relation database is incomplete and some queries cannot be answered

QN06. 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

Answer

(D)is a set of procedures which manage a database

QN07. 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

Answer

(B)allows controlled replication of data if it improves performance

QN08. 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

Answer

(C)i, ii, iii, iv

QN09. Access right to a database is controlled by

1. top management
2. system designer
3. system analyst
4. database administrator

Answer

(D)database administrator

QN10. 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

Answer

(C)teacher code, course no, semester no

QN11. If an entity appears in not more than 5 relationships then it is a

1. 1:1 relationship
2. 1:5 relationship
3. 5:1 relationship
4. 5:5 relationship

Answer

(B)1:5 relationship

QN12. Given an attribute x, another attribute y is dependent on it, if for a given x

1. there are many y values
2. there is only one value of y
3. there is one or more y values
4. there is none or one y value

Answer

(B)there is only one value of y

QN13. Given the following relation
vendor order (vendor no, order no, vendor name, qty supplied, price/unit)
the second normal form relations are

1. vendor (vendor no, vendor name)
   qty (qty supplied, price/unit)
   order (order no, qty supplied)
2. vendor (vendor no, vendor name)
   order (order no, qty supplied, price/unit)
3. vendor (vendor no, vendor name)
   order (order no, qty supplied, price/unit)
   vendor order (vendor no, order no)
4. vendor (vendor no, vendor name, qty supplied, price/unit)
   vendor order (order no, vendor no)

Answer

(C) vendor (vendor no, vendor name)
order (order no, qty supplied, price/unit)
vendor order (vendor no, order no)

QN14. A 3 NF relation is converted to BCNF by

1. removing composite keys
2. removing multivalued dependencies
3. dependent attributes of overlapping composite keys are put in a separate relation
4. dependent non-key attributes are put in a separate table

Answer

(C)dependent attributes of overlapping composite keys are put in a separate relation

QN15. By redundancy in a file based system we mean that

1. unnecessary data is stored
2. same data is duplicated in many files
3. data is unavailable
4. files have redundant data

Answer

(B)same data is duplicated in many files

QN16. A database is a

1. collection of files
2. collection of inputs and outputs of application
3. collection of related data necessary to manage an organization
4. data resource of an organization

Answer

(C)collection of related data necessary to manage an organization

QN17. Database is

1. an important resource of an organization
2. not relevant to existing programs
3. not relevant for future programs
4. not as good as files as there is redundancy

Answer

(A)an important resource of an organization

QN18. DBMS must implement management controls to

1. control access rights to users
2. implement audit trail when changes are made
3. allow data to be used extensively in the organization
4. duplicate databases

1. i, ii
2. ii, iii
3. iii, iv
4. i, iv

Answer

(A)i, ii

QN19. A database administrator

1. administers data in an organization
2. controls all inputs and all outputs of programs
3. is controller of data resources of an organization
4. controls all data entry operators

Answer

(C)is controller of data resources of an organization

QN20. Entities 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

Answer

(B)picking words which are nouns

QN21. 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

Answer

(C)picking words which are verbs

QN22. 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

Answer

(B)may be in any order

QN23. 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

Answer

(C)non-key attribute vendor name is dependent on vendor no. which is one part of the composite key

QN24. 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

Answer

(A)there are multivalued dependencies between attributes in composite key

QN25. 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

Answer

(A)the same variable may have different values in different files

QN26. 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

Answer

(C)is a set of procedures to manage a database to provide data as required by applications

QN27. 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

Answer

(A)sharing the same database by several applications

QN28. 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

Answer

(A)logical data model

QN29. 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

Answer

(B)may be in any order

QN30. 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

Answer

(C)non-key attributes course no and course max. marks are functionally dependent

QN31. A 3 NF relation is split into 4 NF

1. by removing overlapping composite keys
2. by splitting into relations which do not have more than one independent multivalued dependency
3. removing multivalued dependency
4. by putting dependent non-key attribute in a separate table

Answer

(B)by splitting into relations which do not have more than one independent multivalued dependency

QN32. 5 NF relations equivalent to the relation of Exercise 10.8.3 are

1. Prof_stud (professor, student_no)
   Proj_stud ( project, student_no)
   Prof_proj (professor, project)
   Student (student_no, st_name, dept)
2. Professor (professor, professor details)
   Student (student_no, st_name, dept)
   Project (project no, project details)
3. Prof_stud (professor, student_no)
   Prof_proj (professor, project)
4. Prof_stud (professor, student_no)
   Stud_proj (student_no, project)
   Student (student_no, st_name, dept)

Answer

(A) Prof_stud (professor, student_no)
Proj_stud ( project, student_no)
Prof_proj (professor, project)
Student (student_no, st_name, dept)

QN33. A database should be designed to allow providing

1. different views of portions of data requested by an application
2. data only to selected applications as decided by an organization
3. a uniform view of data to all applications
4. data to all applications

Answer

(A)different views of portions of data requested by an application

QN34. A subset of logical data model accessed by programmers is called a

1. conceptual data model
2. external data model
3. internal data model
4. an entity-relation data model

Answer

(B)external data model

QN35. Computer systems are designed by

1. simplifying requirements of system
2. breaking of the system into smaller self-contained co-operating subsystems
3. breaking up the systems into independent parts
4. modular design

Answer

(B)breaking of the system into smaller self-contained co-operating subsystems

QN36. The advantages of object-oriented modelling are

1. it allows easy integration of subsystems
2. it promotes reuse of code written earlier
3. it allows modification of some objects by other objects
4. it allows data structures in objects to be modified by other objects

1. i, ii
2. i, iii
3. ii, iii
4. i, iv

Answer

(A)i, ii

QN37. A query operation on a object

1. has side effect
2. has no side effects
3. changes the state of an object
4. is not allowed

Answer

(B)has no side effects

QN38. Objects may be viewed as

1. clients in a system
2. servers in a system
3. as both clients and servers in a system
4. neither as clients nor as servers in a system

Answer

(C)as both clients and servers in a system

QN39. Given a word statement of a problem potential objects are identified by selecting

1. verb phrases in the statement
2. noun phrases in the statement
3. adjectives in the statement
4. adverbs in the statement

Answer

(B)noun phrases in the statement

QN40. Object-oriented system modelling using CRC method gives

1. Java programs for the system
2. C++ programs for the system
3. Classes of the system, their responsibilities and collaborating classes
4. Objective C programs for the system

Answer

(C)Classes of the system, their responsibilities and collaborating classes