System Analysis and Design Online MCQ Set 16

QN01. Given the relation
Supplier(s_id, p_order, s_name, qty)
Given that there is a unique s_name for each s_id and that s_id, p_order is a
composite key, find the correct statement among the following:

1. this relation is a BCNF
2. this is 3 NF relation
3. this is a 2 NF relation
4. this is a 1 NF relation

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

Answer

(D)i and iii

QN02. The relation SUPPLIES in Mini-case example 1 of Section 10.10 requires normalization because

1. it has a composite key with three attributes
2. the non-key attributes are dependent on part of composite key
3. the attributes item code and order no of the composite key have multivalued dependency
4. vendor code and order no have a multivalued dependency

Answer

(C)the attributes item code and order no of the composite key have multivalued dependency

QN03. The abbreviation DBMS stands for

1. Data Base Manipulation System
2. Data Bank Manipulating System
3. Data Base Management System
4. Data Bank Management System

Answer

(C)Data Base Management System

QN04. Among objectives of DBMS are ensuring

1. data integrity
2. data redundancy
3. data security
4. easy data retrieval

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

Answer

(C)i, iii, iv

QN05. When a logical model is mapped into a physical storage such as a disk store the resultant data model is known as

1. conceptual data model
2. external data model
3. internal data model
4. disk data model

Answer

(C)internal data model

QN06. The sequence followed in designing a DBMS are

1. physical model conceptual model logical model
2. logical model physical model conceptual model
3. conceptual model logical model physical model
4. conceptual model physical model logical model

Answer

(C)conceptual model logical model physical model

QN07. Pick the relationship from the following:

1. a classroom
2. teacher
3. attends
4. cost per dozen

Answer

(C)attends

QN08. The expansion of E-R diagram is

1. Entity-Relationship diagram
2. Entity-Relative diagram
3. Entity-Relation diagram
4. Entity-Rationalized diagram

Answer

(A)Entity-Relationship diagram

QN09. A pilot can fly three types of planes and a plane can be piloted by any qualified pilot. The pilot-plane type relationship is

1. N:3
2. 3:N
3. 1:3
4. 3:1

Answer

(A)N:3

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

QN11. The number of normal forms which has been proposed and discussed in the book are

1. 3
2. 4
3. 5
4. 6

Answer

(D)6

QN12. A third Normal Form (3 NF) relation should

1. be in 2 NF
2. not have complete key
3. not be 1 NF
4. should not have non-key attributes depend on key attribute

Answer

(A)be in 2 NF

QN13. BCNF is needed because

1. otherwise tuples may be duplicated
2. when a data is deleted tuples may be lost
3. updating is otherwise difficult
4. when there is dependent attributes in two possible composite keys one of the attributes is unnecessarily duplicated in the tuples

Answer

(D)when there is dependent attributes in two possible composite keys one of the attributes is unnecessarily duplicated in the tuples

QN14. TEACHES-COURSES relation in Mini-case example 2 is in

1. 3 NF. Does not need any further normalization
2. BCNF
3. 4 NF
4. unnormalized form

Answer

(A)3 NF. Does not need any further normalization

QN15. Some of the objectives of a database management system are to

1. minimize duplication of data
2. ensure centralized management control of data
3. ease retrieval of data
4. maintain a data dictionary

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

Answer

(D)i, ii and iii

QN16. Data independence allows

1. no changes in application programs
2. change in database without affecting application programs
3. hardware to be changed without affecting application programs
4. system software to be changed without affecting application programs

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

Answer

(C)ii, iii, iv

QN17. An E-R modelling for given application leads to

1. conceptual data model
2. logical data model
3. external data model
4. internal data model

Answer

(A)conceptual data model

QN18. The responsibilities of a database administrator includes

1. maintenance of data dictionary
2. ensuring security of database
3. ensuring privacy and integrity of data
4. obtain an E-R model

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

Answer

(B)i, ii, iii

QN19. Pick the meaningful relationship between entities

1. vendor supplies goods
2. vendor talks with customers
3. vendor complains to vendor
4. vendor asks prices

Answer

(A)vendor supplies goods

QN20. In an E-R diagram relationship is represented by

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

Answer

(C)diamond shaped box

QN21. If an entity appears in only one relationship then it is

1. a 1:1 relationship
2. a 1:N relationship
3. a N:1 relationship
4. a N:M relationship

Answer

(A)a 1:1 relationship

QN22. Relations are used in logical database design because

1. sound theory of relations facilitates systematic design of relational databases
2. they are very popular
3. they are flat files and easy to store and retrieve from computer's memory
4. E-R diagrams allow design of relations

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

Answer

(B)i and iii

QN23. A relation is said to be in 1NF if

1. there is no duplication of data
2. there are no composite attributes in the relation
3. there are only a few composite attributes
4. all attributes are of uniform type

