MBA/MBA System Analysis and Design Mcq Set 5 Sample Test,Sample questions

Question:
A concise code is necessarily

1.precise

2.meaningful

3.comprehensive

4.difficult


Question:
A data dictionary is usually developed

1.At requirements specification phase

2.During feasibility analysis

3.When DFD is developed

4.When a datadase is designed


Question:
A data element in a data dictionary may have

1.only integer value

2.no value

3.only real value

4.only decimal value


Question:
A modulus-17 check will detect single transcription errors in

1.alphanumeric codes

2.hexadecimal codes

3.decimal numerical codes

4.serial number codes


Question:
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


Question:
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


Question:
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


Question:
A relationship is

1.an item in an application

2.a meaningful dependency between entities

3.a collection of related entities

4.related data


Question:
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


Question:
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


Question:
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


Question:
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


Question:
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


Question:
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


Question:
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


Question:
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


Question:
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


Question:
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


Question:
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


Question:
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


Question:
By the term "concise code” we understand that the code

1.conveys information on item being coded

2.is of small length

3.can add new item easily

4.includes all relevant characteristics of item being coded


Question:
By the term "expandable code" we understand that the code

1.conveys information on item being coded

2.is of small length

3.can add new item easily

4.includes all relevant characteristics of item being coded


Question:
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


Question:
Errors in codes are detected by

1.proper design of code

2.introducing redundant digits/characters designed to detect errors

3.making the code concise

4.making the code precise


Question:
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


Question:
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


Question:
If a field is known to represent an angle of a triangle, radix used to check should be

1.90

2.60

3.180

4.360


Question:
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


Question:
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


Question:
In an E-R diagram entities are represented by

1.circles

2.rectangles

3.diamond shaped box

4.ellipse


Question:
In an E-R diagram relationship is represented by

1.circles

2.rectangles

3.diamond shaped box

4.ellipse


Question:
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


Question:
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


Question:
Modulus-11 check digit for the code 85672 is

1.0

2.1

3.X

4.3


Question:
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


Question:
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


Question:
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


Question:
Pick the meaningful relationship between entities

1.vendor supplies goods

2.vendor talks with customers

3.vendor complains to vendor

4.vendor asks prices


Question:
Pick the relationship from the following:

1.a classroom

2.teacher

3.attends

4.cost per dozen


Question:
Rows of a relation are called

1.tuples

2.a relation row

3.a data structure

4.an entity


Question:
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


Question:
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


Question:
The expansion of E-R diagram is

1.Entity-Relationship diagram

2.Entity-Relative diagram

3.Entity-Relation diagram

4.Entity-Rationalized diagram


Question:
The number of normal forms which has been proposed and discussed in the book are

1.3

2.4

3.5

4.6


Question:
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


Question:
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


Question:
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


Question:
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


Question:
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


Question:
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


