[MC][TF][SA] Information Management - The Database Environment and Development Process

Question Type: Multiple Choice

A Text is an example of what kind of data?

A. Characters

B. Structured Data

C. Document

D. Unstructured Data

B. Structured Data

Question Type: True False

A metadata is a data that characterizes the properties and context of user data.

True

Question Type: True False

In program data dependency, each application program needs to include code for the metadata of each file.

True

Question Type: Multiple Choice

What is an element of the database approach wherein it is composed of attributes and it's a noun form describing a person, place, object or concept?

A. Entities

B. Relational database

C. Relationships

D. Data Models

A. Entities

Question Type: Multiple Choice

What do you call the people who use the applications and the database?

A. End users

B. Software developers

C. User Interface

D. Data Administrators

A. End users

Question Type: Multiple Choice

What is the centralized storehouse of metadata?

A. DBMS

B. Repository

C. Database

D. CASE tools

B. Repository

Question Type: True False

Inconsistencies are always found in a database approach.

False

Question Type: True False

Maintenance in database approach causes more maintenance headaches.

False

Question Type: True False

One of the costs in database approach is hiring new and specialized personnel to manage the DBMS.

True

Question Type: Multiple Choice

What is an element of a database approach that is between entities?

A. Connection

B. Relationships

C. Between element

D. Database

B. Relationships

Question Type: True False

The database activity of the physical design in SDLC is defining the database to DBMS, physical data organization, and database processing programs.

True

Question Type: True False

The purpose of the physical design step in SDLC is develop technology and organizational specifications.

True

Question Type: True False

SDLC is a long development cycle.

True

Question Type: True False

Operational programs, documentation and training materials are the deliverables of the maintenance step in SDLC.

True

Question Type: True False

Operational programs, documentation and training materials are the deliverables of the implementation step in SDLC.

False

Question Type: True False

Projects are initiated and planned during the maintenance stage of SDLC.

False

Question Type: True False

A data warehouse is an integrated decision support system derived from various operational databases.

True

Question Type: Multiple Choice

Which among the following became a legacy system during the 1990s?

A. object-relational

B. Object-oriented

C. Network

D. Data Warehousing

C. Network

Question Type: Multiple Choice

In a three tiered client server database architecture, what is the database that contains all organizational data or summaries of data on department servers

A. transaction

B. browser

C. client tier

D. web tier

A. transaction

Question Type: True False

The purpose of Planning in SDLC is the preliminary understanding of what the system is.

True

Question Type: Multiple Choice

Which among the attribute of both entities is mutivalued?

A. Symptom

B. Address

C. DoctorId

D. Birthday

A. Symptom

Question Type: Multiple Choice

What is an entity that is a combination of relationship and entity?

A. Double Entity

B. EntiRel

C. Associative Entity

D. Combined Entity

C. Associative Entity

Question Type: True False

A relationship instance is the link between entities.

True

Question Type: True False

A required attribute must contain no value for every entity.

False

Question Type: True False

There may be a value for every entity in an optional attribute.

True

Question Type: Multiple Choice

What is a type of attribute that may take on more than one value for a given entity instance?

A. Derived

B. Multivalued

C. Simple

D. Composite

B. Multivalued

Question Type: Multiple Choice

What is a type of attribute whose values can be calculated from related attribute value?

A. Multivalued

B. Composite

C. Derived

D. Required

C. Derived

Question Type: True False

All relationships for the associative entity should be many.

True

Question Type: Multiple Choice

Given the choices, which among the following is a disadvantage of file processing wherein programmers must design their own formats?

A. Limited data sharing

B. Program-data dependence

C. Excessive Program Maintenance

D. Lengthy Development times

D. Lengthy Development times

Question Type: Multiple Choice

Which among the following is not an advantage of a database approach?

A. Lack of standards

B. Program data independence

C. Improved data consistency

D. Reduction of program maintenance

A. Lack of standards

Question Type: Multiple Choice

What is a component of a database environment that is the storehouse of the data?

A. Repository

B. Application Programs

C. User Interface

D. Database

D. Database

Question Type: Multiple Choice