Answer

(B)there are no composite attributes in the relation

QN24. A relation is said to be in 2 NF if

1. it is in 1 NF
2. non-key attributes dependent on key attribute
3. non-key attributes are independent of one another
4. if it has a composite key, no non-key attribute should be dependent on part of the composite key

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

Answer

(C)i, ii, iv

QN25. Boye Codd Normal Form (BCNF) is needed when

1. two non-key attributes are dependent
2. there is more then one possible composite key
3. there are two or more possible composite overlapping keys and one attribute of a composite key is dependent on an attribute of another composite key
4. there are two possible keys and they are dependent on one another

Answer

(C)there are two or more possible composite overlapping keys and one attribute of a composite key is dependent on an attribute of another composite key

QN26. A relation project guidance
Project Guidance (professor, project, student no. st-name, dept)

A professor can give many projects to many students
A project will have many students
A project may be guided by many professors

The 4 NF relation corresponding to this are

1. Prof_Project (professor, st_name, dept)
   Proj_stud (project, student no.)
2. Prof_stud (professor, student no)
   Proj_stud (project, student no)
   Student (student no, st_name, dept)
3. Student (student no, st_name, dept)
   Professor(professor, project)
4. Professor( professor, project, dept)
   Student (student no, st_name, dept)

Answer

(B) Prof_stud (professor, student no)
Proj_stud (project, student no)
Student (student no, st_name, dept)

QN27. One of the main objectives of a DBMS is to

1. Create a database for an organization
2. Facilitate sharing of a database by current and future applications
3. Allow sharing application programs
4. Replace file based systems

Answer

(B)Facilitate sharing of a database by current and future applications

QN28. By data integrity we mean

1. maintaining consistent data values
2. integrated data values
3. banning improper access to data
4. not leaking data values

Answer

(A)maintaining consistent data values

QN29. A good database design

1. caters primarily to current needs
2. caters to current and future needs as organizations grow
3. has to be modified when hardware is upgraded
4. ensures data security

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

Answer

(C)ii, iv

QN30. The entity set is a

1. set of entities
2. collection of different entities
3. collection of related entities
4. collection of similar entities

Answer

(D)collection of similar entities

QN31. By relation cardinality we mean

1. number of items in a relationship
2. number of relationships in which an entity can appear
3. number of items in an entity
4. number of entity sets which may be related to a given entity

Answer

(B)number of relationships in which an entity can appear

QN32. Normalization of database is essential to

1. avoid accidental deletion of required data when some data is deleted
2. eliminate inconsistencies when a data item is modified in the database
3. allows storage of data in a computer's disk
4. use a database management system

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

Answer

(B)i and ii

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

QN34. Given the following relation
Student (roll no, name, course no, course max. marks, year of study, address)
The corresponding 3 NF relations are

1. student (roll no, name, year of study, address)
   course (course no, course max. marks)
2. student (roll no, name, year of study, address)
   student (roll no, course no)
   course (course no, course max. marks)
3. student (roll no, name, address)
   year (roll no, year of study)
   course (course no, course max. marks)
4. student (roll no, name, address)
   course (course no, course max. marks, year of study)

Answer

(B) student (roll no, name, year of study, address)
student (roll no, course no)
course (course no, course max. marks)

QN35. The project guidance relation of Exercise 10.8.3 needs further normalization to 5 NF because

1. There are too many multivalued dependencies
2. Multivalued dependency and simple dependency are mixed in the 4 NF relation
3. Spurious tuples got introduced when the 4 NF relations are combined due to the fact that a professor can guide only specified projects
4. 4 NF relations have composite keys

Answer

(C)Spurious tuples got introduced when the 4 NF relations are combined due to the fact that a professor can guide only specified projects

QN36. Data availability is often difficult in file based system

1. as files are duplicated
2. as unnecessary data are stored in files
3. as one has to search different files and these files may be in different update states
4. redundant data are stored in files 8.5.4 Management policy changes are difficult to implement in a file based system because

Answer

(C)as one has to search different files and these files may be in different update states

QN37. A database models data so that it is

1. appropriate for application
2. independent of application program
3. optimized for most frequent applications
4. optimized for all applications

Answer

(B)independent of application program

QN38. Data integrity is ensured by

1. good data editing
2. propagating data changes to all data items
3. preventing unauthorized access
4. preventing data duplication

Answer

(B)propagating data changes to all data items

QN39. A check pointing system is needed

1. to ensure system security
2. to recover from transient faults
3. to ensure system privacy
4. to ensure system integrity

Answer

(B)to recover from transient faults

QN40. A good database design

1. is expandable with growth and changes in organization
2. easy to change when software changes
3. ensures data integrity
4. allows access to only authorized users

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

Answer

(C)i, ii, iii, iv