BCIS 4620 chapter 1 practice quiz questions, CH 2 DATA MODELS 4620, BCIS 4620 ch 3 , Chapter 4 BCIS 4620 DB APPLICATION, ch 5 4620, ch 6 4620

A(n) _____ might be written by a programmer or it might be created through a DBMS utility program.

query

operating system

database management system

application

Application

Data is said to be verifiable if:

the data is obtained from trusted sources.

the data cannot be changed or manipulated.

the data is stored in different places within the database.

the data always yields consistent results.

the data always yields consistent results.

A _____ is a collection of related records.

field

column

schema

file

file

A _____ is a character or group of characters that has a specific meaning.

record

database

field

file

field

End-user data is _____.

accurate, relevant and timely information

knowledge about the end users

information about a specific subject

raw facts of interest to the end user

raw facts of interest to the end user

An advantage of database systems is that you needn't perform frequent updates and apply latest patches.

False

True

False

The only way to access the data in a database is through the DBMS.

True

False

True

Which of the following refers to the situation where different versions of the same data are stored at different places because they weren't updated consistently?

Data redundancy

Data dictionary

Data integrity

Data query

Data Dedundancy

_____ data exist in the format in which they were collected.

Historical

Semistructured

Unstructured

Structured

Unstructured

_____ is the result of revealing the meaning of raw facts.

An encrypted bit

End-user data

Information

An encoded sample

Information

Data constitute the building blocks of information.

False

True

True

_____ is the body of information and facts about a specific subject.

Knowledge

A database

A format

Validation

Knowledge

_____ are the result of formatting disorganized data in order to facilitate storage, use and generation of information.

Raw data

Structured data

Obsolete data

Unstructured data

Structured data

Corporations use only structured data.

False

True

False

An advantage of database systems is that you needn't (need not/not necessary) perform frequent updates and apply latest patches.

True

False

False

Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests.

False

True

False

_____ data exist in the format in which they were collected.

Historical

Structured

Semistructured

Unstructured

Unstructured

Data is the result of processing raw facts to reveal its meaning.

False

True

False

Most data that can be encountered are best classified as _____.

historical

structured

semistructured

unstructured

semistructured

The DBMS reveals much of the database's internal complexity to the application programs and users.

True

False

False

Field refers to a collection of related records.

True

False

False

One disadvantage of the DBMS is that it increases the risk of data security breaches.

True

False

False

A data warehouse can store data derived from many sources.

False

True

True

Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.

True

False

False

Which of the following is true of spreadsheet applications?

They enhance the user's ability to understand the data.

They do not allow manipulation of data once entered.

They provide enhanced security and robust data sharing features.

They are a better alternative to databases.

They enhance the user's ability to understand the data.

The term _____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.

database system

structured data

management system

transaction

Database system

A desktop database is a _____ database.

distributed

workgroup

multiuser

single-user

single-user

Accurate, relevant, and timely information is the key to ____.

knowledge

understanding

data management

good decision making

good decision making

A(n) _____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.

desktop

enterprise

workgroup

transactional

workgroup

Metadata describe the data characteristics and the set of relationships that links the data found within the database.

True

False

True

A(n) _____ database is used by an organization and supports many users across many departments.

enterprise

desktop

transactional

workgroup

enterprise

A data warehouse contains historical data obtained from the _____.

enterprise databases

operational databases

workgroup databases

desktop database

operational databases

_____ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed.

Performance tuning

Database design

Query access

Database management

Performance tuning

An operational database is sometimes referred to as an enterprise database.

True

False

False

The organization of data within folders in a manual file system is determined by _______.

its date of creation

its expected use

the title of the documents in the folder

the data processing specialist

its expected use

Metadata describe the data characteristics and the set of relationships that links the data found within the database.

True

False

True

The response of the DBMS to a query is the ___________

ad hoc query

integrated view of the data

query result set

ad hoc response

query result set

One disadvantage of a database system over previous data management approaches is increased costs.

False

True

True

A data warehouse contains historical data obtained from the _____.

operational databases

desktop database

workgroup databases

enterprise databases

Operational Database

Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.

True

False

False

A workgroup database is a(n) _____ database.

distributed

desktop

multiuser

single-user

multiuser

An XML database supports the storage and management of _____ XML data.

multistructured

fullystructured

semistructured

structured

semistructured

One advantage of a database system over previous data management approaches is that the database system is considerably less complex.

True

False

False

Data processing can be as simple as organizing data to reveal patterns.

False

True

True

A data warehouse can store data derived from many sources.

True

False

True

Data and information are essentially the same thing.

True

False

False

_____ provide a description of the data characteristics and the set of relationships that link the data found within the database.

Queries

Schemas

End-user data

Metadata

Metadata

When data are entered into a form and saved, they are placed in the underlying database as knowledge.

False

True

False

_____ is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.

Data anomaly

