Question 1

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)  keyE) A) and D)
F) All of the above

Question 2

_____ is the most popular diagramming tool for database applications.

Accepted Answer

A)  UML
B)  O-O
C)  E-R
D)  WorkflowE) A) and B)
F) A) and C)

Question 3

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

Accepted Answer

A)  minimum cardinalities
B)  identifiers
C)  foreign keys
D)  attributesE) All of the above
F) C) and D)

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

________ is a popular enterprise DBMS.

Accepted Answer

A)  Access
B)  DB2
C)  Paradox
D)  FoxProE) A) and C)
F) None of the above

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 themeE) A) and D)
F) B) and D)

Question 8

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 timeE) A) and D)
F) C) and D)

Question 9

What is the purpose of a database?

Accepted Answer

The purpose of a database is to keep tra...

Question 10

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

Accepted Answer

A)  record
B)  key
C)  relation
D)  attributeE) A) and B)
F) All of the above

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

In a data model,entities always represent physical objects.

Accepted Answer

A) True 
 B)False

Question 14

________ show data in a structured context.

Accepted Answer

A)  Databases
B)  Reports
C)  Files
D)  Data logsE) A) and B)
F) A) and C)

Question 15

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 systemE) B) and D)
F) A) and C)

Question 16

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

Accepted Answer

A)  file
B)  table
C)  application
D)  fieldE) A) and B)
F) B) and C)

Question 17

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

Accepted Answer

A)  grid network
B)  database
C)  file system
D)  storage folderE) A) and D)
F) B) and D)

Question 18

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.E) B) and D)
F) All of the above

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Relational databases represent relationships through the use of formal keys.

Accepted Answer

A) True 
 B)False

Exam 5: Database Processing

_____ is the most popular diagramming tool for database applications.

Correct AnswerverifiedShow Answer

In a data model,entities always represent physical objects.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

________ show data in a structured context.

Correct AnswerverifiedShow Answer

Relational databases represent relationships through the use of formal keys.

Correct AnswerverifiedShow Answer

Metadata are ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is the purpose of a database?

Correct AnswerverifiedThe purpose of a database is to keep tra...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

________ is a popular enterprise DBMS.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The purpose of a database is to keep tra...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified