Question 1

Which of the following is a popular enterprise DBMS product?

Accepted Answer

A)  Access 
B)  SQL Server 
C)  dBase 
D)  FoxPro 
A)  Access 
B)  SQL Server 
C)  dBase 
D)  FoxPro

Question 2

Explain the importance of normalization for a database.

Accepted Answer

A data integrity problem is the situatio

Question 3

An N:M relationship cannot be written as N:N, because ________.

Accepted Answer

A)  N:N is similar to 1:N relationship, which is a one-to-many relationship 
B)  N:N implies that the relationship is between two of the same kind of entity 
C)  N:N implies that there are the same number of entities on each side of the relationship 
D)  N:N implies that the relationship is within a single entity 
A)  N:N is similar to 1:N relationship, which is a one-to-many relationship 
B)  N:N implies that the relationship is between two of the same kind of entity 
C)  N:N implies that there are the same number of entities on each side of the relationship 
D)  N:N implies that the relationship is within a single entity

Question 4

The process of converting poorly structured tables into two or more well-structured tables is called ________.

Accepted Answer

A)  conversion 
B)  certification 
C)  normalization 
D)  simplification 
A)  conversion 
B)  certification 
C)  normalization 
D)  simplification

Question 5

Which of the following database administration tasks is associated with database development?

Accepted Answer

A)  monitoring database performance 
B)  monitoring backup procedures 
C)  managing configuration change 
D)  validating the data model 
A)  monitoring database performance 
B)  monitoring backup procedures 
C)  managing configuration change 
D)  validating the data model

Question 6

Enterprise DBMS products ________.

Accepted Answer

A)  support a maximum of two users 
B)  process large organizational and workgroup databases 
C)  support only a single database application 
D)  support only personal or workgroup applications 
A)  support a maximum of two users 
B)  process large organizational and workgroup databases 
C)  support only a single database application 
D)  support only personal or workgroup applications

Question 7

Application programs do not allow database processing over the Internet.

Accepted Answer

A) True 
 B)False

Question 8

________ is an international standard language for processing a database and is supported by all major DBMS products.

Accepted Answer

A)  D4 
B)  SQL 
C)  MXML 
D)  DB2 
A)  D4 
B)  SQL 
C)  MXML 
D)  DB2

Question 9

Normalization is the process of converting a poorly structured table into two or more well-structured tables.

Accepted Answer

A) True 
 B)False

Question 10

Before building a database, a developer must construct a logical representation of the database called a(n)________.

Accepted Answer

A)  flowchart 
B)  data model 
C)  algorithm 
D)  data flow diagram 
A)  flowchart 
B)  data model 
C)  algorithm 
D)  data flow diagram

Question 11

To determine processing rights/restrictions on each table and column is an important operational task of the database administrator.

Accepted Answer

A) True 
 B)False

Question 12

In entity-relationship diagrams, crow's feet indicate ________.

Accepted Answer

A)  relationships between the various items 
B)  the number of attributes each entity possesses 
C)  whether a database is single-user or multi-user 
D)  the number of applications in a database 
A)  relationships between the various items 
B)  the number of attributes each entity possesses 
C)  whether a database is single-user or multi-user 
D)  the number of applications in a database

Question 13

The database design team transforms entities into ________.

Accepted Answer

A)  normal forms 
B)  foreign keys 
C)  tables 
D)  bytes 
A)  normal forms 
B)  foreign keys 
C)  tables 
D)  bytes

Question 14

In a database, a ________ refers to a character of data.

Accepted Answer

A)  byte 
B)  form 
C)  query 
D)  key 
A)  byte 
B)  form 
C)  query 
D)  key

Question 15

The database management system is a program used to create, process, and administer a database.

Accepted Answer

A) True 
 B)False

Question 16

What is the user's role in the development of databases?

Accepted Answer

A database is a model of how the users v

Question 17

A single-user database cannot be converted to a multi-user database.

Accepted Answer

A) True 
 B)False

Question 18

Access is both a DBMS and an application development product.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is a popular DBMS product from Microsoft?

Accepted Answer

A)  PowerPoint 
B)  Outlook 
C)  Silverlight 
D)  Access 
A)  PowerPoint 
B)  Outlook 
C)  Silverlight 
D)  Access

Question 20

Explain the process of database design.

Accepted Answer

1.Representing each entity with a table

Which of the following is a popular enterprise DBMS product?

Explain the importance of normalization for a database.

An N:M relationship cannot be written as N:N, because ________.

The process of converting poorly structured tables into two or more well-structured tables is called ________.

Which of the following database administration tasks is associated with database development?

Enterprise DBMS products ________.

Application programs do not allow database processing over the Internet.

________ is an international standard language for processing a database and is supported by all major DBMS products.

Normalization is the process of converting a poorly structured table into two or more well-structured tables.

Before building a database, a developer must construct a logical representation of the database called a(n)________.

To determine processing rights/restrictions on each table and column is an important operational task of the database administrator.

In entity-relationship diagrams, crow's feet indicate ________.

The database design team transforms entities into ________.

In a database, a ________ refers to a character of data.

The database management system is a program used to create, process, and administer a database.

What is the user's role in the development of databases?

A single-user database cannot be converted to a multi-user database.

Access is both a DBMS and an application development product.

Which of the following is a popular DBMS product from Microsoft?

Explain the process of database design.

Introduction to MIS

Business Processes, Information Systems, and Information

Hardware, Software, and Networks

Using IS to Improve Processes

Supporting Processes with ERP Systems

Supporting the Procurement Process with SAP

Supporting the Sales Process with SAP

Collaboration Processes and Information Systems

The Impact of Web 2.0 and Social Media on Business Processes

Business Intelligence

MIS Management Processes: Process Management, Systems Development, and Security

Filters

Exam 4: Database Processing

Which of the following is a popular enterprise DBMS product?

Explain the importance of normalization for a database.

An N:M relationship cannot be written as N:N, because ________.

The process of converting poorly structured tables into two or more well-structured tables is called ________.

Which of the following database administration tasks is associated with database development?

Enterprise DBMS products ________.

Application programs do not allow database processing over the Internet.

________ is an international standard language for processing a database and is supported by all major DBMS products.

Normalization is the process of converting a poorly structured table into two or more well-structured tables.

Before building a database, a developer must construct a logical representation of the database called a(n)________.

To determine processing rights/restrictions on each table and column is an important operational task of the database administrator.

In entity-relationship diagrams, crow's feet indicate ________.

The database design team transforms entities into ________.

In a database, a ________ refers to a character of data.

The database management system is a program used to create, process, and administer a database.

What is the user's role in the development of databases?

A single-user database cannot be converted to a multi-user database.

Access is both a DBMS and an application development product.

Which of the following is a popular DBMS product from Microsoft?

Explain the process of database design.

Introduction to MIS

Business Processes, Information Systems, and Information

Hardware, Software, and Networks

Using IS to Improve Processes

Supporting Processes with ERP Systems

Supporting the Procurement Process with SAP

Supporting the Sales Process with SAP

Collaboration Processes and Information Systems

The Impact of Web 2.0 and Social Media on Business Processes

Business Intelligence

MIS Management Processes: Process Management, Systems Development, and Security

Filters