Data integrity

Data ubiquity

Data quality

Data integrity

_____ data exist in a format that does not lend itself to processing that yields information.

Unstructured

Historical

Semistructured

Structured

Unstructured

Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user.

TRUE

FALSE

false

In Chen notation, entities and relationships have to be oriented horizontally; not vertically.

False

True

False

Today, most relational database products can be classified as object/relational.

True

False

True

The object-oriented data model was developed in the _____.

1960s

1980s

1990s

1970s

1980s

In the _____ model, each parent can have many children, but each child has only one parent.

entity relationship

relational

network

hierarchical

hierarchical

A(n) _____ represents a particular type of object in the real world.

attribute

relationship

node

entity

entity

In an SQL-based relational database, each table is dependent on every other table.

True

False

False

Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain.

False

True

True

Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories.

True

False

False

An implementation-ready data model should contain a description of the data structure that will store the end-user data.

False

True

True

A data model is usually graphical.

True

False

True

In the _____ model, the basic logical structure is represented as an upside-down tree.

relational

entity relationship

hierarchical

network

hierarchical

A(n) _____ is the equivalent of a field in a file system.

relationship

entity

constraint

attribute

attribute

A(n) _____ is anything about which data are to be collected and stored.

relationship

entity

constraint

attribute

Entity

VMS/VSAM is an example of the _____.

XML data model

hierarchical model

file system data model

relational data model

file system data model

Which of the following types of HDFS nodes stores all the metadata about a file system?

Client node

Map node

Name node

Data node

Name node

A(n) _____ is bidirectional.

attribute

relationship

constraint

entity

relationship

A verb associating two nouns in a business rule translates to a(n) _____ in the data model.

constraint

relationship

attribute

entity

relationship

A(n) _______ enables a database administrator to describe schema components.

extensible markup language (XML)

data definition language (DDL)

query language

unified modeling language (UML)

data definition language (DDL)

MySQL is an example of the _____.

file system data model

hierarchical model

relational data model

XML data model

relational data model

The external model is the representation of the database as "seen" by the DBMS.

True

False

False

The network model has structural level dependence.

False

True

True

M:N relationships are not appropriate in a relational model.

True

False

True

Which of the following is true of NoSQL databases?

They do not support very large amounts of sparse data.

They are not based on the relational model.

They are geared toward transaction consistency rather than performance.

They do not support distributed database architectures.

They are not based on the relational model.

The hierarchical model is software-independent.

True

False

False

_____ are important because they help to ensure data integrity.

Constraints

Attributes

Relationships

Entities

Constraints

The _____ data model is said to be a semantic data model.

network

entity relationship

relational

object-oriented

object-oriented

A(n) _____'s main function is to help one understand the complexities of the real-world environment.

entity

model

node

database

Model

The _____ data model uses the concept of inheritance.

entity relationship

object-oriented

relational

network

object-oriented

The hierarchical data model was developed in the _____.

1960s

1980s

1970s

1990s

1960s

MySQL is an example of the _____.

file system data model

relational data model

XML data model

hierarchical model

relational data model

A(n) _____ enables a database administrator to describe schema components.

extensible markup language (XML)

query language

unified modeling language (UML)

data definition language (DDL)

data definition language (DDL)

A noun in a business rule translates to a(n) _____ in the data model.

attribute

relationship

entity

constraint

entity

The relational data model was developed in the _____.

1970s

1980s

1960s

1990s

1970s

The hierarchical model is software-independent.

False

True

False

The _____ data model uses the concept of inheritance.

entity relationship

network

object-oriented

relational

object-oriented

Students and classes have a _____ relationship.

many-to-many

one-to-many

one-to-one

many-to-one

many-to-many

The hierarchical data model was developed in the _____.

1970s

1960s

1990s

1980s

1960s

In the _____ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.

hierarchical

network

object-oriented

entity relationship

network

Which of the following is true of business rules?

They can serve as a communication tool between the users and designers.

They provide a framework for the company's self-actualization.

They allow the designer to develop business processes.

They allow the designer to set company policies with regard to data.

They can serve as a communication tool between the users and designers.

Each row in the relational table is known as an entity instance or entity occurrence in the ER model.

False

True

true

In an SQL-based relational database, rows in different tables are related based on common values in common attributes.

False

True

True

The _____ model uses the term connectivity to label the relationship types.

relational

entity relationship

network

object-oriented

entity relationship

A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user.

False

True

False

Oracle 12c, MS SQL Server, and Tamino are examples of _____ data models.

file system

relational

hierarchical

XML Hybrid

relational

The relational model is hardware-dependent and software-independent.

True

False

False

Today, most relational database products can be classified as object/relational.

True

False

True

Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS?

Name node

Data node

Map node

Client node

Client node

Database designers determine the data and information that yield the required understanding of the entire business.

False

True

True

In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored.

False

True

True