Question 1

Explain the different DBMS products.

Accepted Answer

DBMS products fall into two broad catego

Question 2

Which of the following is not part of the database development process?

Accepted Answer

A) Interviews with users lead to database requirements. 
B) Database requirements are summarized in a data model. 
C) An external verification agency validates the data model. 
D) The database model is transformed into a database design. 
A) Interviews with users lead to database requirements. 
B) Database requirements are summarized in a data model. 
C) An external verification agency validates the data model. 
D) The database model is transformed into a database design.

Question 3

Elements of the database application system call on the database management system to process the database tables.

Accepted Answer

A) True 
 B)False

Question 4

A(n)________ is a column or group of columns that identifies a unique row in a table.

Accepted Answer

A) record 
B) key 
C) metadata 
D) attribute 
A) record 
B) key 
C) metadata 
D) attribute

Question 5

1:N,N:M,and 1:1 are common examples of minimum cardinalities.

Accepted Answer

A) True 
 B)False

Question 6

A line in an E-R diagram is used to represent the attributes of the entity.

Accepted Answer

A) True 
 B)False

Question 7

Data entry forms show data in a structured context.

Accepted Answer

A) True 
 B)False

Question 8

A data model describes the data and relationships that will be stored in the database.

Accepted Answer

A) True 
 B)False

Question 9

Metadata describes the structure of the database.

Accepted Answer

A) True 
 B)False

Question 10

Inconsistent attribute changes lead to data integrity problems.

Accepted Answer

A) True 
 B)False

Question 11

________ is an example of a personal DBMS.

Accepted Answer

A) DB2 
B) SQL Server 
C) Oracle 
D) Access 
A) DB2 
B) SQL Server 
C) Oracle 
D) Access

Question 12

Which of the following is not an example of a database product?

Accepted Answer

A) Oracle 
B) MySQL 
C) Ubuntu 
D) Access 
A) Oracle 
B) MySQL 
C) Ubuntu 
D) Access

Question 13

Application programs enable database processing over the Internet.

Accepted Answer

A) True 
 B)False

Question 14

Microsoft's SQL Server is an example of a personal DBMS product.

Accepted Answer

A) True 
 B)False

Question 15

Instead of using SQL to code queries to the DBMS,an application program can be used to query the DBMS directly.

Accepted Answer

A) True 
 B)False

Question 16

The data ________ describes the data and relationships that will be stored in the database.

Accepted Answer

A) mine 
B) model 
C) function 
D) segment 
A) mine 
B) model 
C) function 
D) segment

Question 17

Storing the attribute of an entity just once eliminates data inconsistencies.

Accepted Answer

A) True 
 B)False

Question 18

How does normalization resolve the data integrity problem?

Accepted Answer

Database design is the process of conver

Question 19

Bytes are grouped into columns,which in turn are grouped into ________.

Accepted Answer

A) rows 
B) fields 
C) files 
D) bits 
A) rows 
B) fields 
C) files 
D) bits

Question 20

Locking to coordinate the activities of users who know nothing of one another is used to prevent the lost-update problem.

Accepted Answer

A) True 
 B)False

Explain the different DBMS products.

Which of the following is not part of the database development process?

Elements of the database application system call on the database management system to process the database tables.

A(n)________ is a column or group of columns that identifies a unique row in a table.

1:N,N:M,and 1:1 are common examples of minimum cardinalities.

A line in an E-R diagram is used to represent the attributes of the entity.

Data entry forms show data in a structured context.

A data model describes the data and relationships that will be stored in the database.

Metadata describes the structure of the database.

Inconsistent attribute changes lead to data integrity problems.

________ is an example of a personal DBMS.

Which of the following is not an example of a database product?

Application programs enable database processing over the Internet.

Microsoft's SQL Server is an example of a personal DBMS product.

Instead of using SQL to code queries to the DBMS,an application program can be used to query the DBMS directly.

The data ________ describes the data and relationships that will be stored in the database.

Storing the attribute of an entity just once eliminates data inconsistencies.

How does normalization resolve the data integrity problem?

Bytes are grouped into columns,which in turn are grouped into ________.

Locking to coordinate the activities of users who know nothing of one another is used to prevent the lost-update problem.

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

Explain the different DBMS products.

Which of the following is not part of the database development process?

Elements of the database application system call on the database management system to process the database tables.

A(n)________ is a column or group of columns that identifies a unique row in a table.

1:N,N:M,and 1:1 are common examples of minimum cardinalities.

A line in an E-R diagram is used to represent the attributes of the entity.

Data entry forms show data in a structured context.

A data model describes the data and relationships that will be stored in the database.

Metadata describes the structure of the database.

Inconsistent attribute changes lead to data integrity problems.

________ is an example of a personal DBMS.

Which of the following is not an example of a database product?

Application programs enable database processing over the Internet.

Microsoft's SQL Server is an example of a personal DBMS product.

Instead of using SQL to code queries to the DBMS,an application program can be used to query the DBMS directly.

The data ________ describes the data and relationships that will be stored in the database.

Storing the attribute of an entity just once eliminates data inconsistencies.

How does normalization resolve the data integrity problem?

Bytes are grouped into columns,which in turn are grouped into ________.

Locking to coordinate the activities of users who know nothing of one another is used to prevent the lost-update problem.

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