Question 1

What is the purpose of a database?

Accepted Answer

The purpose of a database is to keep tra

Question 2

Relationships represented using "crow's feet" have an N:M relationship.

Accepted Answer

A) True 
 B)False

Question 3

The components of a database application system include all of the following except ________.

Accepted Answer

A) forms,reports,and queries 
B) metadata 
C) DBMS software 
D) the operating system 
A) forms,reports,and queries 
B) metadata 
C) DBMS software 
D) the operating system

Question 4

In order to find the data one is looking for in the DBMS,one has to type in the keyword into a query form.

Accepted Answer

A) True 
 B)False

Question 5

In a data model,entities always represent physical objects.

Accepted Answer

A) True 
 B)False

Question 6

A ________ is a self-describing collection of integrated records.

Accepted Answer

A) grid network 
B) database 
C) file system 
D) storage folder 
A) grid network 
B) database 
C) file system 
D) storage folder

Question 7

The database design team transforms entities into tables and expresses relationships by defining ________.

Accepted Answer

A) minimum cardinalities 
B) identifiers 
C) foreign keys 
D) attributes 
A) minimum cardinalities 
B) identifiers 
C) foreign keys 
D) attributes

Question 8

________ is a popular enterprise DBMS.

Accepted Answer

A) Access 
B) DB2 
C) Paradox 
D) FoxPro 
A) Access 
B) DB2 
C) Paradox 
D) FoxPro

Question 9

In a data model,an identifier refers to a unique characteristic of an entity.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

A more formal name for a table is a(n)________.

Accepted Answer

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

Question 12

_____ is the most popular diagramming tool for database applications.

Accepted Answer

A) UML 
B) O-O 
C) E-R 
D) Workflow 
A) UML 
B) O-O 
C) E-R 
D) Workflow

Question 13

A key is a column or group of columns that identifies a unique row in a table.

Accepted Answer

A) True 
 B)False

Question 14

Metadata are ________.

Accepted Answer

A) data on the main server 
B) binaries that encode data on to the memory 
C) data that describe data 
D) a collection of data over a period of time 
A) data on the main server 
B) binaries that encode data on to the memory 
C) data that describe data 
D) a collection of data over a period of time

Question 15

Relational databases represent relationships through the use of formal keys.

Accepted Answer

A) True 
 B)False

Question 16

In a relational database,a collection of related records is a(n)________.

Accepted Answer

A) file 
B) table 
C) application 
D) field 
A) file 
B) table 
C) application 
D) field

Question 17

________ show data in a structured context.

Accepted Answer

A) Databases 
B) Reports 
C) Files 
D) Data logs 
A) Databases 
B) Reports 
C) Files 
D) Data logs

Question 18

All the following steps involved in transforming a data model into a relational database design are true except ________.

Accepted Answer

A) the database designer creates a table for each entity 
B) the identifier of the entity becomes the key of the table 
C) each attribute of the entity becomes a row of the table 
D) the tables are normalized so that each table has a single theme 
A) the database designer creates a table for each entity 
B) the identifier of the entity becomes the key of the table 
C) each attribute of the entity becomes a row of the table 
D) the tables are normalized so that each table has a single theme

Question 19

In an entity-relationship diagram,a ________ on a line means that the entity is optional.

Accepted Answer

A) vertical bar 
B) crow's foot 
C) small oval 
D) key 
A) vertical bar 
B) crow's foot 
C) small oval 
D) key

Question 20

Which of the following is true of the database development process?

Accepted Answer

A) The database structure cannot be changed during the data modeling stage. 
B) Changing a relationship from 1:N to N:M is simply a matter of changing the notations. 
C) User review of the data model is avoided as it is not helpful in data modeling. 
D) A database is a model of how the developers view their business world. 
A) The database structure cannot be changed during the data modeling stage. 
B) Changing a relationship from 1:N to N:M is simply a matter of changing the notations. 
C) User review of the data model is avoided as it is not helpful in data modeling. 
D) A database is a model of how the developers view their business world.

What is the purpose of a database?

Relationships represented using "crow's feet" have an N:M relationship.

The components of a database application system include all of the following except ________.

In order to find the data one is looking for in the DBMS,one has to type in the keyword into a query form.

In a data model,entities always represent physical objects.

A ________ is a self-describing collection of integrated records.

The database design team transforms entities into tables and expresses relationships by defining ________.

________ is a popular enterprise DBMS.

In a data model,an identifier refers to a unique characteristic of an entity.

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

A more formal name for a table is a(n)________.

_____ is the most popular diagramming tool for database applications.

A key is a column or group of columns that identifies a unique row in a table.

Metadata are ________.

Relational databases represent relationships through the use of formal keys.

In a relational database,a collection of related records is a(n)________.

________ show data in a structured context.

All the following steps involved in transforming a data model into a relational database design are true except ________.

In an entity-relationship diagram,a ________ on a line means that the entity is optional.

Which of the following is true of the database development process?

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

What is the purpose of a database?

Relationships represented using "crow's feet" have an N:M relationship.

The components of a database application system include all of the following except ________.

In order to find the data one is looking for in the DBMS,one has to type in the keyword into a query form.

In a data model,entities always represent physical objects.

A ________ is a self-describing collection of integrated records.

The database design team transforms entities into tables and expresses relationships by defining ________.

________ is a popular enterprise DBMS.

In a data model,an identifier refers to a unique characteristic of an entity.

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

A more formal name for a table is a(n)________.

_____ is the most popular diagramming tool for database applications.

A key is a column or group of columns that identifies a unique row in a table.

Metadata are ________.

Relational databases represent relationships through the use of formal keys.

In a relational database,a collection of related records is a(n)________.

________ show data in a structured context.

All the following steps involved in transforming a data model into a relational database design are true except ________.

In an entity-relationship diagram,a ________ on a line means that the entity is optional.

Which of the following is true of the database development process?

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