Question 1

In UML,an attribute that is accessible only by methods of its entity class or of its subclasses is said to be ________.

Accepted Answer

A) private 
B) exclusive 
C) protected 
D) public 
A) private 
B) exclusive 
C) protected 
D) public C

Question 2

In UML notation,the relationship line in a relationship with an ID-dependent weak entity is labeled as ________.

Accepted Answer

A) B) C) D) A) B) C) D) B

Question 3

What is OOP persistence,and how is it indicated in UML-style E-R diagrams?

Accepted Answer

Persistence in OOP means that the data for classes of entities,and thus the entity class itself,will be stored in the database.This is indicated by labeling entities with the keyword <>.

Question 4

How are entity classes drawn in UML-style E-R diagrams?

Accepted Answer

UML-style E-R diagrams draw an entity as

Question 5

In UML,an attribute that is accessible only by methods of its entity class is said to be ________.

Accepted Answer

A) private 
B) exclusive 
C) protected 
D) public 
A) private 
B) exclusive 
C) protected 
D) public

Question 6

Persistent means that data should continue to exist in the database even if the object that processes it is destroyed.

Accepted Answer

A) True 
 B)False

Question 7

In UML notation,the relationship line in a relationship between two strong entities is labeled as ________.

Accepted Answer

A) B) C) D) There is no label used. A) B) C) D) There is no label used.

Question 8

In the UML-style entity class ORDERS shown above,"SumOfOrders" is ________.

Accepted Answer

A) an entity attribute 
B) a method 
C) a constraint 
D) a class attribute 
A) an entity attribute 
B) a method 
C) a constraint 
D) a class attribute

Question 9

Which of the following is not a characteristic that was introduced to E-R diagramming by UML?

Accepted Answer

A) Class attributes 
B) Relationship attributes 
C) Visibility of attributes 
D) Methods 
A) Class attributes 
B) Relationship attributes 
C) Visibility of attributes 
D) Methods

Question 10

In UML notation,the relationship line in a relationship with an ID-dependent weak entity is labeled as <id-dependent>.

Accepted Answer

A) True 
 B)False

Question 11

UML-style E-R diagrams allow for the existence of class attributes which are attributes that pertain to the collection of all entities within that class,not to the individual entity instances themselves.

Accepted Answer

A) True 
 B)False

Question 12

What cardinality format is used in UML-style E-R diagrams?

Accepted Answer

UML-style E-R diagrams use an x..y cardi

Question 13

In UML notation,the relationship line in a relationship with a non-ID-dependent weak entity is labeled as <nonidentifying>.

Accepted Answer

A) True 
 B)False

Question 14

Attributes preceded by a # are private.

Accepted Answer

A) True 
 B)False

Question 15

UML-style E-R diagrams introduce object-oriented notation that is of limited practical value in traditional,relational database design.

Accepted Answer

A) True 
 B)False

Question 16

The classes of all entities to be stored in the database are labeled >.

Accepted Answer

A) True 
 B)False

Question 17

Attributes preceded by a + are public.

Accepted Answer

A) True 
 B)False

Question 18

In UML,an attribute preceded by a(n)________ is "protected."

Accepted Answer

A) B) # C) - D) + A) B) # C) - D) +

Question 19

Which of the following is true about UML?

Accepted Answer

A) UML is a methodology for developing OOP systems. 
B) UML is a set of tools to support the development OOP systems. 
C) UML is primarily focused on database development. 
D) Both A and B are correct. 
A) UML is a methodology for developing OOP systems. 
B) UML is a set of tools to support the development OOP systems. 
C) UML is primarily focused on database development. 
D) Both A and B are correct.

Question 20

In UML,cardinalities are represented by an x ..y format.

Accepted Answer

A) True 
 B)False

Exam 18: E-R Diagrams and the UML Standard

In UML,an attribute that is accessible only by methods of its entity class or of its subclasses is said to be ________.

In UML notation,the relationship line in a relationship with an ID-dependent weak entity is labeled as ________.

What is OOP persistence,and how is it indicated in UML-style E-R diagrams?

How are entity classes drawn in UML-style E-R diagrams?

In UML,an attribute that is accessible only by methods of its entity class is said to be ________.

Persistent means that data should continue to exist in the database even if the object that processes it is destroyed.

In UML notation,the relationship line in a relationship between two strong entities is labeled as ________.

In the UML-style entity class ORDERS shown above,"SumOfOrders" is ________.

Which of the following is not a characteristic that was introduced to E-R diagramming by UML?

In UML notation,the relationship line in a relationship with an ID-dependent weak entity is labeled as <id-dependent>.

UML-style E-R diagrams allow for the existence of class attributes which are attributes that pertain to the collection of all entities within that class,not to the individual entity instances themselves.

What cardinality format is used in UML-style E-R diagrams?

In UML notation,the relationship line in a relationship with a non-ID-dependent weak entity is labeled as <nonidentifying>.

Attributes preceded by a # are private.

UML-style E-R diagrams introduce object-oriented notation that is of limited practical value in traditional,relational database design.

The classes of all entities to be stored in the database are labeled <>.

Attributes preceded by a + are public.

In UML,an attribute preceded by a(n)________ is "protected."

Which of the following is true about UML?

In UML,cardinalities are represented by an x ..y format.

Introduction

Introduction to Structured Query Language

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the IDEF1X Standard

Getting Started With Mysql Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers, PHP, and the Netbeans IDE

Business Intelligence Systems

Big Data

Filters