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

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

## 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

3.decimal numerical codes

4.serial number codes

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

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

1.100

2.0 to 100

3.- 99 to +99

4.99

1.12

2.-12 to 12

3.1 to 12

4.0 to 12

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`

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

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

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

1.9

2.10

3.11

4.99

1.90

2.60

3.180

4.360

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

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

3.select one out of many alternatives often by a mouse click

4.detect errors in data input

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

## 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

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

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

##### 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!