More MCQS

  1. MBA Accounting MCQ Question Set 1
  2. MBA Accounting MCQ Question Set 2
  3. MBA Accounting MCQ Question Set 3
  4. MBA Accounting MCQ Question Set 4
  5. MBA Accounting MCQ Question Set 5
  6. MBA Accounting MCQ Question Set 6
  7. MBA Accounting MCQ Question Set 7
  8. MBA Accounting MCQ Question Set 8
  9. MBA Accounting MCQ Question Set 9
  10. MBA Accounting MCQ Question Set 10
  11. MBA Advertising and Sales Promotion Mcq Set 1
  12. MBA Advertising and Sales Promotion Mcq Set 2
  13. MBA Advertising and Sales Promotion Mcq Set 3
  14. MBA Advertising and Sales Promotion Mcq Set 4
  15. MBA Advertising and Sales Promotion Mcq Set 5
  16. MBA Advertising and Sales Promotion Mcq Set 6
  17. MBA Advertising and Sales Promotion Mcq Set 7
  18. MBA Advertising and Sales Promotion Mcq Set 8
  19. MBA Advertising and Sales Promotion Mcq Set 9
  20. MBA Advertising and Sales Promotion Mcq Set 10
  21. MBA Advertising and Sales Promotion Mcq Set 11
  22. MBA Advertising and Sales Promotion Mcq Set 12
  23. MBA Advertising and Sales Promotion Mcq Set 13
  24. MBA Behavioural and Allied Sciences MCQ Set 1
  25. MBA Behavioural and Allied Sciences MCQ Set 2
  26. MBA Behavioural and Allied Sciences MCQ Set 3
  27. MBA Behavioural and Allied Sciences MCQ Set 4
  28. MBA Behavioural and Allied Sciences MCQ Set 5
  29. MBA Behavioural and Allied Sciences MCQ Set 6
  30. MBA Behavioural and Allied Sciences MCQ Set 7
  31. MBA Behavioural and Allied Sciences MCQ Set 8
  32. MBA Behavioural and Allied Sciences MCQ Set 9
  33. MBA Behavioural and Allied Sciences MCQ Set 10
  34. MBA Brand Management MCQ Set 1
  35. MBA Brand Management MCQ Set 2
  36. MBA Brand Management MCQ Set 3
  37. MBA Brand Management MCQ Set 4
  38. MBA Brand Management MCQ Set 5
  39. MBA Business Communication MCQ Set 1
  40. MBA Business Communication MCQ Set 2
  41. MBA Business Communication MCQ Set 3
  42. MBA Business Communication MCQ Set 4
  43. MBA Business Communication MCQ Set 5
  44. MBA Business Communication MCQ Set 6
  45. MBA Business Communication MCQ Set 7
  46. MBA Business Communication MCQ Set 8
  47. MBA Business Communication MCQ Set 9
  48. MBA Brand Management MCQ Set 10
  49. MBA Brand Management MCQ Set 11
  50. MBA Business Economics MCQ Set 1
  51. MBA Business Economics MCQ Set 2
  52. MBA Business Economics MCQ Set 3
  53. MBA Business Economics MCQ Set 4
  54. MBA Business Economics MCQ Set 5
  55. MBA Business Economics MCQ Set 6
  56. MBA Business Environment MCQ Set 1
  57. MBA Business Environment MCQ Set 2
  58. MBA Business Environment MCQ Set 3
  59. MBA Business Environment MCQ Set 4
  60. MBA Business Environment MCQ Set 5
  61. MBA Business Environment MCQ Set 6
  62. MBA Business Environment MCQ Set 7
  63. MBA Business Environment MCQ Set 8
  64. MBA Business Environment MCQ Set 9
  65. MBA Business Ethics and Governance MCQ Set 1
  66. MBA Business Law Mcq Set 1
  67. MBA Business Law Mcq Set 2
  68. MBA Business Law Mcq Set 3
  69. MBA Business Law Mcq Set 4
  70. MBA Business Law Mcq Set 5
  71. MBA Business Law Mcq Set 6
  72. MBA Business Law Mcq Set 7
  73. MBA Business Law Mcq Set 8
  74. MBA Business Law Mcq Set 9
  75. MBA Business Mathematics Mcq Set 1
  76. MBA Business Mathematics Mcq Set 2
  77. MBA Business Mathematics Mcq Set 3
  78. MBA Business Mathematics Mcq Set 4
  79. MBA Business Mathematics Mcq Set 5
  80. MBA Business Mathematics Mcq Set 6
  81. MBA Business Statistics Mcq Set 1
  82. MBA Business Statistics Mcq Set 2
  83. MBA Computers In Management Mcq Set 1
  84. MBA Computers In Management Mcq Set 2
  85. MBA Computers In Management Mcq Set 3
  86. MBA Computers In Management Mcq Set 4
  87. MAB Cost and Managerial Accounting Mcq Set 1
  88. MBA Cost and Managerial Accounting Mcq Set 1
  89. MBA Cost and Managerial Accounting Mcq Set 2
  90. MBA Cost and Managerial Accounting Mcq Set 3
  91. MBA Cost and Managerial Accounting Mcq Set 4
  92. MBA Cost and Managerial Accounting Mcq Set 5
  93. MBA Cost and Managerial Accounting Mcq Set 6
  94. MBA Cost and Managerial Accounting Mcq Set 7
  95. MBA Cost and Managerial Accounting Mcq Set 8
  96. MBA Cost and Managerial Accounting Mcq Set 9
  97. MBA Cost and Managerial Accounting Mcq Set 10
  98. MBA Cost and Managerial Accounting Mcq Set 11
  99. MBA E-Business MCQ Set 1
  100. MBA E-Business MCQ Set 2
  101. MBA E-Business MCQ Set 3
  102. MBA E-Business MCQ Set 4
  103. MBA English Language MCQ Set 1
  104. MBA English Language MCQ Set 2
  105. MBA Entrepreneurship Management MCQ Set 1
  106. MBA Entrepreneurship Management MCQ Set 2
  107. MBA Entrepreneurship Management MCQ Set 3
  108. MBA Entrepreneurship Management MCQ Set 4
  109. MBA Entrepreneurship Management MCQ Set 5
  110. MBA Entrepreneurship Management MCQ Set 6
  111. MBA Financial Management MCQ Set 1
  112. MBA Financial Management MCQ Set 2
  113. MBA Financial Management MCQ Set 3
  114. MBA Financial Management MCQ Set 4
  115. MBA Financial Management MCQ Set 5
  116. MBA Financial Management MCQ Set 6
  117. MBA Financial Management MCQ Set 7
  118. MBA Financial Management MCQ Set 8
  119. MBA Financial Management MCQ Set 9
  120. MBA Financial Management MCQ Set 10
  121. MBA Financial Management MCQ Set 11
  122. MBA Financial Management MCQ Set 12
  123. MBA Human Resource Management Mcq Set 1
  124. MBA Human Resource Management Mcq Set 2
  125. MBA Human Resource Management Mcq Set 3
  126. MBA Human Resource Management Mcq Set 4
  127. MBA Human Resource Management Mcq Set 5
  128. MBA Human Resource Management Mcq Set 6
  129. MBA Human Resource Management Mcq Set 7
  130. MBA Human Resource Management Mcq Set 8
  131. MBA Insurance and Risk Management Mcq Set 1
  132. MBA Insurance and Risk Management Mcq Set 2
  133. MBA Insurance and Risk Management Mcq Set 3
  134. MBA Insurance and Risk Management Mcq Set 4
  135. MBA Insurance and Risk Management Mcq Set 5
  136. MBA Insurance and Risk Management Mcq Set 6
  137. MBA Management Information Systems Mcq Set 1
  138. MBA Management Information Systems Mcq Set 2
  139. MBA Management Information Systems Mcq Set 3
  140. MBA Management Information Systems Mcq Set 4
  141. MBA Management Information Systems Mcq Set 5
  142. MBA Management Information Systems Mcq Set 6
  143. MBA Management Information Systems Mcq Set 7
  144. MBA Management Information Systems Mcq Set 8
  145. MBA Management Information Systems Mcq Set 9
  146. MBA Marketing Management Mcq Set 1
  147. MBA Marketing Management Mcq Set 2
  148. MBA Marketing Management Mcq Set 3
  149. MBA Marketing Management Mcq Set 4
  150. MBA Marketing Management Mcq Set 5
  151. MBA Marketing Management Mcq Set 6
  152. MBA Marketing Management Mcq Set 7
  153. MBA Marketing Management Mcq Set 8
  154. MBA Marketing Management Mcq Set 9
  155. MBA Marketing Management Mcq Set 10
  156. MBA Marketing Management Mcq Set 11
  157. MBA Marketing Management Mcq Set 12
  158. MBA Marketing Management Mcq Set 13
  159. MBA Media Planning Mcq Set 1
  160. MBA Media Planning Mcq Set 2
  161. MBA Media Planning Mcq Set 3
  162. MBA Media Planning Mcq Set 4
  163. MBA Operations Research Mcq Set 1
  164. MBA Operations Research Mcq Set 2
  165. MBA Operations Research Mcq Set 3
  166. MBA Operations Research Mcq Set 4
  167. MBA Operations Research Mcq Set 5
  168. MBA Organisational Behavior Mcq Set 1
  169. MBA Organisational Behavior Mcq Set 2
  170. MBA Organisational Behavior Mcq Set 3
  171. MBA Organisational Behavior Mcq Set 4
  172. MBA Principles and Practices of Management Mcq Set 1
  173. MBA Principles and Practices of Management Mcq Set 2
  174. MBA Principles and Practices of Management Mcq Set 3
  175. MBA Principles and Practices of Management Mcq Set 4
  176. MBA Principles and Practices of Management Mcq Set 5
  177. MBA Principles and Practices of Management Mcq Set 6
  178. MBA Principles and Practices of Management Mcq Set 7
  179. MBA Principles and Practices of Management Mcq Set 8
  180. MBA Principles and Practices of Management Mcq Set 9
  181. MBA Production and Operations Management Mcq Set 1
  182. MBA Production and Operations Management Mcq Set 2
  183. MBA Production and Operations Management Mcq Set 3
  184. MBA Production and Operations Management Mcq Set 4
  185. MBA Production and Operations Management Mcq Set 5
  186. MBA Production and Operations Management Mcq Set 6
  187. MBA Production and Operations Management Mcq Set 7
  188. MBA Production and Operations Management Mcq Set 8
  189. MBA Production and Operations Management Mcq Set 9
  190. MBA Production and Operations Management Mcq Set 10
  191. MBA System Analysis and Design Mcq Set 1
  192. MBA System Analysis and Design Mcq Set 2
  193. MBA System Analysis and Design Mcq Set 3
  194. MBA System Analysis and Design Mcq Set 4
  195. MBA System Analysis and Design Mcq Set 5
  196. MBA System Analysis and Design Mcq Set 6
  197. MBA System Analysis and Design Mcq Set 7
  198. MBA System Analysis and Design Mcq Set 8
  199. MBA System Analysis and Design Mcq Set 9
  200. MBA Total Quality Management Mcq Set 1
  201. MBA Total Quality Management Mcq Set 2
  202. MBA Total Quality Management Mcq Set 3
  203. MBA Total Quality Management Mcq Set 4
  204. MBA Total Quality Management Mcq Set 5
  205. MBA Total Quality Management Mcq Set 6
  206. MBA Total Quality Management Mcq Set 7
  207. MBA Total Quality Management Mcq Set 8
Learn MBA System Analysis and Design Mcq Set 5,Learn MBA Objetive choice questions and answers,MBA Multiple choice questions and answers,MBA objective, MBA questions , MBA answers,MBA MCQs questions and answer
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!