Question 1

When data changes in multiple lists and all lists are not updated, this causes
A)Data redundancy
B)Data inconsistency
C)Duplicate data
D)Information overload

Accepted Answer

Data inconsistency occurs when data changes in multiple lists and all lists are not updated. This can lead to errors and confusion, as users may not be sure which list contains the most up-to-date information.

Question 2

An application where only one user accesses the database at a given time is an example of a(n)___
A)Single-user database application
B)Multiuser database application
C)E-commerce database application
D)Data mining database application

Accepted Answer

Single-user database applications are designed for scenarios where only one user accesses the database at a time, making choice A the correct answer.

Question 3

Databases overall structure is maintained in a file called
A)Control file
B)Data file
C)Redolog file
D)None of these

Accepted Answer

C

Question 4

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

Accepted Answer

A tuple in the context of databases is a row of a table, representing a single record.

Question 5

The following are components of a database except _____
A)reports
B)indexes
C)metadata
D)user data

Accepted Answer

The answer of The following are components of a database...

Question 6

In an E-R diagram double rectangle represents _______?
A)Entity class
B)Weak entity
C)Relationship
D)Attribute

Accepted Answer

A double rectangle in an E-R diagram represents a Weak Entity, which is an entity that cannot be uniquely identified by its own attributes alone and typically depends on a strong entity through a foreign key.

Question 7

In an E-R diagram an ellipse represents________?
A)Weak entity
B)Relationship
C)Attribute
D)Entity class

Accepted Answer

In an E-R (Entity-Relationship) diagram, an ellipse is used to represent an attribute, which is a property or characteristic of an entity or relationship.

Question 8

In an E-R diagram a relationship is represented by________?
A)Ellipse
B)Rectangle
C)Rectangle with rounded corners
D)Diamond

Accepted Answer

In an Entity-Relationship (E-R) diagram, a relationship is represented by a diamond shape. This notation is used to depict how entities relate to each other within the system.

Question 9

An attribute which consists of a group of attributes is called ______?
A)Composite attributes
B)Multi-valued attributes
C)Composite identifiers
D)Identifiers

Accepted Answer

Composite attributes are those that can be divided into smaller sub-parts, which represent more basic attributes with independent meanings.

Question 10

Which is not included in the definition of an entity?
A)Person
B)Object
C)Concept
D)Action

Accepted Answer

The answer of Which is not included in the definition...

Question 11

Which is not an example of a strong entity type?
A)Course
B)Department
C)Student_Id
D)Student

Accepted Answer

A strong entity type is an entity that does not need any external information to identify its instances uniquely. "Student_Id" is not an entity type but an attribute, typically of the "Student" entity, used to uniquely identify instances of a student. Choices A, B, and D represent entities that can exist independently with their unique identifiers, making them strong entities.

Question 12

A meaningful association between entity types is _______?
A)Relationship type
B)Entity identifier
C)Relationship instance
D)Associative entity

Accepted Answer

The answer of A meaningful association between entity types is...

Question 13

An example of a multi-valued attribute might be ______?
A)Student_Address
B)College_Degree
C)Student_GPA
D)ID_Number

Accepted Answer

College_Degree can be considered a multi-valued attribute because a person can have multiple degrees (e.g., Bachelor's, Master's, PhD).

Question 14

An information system that supports the planning and assessment needs of executive management is
A)DSS
B)TPS
C)MIS
D)None of the above

Accepted Answer

An Executive Information System (EIS) is specifically designed to support the planning and assessment needs of executive management, not DSS, TPS, or MIS.

Question 15

Managers who are potential users of the MIS
A)Describe information needs
B)Identify alternate equipment configurations
C)Evaluate alternate equipment configurations
D)Select the optimum equipment configurations

Accepted Answer

Managers, as potential users of the Management Information System (MIS), primarily describe their information needs to ensure the system is designed to provide the necessary data for decision-making. Identifying, evaluating, and selecting equipment configurations are typically responsibilities of IT professionals and systems analysts.

Question 16

Which one of the following is not a business driver for an information system?
A)business process redesign
B)knowledge asset management
C)proliferation of networks and the Internet
D)security and privacy

Accepted Answer

The answer of Which one of the following is not...

Quiz 3: Information Systems and Software Development Models

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

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

Databases overall structure is maintained in a file called

A tuple is a

The following are components of a database except _____

In an E-R diagram double rectangle represents _______?

In an E-R diagram an ellipse represents________?

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

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

Which is not included in the definition of an entity?

Which is not an example of a strong entity type?

A meaningful association between entity types is _______?

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

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

Managers who are potential users of the MIS

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