They are the personnel that is responsible for designing databases and software.

A. Database administrators

B. End users

C. System developers

D. Application Programs

C. System developers

Question Type: True False

The waste of space caused by having duplicate data is a challenge with database approaches.

False

Question Type: True False

Enforcing of standards is applied in file processing approach.

False

Question Type: Multiple Choice

What is a data model that has a more detailed view and matching data structure in the database or data warehouse?

A. Project data model

B. Enterprise data model

C. Database technology attributes

D. Relational database

A. Project data model

Question Type: Multiple Choice

What is the storehouse for metadata?

A. End users

B. Database

C. Repository

D. CASE tools

C. Repository

Question Type: Multiple Choice

What is the step in SDLC that its purpose is a thorough requirements analysis and structuring the system?

A. Logical Design

B. Analysis

C. Implementation

D. Planning

B. Analysis

Question Type: True False

The database activity of the logical design step in SDLC is the logical database design.

True

Question Type: True False

Develop the technology and organizational specifications is the purpose of the Physical Design in SDLC.

True

Question Type: True False

The internal schema of the database involves the logical and physical structures of the database.

True

Question Type: Multiple Choice

SDLC stands for what?

A. System Delivering Low Cycle

B. System Direct Life Cycle

C. System Development Life Cycle

D. Solid Development Life Cycle

C. System Development Life Cycle

Question Type: Multiple Choice

What is the database application that integrates all enterprise functions (manufacturing, finance, sales, marketing, inventory, accounting, human resources)?

A. Support System Integrated

B. Data Warehouse

C. Entity Relationship Plan

D. Enterprise Resource Planning

D. Enterprise Resource Planning

Question Type: True False

Information requirement elicitation and structure is the purpose of the logical design in SDLC.

True

Question Type: True False

The degree of the relationship is the number of entity types that participate in a relationship.

True

Question Type: True False

A required attribute must have a value for every entity.

True

Question Type: True False

A composite attribute has meaningful component parts.

True

Question Type: True False

Attributes that contains data that will change overtime is the best attribute for an identifier.

False

Question Type: True False

Entities of two different types related to each other is a binary degree of relationship.

True

Question Type: Multiple Choice

What is a disadvantage of file processing wherein different systems/ programs have separate copies of the same data?

A. Excessive program maintenance

B. Lengthy development times

C. Duplication of data

D. Limited Data sharing

C. Duplication of data

Question Type: Multiple Choice

The biggest problem in data redundancy is changes in one file could cause inconsistencies. This problem compromises what?

A. Data integrity

B. Perfect Maintenance

C. Data evaluation

D. Data

A. Data integrity

Question Type: True False

The database approach is a central repository of shared data and data is managed by a controlling agent.

True

Question Type: Multiple Choice

What is an element of a database approach that is a noun form describing a person, place, object, event, or concept?

A. Attribute

B. Relationship

C. Relational database

D. Entity

D. Entity

Question Type: True False

One of the costs in database approach is the conversion costs.

True

Question Type: True False

Enterprise modeling and early conceptual data modeling are the database activity during the planning stage of SDLC.

True

Question Type: True False

E-R models are found in the conceptual schema of the database.

True

Question Type: True False

The database administrator determines the schema for each different users.

True

Question Type: True False

The external schema shows that different people have different views of the database.

True

Question Type: True False

The internal schema is the underlying design and implementation of the database.

False

Question Type: True False

During the planning stage of SDLC, the database activity here is a thorough and integrated conceptual data modeling.

False

Question Type: Multiple Choice

These are the or characteristics of an entity or relationship type.

A. Media

B. Relationship

C. Entities

D. Attributes

D. Attributes

Question Type: Multiple Choice

What is the number of instances of one entity that can be associated with each instance of another entity?

A. Associative Numbering

B. Cardinality

C. Instance Numbering

D. Degree of the relationship

B. Cardinality

Question Type: True False

Relationship degrees specify how many of each entity type is allowed.

False

Question Type: True False

An associative entity is like a relationship with an attribute, but it is also considered to be an entity in its own right.

True

Question Type: Multiple Choice

