Question 1

Normalization is the only criterion for evaluating database designs.

Accepted Answer

A) True 
 B)False  False

Question 2

A DBMS is a software that helps manage the operating system.

Accepted Answer

A) True 
 B)False  False

Question 3

One of the functions of a DBMS is to provide tools to assist in the administration of the database.

Accepted Answer

A) True 
 B)False  True

Question 4

Many-to-many relationships are notated as ________ relationships.

Accepted Answer

A) N:N 
B) 1:N 
C) M:1 
D) N:M 
A) N:N 
B) 1:N 
C) M:1 
D) N:M

Question 5

Which of the following is true of N:M relationships?

Accepted Answer

A) They are common examples of minimum cardinalities. 
B) They are also called one-to-many relationships. 
C) The number of entities on each side cannot be different. 
D) More than one entity is allowed on each side of the relationship. 
A) They are common examples of minimum cardinalities. 
B) They are also called one-to-many relationships. 
C) The number of entities on each side cannot be different. 
D) More than one entity is allowed on each side of the relationship.

Question 6

In a database system,a ________ is the smallest piece of data.

Accepted Answer

A) field 
B) record 
C) byte 
D) file 
A) field 
B) record 
C) byte 
D) file

Question 7

What are crow's feet?

Accepted Answer

A) shorthand for multiple lines showing relations between two entities in an E-R diagram 
B) a sequence describing the divergent data packets leading to different databases 
C) the last entry in the data model which generates mini-reports 
D) the entry and exit points in a data model 
A) shorthand for multiple lines showing relations between two entities in an E-R diagram 
B) a sequence describing the divergent data packets leading to different databases 
C) the last entry in the data model which generates mini-reports 
D) the entry and exit points in a data model

Question 8

Pure database data are more useful if they are in raw form.

Accepted Answer

A) True 
 B)False

Question 9

Minimum cardinalities are ________.

Accepted Answer

A) attributes identified with only one entity 
B) minimum requirements on the number of entities 
C) crow's feet notations showing the least number of relationships 
D) the lowest possible data attributes in an entity 
A) attributes identified with only one entity 
B) minimum requirements on the number of entities 
C) crow's feet notations showing the least number of relationships 
D) the lowest possible data attributes in an entity

Question 10

________ process logic that is specific to a given business need.

Accepted Answer

A) Data forms 
B) Queries 
C) Application programs 
D) System logs 
A) Data forms 
B) Queries 
C) Application programs 
D) System logs

Question 11

SQL is an international standard language for processing a database.

Accepted Answer

A) True 
 B)False

Question 12

When transforming a data model into a database design,designers represent relationships by ________.

Accepted Answer

A) using primary keys 
B) using foreign keys 
C) using the entity identifier 
D) applying attributes 
A) using primary keys 
B) using foreign keys 
C) using the entity identifier 
D) applying attributes

Question 13

A(n)________ DBMS is designed to process large organizational and workgroup databases.

Accepted Answer

A) network 
B) object-oriented 
C) enterprise 
D) relational 
A) network 
B) object-oriented 
C) enterprise 
D) relational

Question 14

A DBMS is a a collection of tables,relationships,and metadata.

Accepted Answer

A) True 
 B)False

Question 15

A column is also referred to as a record.

Accepted Answer

A) True 
 B)False

Question 16

The purpose of a database is to keep track of things that involve a single theme.

Accepted Answer

A) True 
 B)False

Question 17

Adjustments to a database should be done before the modeling stage,as they cannot be done at or after this stage.

Accepted Answer

A) True 
 B)False

Question 18

Every table in a relational database must have a key.

Accepted Answer

A) True 
 B)False

Question 19

Constraints on the number of entities are called ________ cardinalities.

Accepted Answer

A) maximum 
B) minimum 
C) restrictive 
D) constraining 
A) maximum 
B) minimum 
C) restrictive 
D) constraining

Question 20

Database requirements are assessed through data gaps identified by the database developers.

Accepted Answer

A) True 
 B)False

Normalization is the only criterion for evaluating database designs.

A DBMS is a software that helps manage the operating system.

One of the functions of a DBMS is to provide tools to assist in the administration of the database.

Many-to-many relationships are notated as ________ relationships.

Which of the following is true of N:M relationships?

In a database system,a ________ is the smallest piece of data.

What are crow's feet?

Pure database data are more useful if they are in raw form.

Minimum cardinalities are ________.

________ process logic that is specific to a given business need.

SQL is an international standard language for processing a database.

When transforming a data model into a database design,designers represent relationships by ________.

A(n)________ DBMS is designed to process large organizational and workgroup databases.

A DBMS is a a collection of tables,relationships,and metadata.

A column is also referred to as a record.

The purpose of a database is to keep track of things that involve a single theme.

Adjustments to a database should be done before the modeling stage,as they cannot be done at or after this stage.

Every table in a relational database must have a key.

Constraints on the number of entities are called ________ cardinalities.

Database requirements are assessed through data gaps identified by the database developers.

The Importance of Mis

Collaboration Information Systems

Information Systems for Competitive Advantage

Hardware and Software

Data Communications

How the Internet Works

Business Process Management

E-Commerce and Web 2.0

Business Intelligence Systems

Managing Development

Information Systems Management

Information Security Management

International Dimension 1 - the Global Economy

International Dimension 2 - Global Communication

International Dimension 3 - Global Is and the Value Chain

International Dimension 4 - International It Management and Development

Filters

Exam 5: Database Processing

Normalization is the only criterion for evaluating database designs.

A DBMS is a software that helps manage the operating system.

One of the functions of a DBMS is to provide tools to assist in the administration of the database.

Many-to-many relationships are notated as ________ relationships.

Which of the following is true of N:M relationships?

In a database system,a ________ is the smallest piece of data.

What are crow's feet?

Pure database data are more useful if they are in raw form.

Minimum cardinalities are ________.

________ process logic that is specific to a given business need.

SQL is an international standard language for processing a database.

When transforming a data model into a database design,designers represent relationships by ________.

A(n)________ DBMS is designed to process large organizational and workgroup databases.

A DBMS is a a collection of tables,relationships,and metadata.

A column is also referred to as a record.

The purpose of a database is to keep track of things that involve a single theme.

Adjustments to a database should be done before the modeling stage,as they cannot be done at or after this stage.

Every table in a relational database must have a key.

Constraints on the number of entities are called ________ cardinalities.

Database requirements are assessed through data gaps identified by the database developers.

The Importance of Mis

Collaboration Information Systems

Information Systems for Competitive Advantage

Hardware and Software

Data Communications

How the Internet Works

Business Process Management

E-Commerce and Web 2.0

Business Intelligence Systems

Managing Development

Information Systems Management

Information Security Management

International Dimension 1 - the Global Economy

International Dimension 2 - Global Communication

International Dimension 3 - Global Is and the Value Chain

International Dimension 4 - International It Management and Development

Filters