Question 1

Which is not an example of a strong entity type?

Accepted Answer

A) Course 
B) Department 
C) Student_Id 
D) Student C

Question 2

An attribute which consists of a group of attributes is called ______?

Accepted Answer

A) Composite attributes 
B) Multi-valued attributes 
C) Composite identifiers 
D) Identifiers A

Question 3

Databases overall structure is maintained in a file called

Accepted Answer

A) Control file 
B) Data file 
C) Redolog file 
D) None of these C

Question 4

Managers who are potential users of the MIS

Accepted Answer

A) Describe information needs 
B) Identify alternate equipment configurations 
C) Evaluate alternate equipment configurations 
D) Select the optimum equipment configurations

Question 5

An application where only one user accesses the database at a given time is an example of a(n)___

Accepted Answer

A) Single-user database application 
B) Multiuser database application 
C) E-commerce database application 
D) Data mining database application

Question 6

In an E-R diagram a relationship is represented by________?

Accepted Answer

A) Ellipse 
B) Rectangle 
C) Rectangle with rounded corners 
D) Diamond

Question 7

A meaningful association between entity types is _______?

Accepted Answer

A) Relationship type 
B) Entity identifier 
C) Relationship instance 
D) Associative entity

Question 8

Which is not included in the definition of an entity?

Accepted Answer

A) Person 
B) Object 
C) Concept 
D) Action

Question 9

A tuple is a

Accepted Answer

A) row of a table 
B) key of a table 
C) column of a table 
D) two-dimensional table

Question 10

Which one of the following is not a business driver for an information system?

Accepted Answer

A) business process redesign 
B) knowledge asset management 
C) proliferation of networks and the Internet 
D) security and privacy

Question 11

An information system that supports the planning and assessment needs of executive management is

Accepted Answer

A) DSS 
B) TPS 
C) MIS 
D) None of the above

Question 12

In an E-R diagram an ellipse represents________?

Accepted Answer

A) Weak entity 
B) Relationship 
C) Attribute 
D) Entity class

Question 13

The following are components of a database except _____

Accepted Answer

A) reports 
B) indexes 
C) metadata 
D) user data

Question 14

In an E-R diagram double rectangle represents _______?

Accepted Answer

A) Entity class 
B) Weak entity 
C) Relationship 
D) Attribute

Question 15

An example of a multi-valued attribute might be ______?

Accepted Answer

A) Student_Address 
B) College_Degree 
C) Student_GPA 
D) ID_Number

Question 16

When data changes in multiple lists and all lists are not updated, this causes

Accepted Answer

A) Data redundancy 
B) Data inconsistency 
C) Duplicate data 
D) Information overload

Exam 3: Information Systems and Software Development Models