What is an attribute or combination of attributes that uniquely identifies individual instances of an entity type?

A. Partial Identifier

B. Combined attribute

C. Identifier

D. Composite

C. Identifier

Question Type: True False

In choosing an identifier for an entity, choose an entity that will not change in value and will not be null.

True

Question Type: True False

Entities of three different types related to each other is a ternary degree of relationship.

True

Question Type: True False

The associative entity preferably has a unique identifier, and should also have other attributes.

True

Question Type: True False

Unary relationships should be converted to associative entities.

False

Question Type: Multiple Choice

What is an organized collection of logically related data?

A. Database

B. Relation

C. Metadata

D. Tables

B. Relation

Question Type: True False

In program data dependency, there is coordination and central control of data.

False

Question Type: Multiple Choice

Which among the following is an example of an unstructured data

A. Text

B. Documents

C. Dates

D. Numbers

B. Documents

Question Type: True False

The biggest problems of file processing are inconsistencies and compromised data integrity.

True

Question Type: True False

The database approach stores a data in a standardized, convenient form.

True

Question Type: True False

Improved data sharing and improved data consistency is found in a database approach.

True

Question Type: True False

Request for study is the deliverable in the planning step of SDLC.

True

Question Type: True False

Database activity in the maintenance step of SDLC involves database maintenance, performance analysis, and tuning and error tuning.

True

Question Type: True False

The purpose of maintenance in SDLC is to monitor, repair and enhance the system.

True

Question Type: True False

The deliverable of the logical design of SDLC is the detailed design specification.

True

Question Type: Multiple Choice

What is the relationship that links strong entities to weak entities?

A. Combined relationship

B. Identifying relationship

C. Associative relationship

D. strongweak relationship

B. Identifying relationship

Question Type: True False

Entities of three different types related to each other is a binary degree of relationship.

False

Question Type: True False

Multivalued attributes can be represented as relationships.

True

Question Type: True False

A ternary relationship should be converted to an associative entity.

True

Question Type: Multiple Choice

Expand the words in CASE.

A. Computer Architecture Software Enterprise

B. Computer-aided software engineering

C. Computer Aided Solid Engineering

D. Computer Artists Strong Enterprise

B. Computer-aided software engineering

Question Type: Multiple Choice

What example software uses data in a database environment?

A. Repository

B. User Interface

C. Database

D. Application Programs

D. Application Programs

Question Type: Multiple Choice

What are a graphical system that captures the nature and relationship of data?

A. Relational Databases

B. Data models

C. Entities

D. Captured data

B. Data models

Question Type: True False

An SDLC approach to the database has a repeated implementation and maintenance of activities with a new prototype version.

False

Question Type: True False

The deliverable of the physical design in SDLC is the program/data structures, technology purchases, and organization redesigns.

True

Question Type: True False

New requirements is always applied to the revised and enhanced prototype in RAD.

True

Question Type: Multiple Choice

Which schema in the database consists of the user views?

A. Conceptual Schema

B. Internal Schema

C. External Schema

C. External Schema

Question Type: True False

Implementation and maintenance activities are done repetitively with new prototype versions.

True

Question Type: True False

A dependent entity is another name for weak entity.

True

Question Type: True False

Perfect identifiers are the attributes that contain locations.

False

Question Type: True False

The associative entity could have meaning independent of the other entities.

True

Question Type: True False

One of the problems with data redundancy is the waste of space because of duplicate data.

True

Question Type: True False

Data types, field sizes, allowable values, and data context are included in metadata.

True

Question Type: True False

Converting to an operational system in RAD usually means database maintenance.

True

Question Type: True False

E-R models are found in the internal schema of the database.

False

Question Type: Multiple Choice

Which among the following is the first step in SDLC?

A. Planning

B. Maintenance

C. Logical design

D. Implementation

A. Planning

Question Type: Multiple Choice

This cardinality of relationships is an entity in the relationship will have exactly one related entity.

A. one to one

B. one to many

C. many to many

A. one to one

Question Type: Short Answer

What do you call a planned execution of related tasks to accomplish a goal with a start and finish?

Project