Deck 21: Getting Started With Microsoft Visio 2010

Question 1

In Microsoft Visio 2010,we can create data models using Entity and Dynamic connector objects.

Answer 1

True

Question 2

In Microsoft Visio 2010,when the Entity object is placed in a diagram,it is labeled as a(n):

A)entity.
B)table.
C)relationship.
D)dynamic connector.
E)category.

Answer 2

B

Question 3

In Microsoft Visio 2010,the Entity Relationship (US units)stencil objects include:

A)an Entity object.
B)a Relationship object.
C)a Dynamic connector object.
D)B and C
E)A,B and C

Answer 3

E

Question 4

In Microsoft Visio 2010,when the Table object is placed in a diagram,it is labeled as an Entity.

Question 5

In Microsoft Visio 2010,the arrow end of the Dynamic connector object points to the table containing the primary key.

Question 6

Microsoft Visio 2010 can be used to create data models,but not database designs.

Question 7

In Microsoft Visio 2010,both data models and database designs are created using:

A)the Database Model Diagram template.
B)the UML Model Diagram template.
C)the Enterprise Application template.
D)the Data Flow Model template.
E)the Wireframe Diagram template.

Question 8

In Microsoft Visio 2010,both data models and database designs are created using the Database Model Diagram template.

Question 9

In Microsoft Visio 2010,Relationship connector objects can be formatted with the line end symbols needed to create IE Crow's Foot notation.

Question 10

In Microsoft Visio 2010,clicking the File command tab opens the Backstage view.

Question 11

In Microsoft Visio 2010,whether a relationship is identifying or non-identifying can be set in the Database Properties for that Relationship object.

Question 12

In Microsoft Visio 2010,a group of template objects is called a stencil.

Question 13

In Microsoft Visio 2010,Dynamic connector objects can be formatted with the line end symbols needed to create IE Crow's Foot notation.

Question 14

Microsoft Visio 2010 can be used to create:

A)data models.
B)data designs.
C)database models.
D)database designs.
E)A and D

Question 15

In Microsoft Visio 2010,the Entity Relationship (US units)stencil objects include a Recursive Relationship object.

Question 16

In Microsoft Visio 2010,the Entity Relationship (US units)stencil objects include a Category object.

Question 17

In Microsoft Visio 2010,clicking the File command tab opens:

A)the File menu.
B)the Backstage view.
C)the Open dialog box.
D)the Save As dialog box.
E)the Save dialog box.

Question 18

In Microsoft Visio 2010,the arrow end of the Relationship connector object points to the table containing the foreign key.

Question 19

In Microsoft Visio 2010,we can create database designs using Entity and Dynamic connector objects.

Question 20

Microsoft Visio 2010 is a component of Microsoft Office 2010.

Question 21

When using Microsoft Visio 2010,how do we create a blank diagram for use with a data model or database design?

Question 22

In Microsoft Visio 2010,we can create data models using:

A)Entity and Dynamic connector objects.
B)Entity and Relationship connector objects.
C)Category and Dynamic connector objects.
D)Category and Relationship connector objects.
E)A and C

Question 23

In Microsoft Visio 2010,how do we create database designs?

Question 24

In Microsoft Visio 2010,how do we format line ends in data model to represent the symbols used in the IE Crow's Foot notation?

Question 25

In Microsoft Visio 2010,the arrow end of the Relationship connector object points to the table containing:

A)the foreign key.
B)the primary key.
C)the non-primary key unique column.
D)the non-foreign key unique column.
E)None of the above is correct.

Question 26

In Microsoft Visio 2010,which objects can be formatted with the line end symbols needed to create IE Crow's Foot notation?

A)Dynamic connector object
B)Relationship connector object
C)Category object
D)Parent to category connector object
E)Category to child connector object

Question 27

In Microsoft Vision 2010,for a Relationship object relationship that is one-optional on the child side of the relationship,the correct setting in Database Properties is:

A)exactly one.
B)one or more.
C)zero or one.
D)zero or more.
E)range [At least][At most].

Question 28

In Microsoft Visio 2010,we can create supertype/subtype relationships in data models using:

A)Entity and Dynamic connector objects.
B)Entity and Relationship connector objects.
C)Category and Dynamic connector objects.
D)Category and Relationship connector objects.
E)A and C

Question 29

In Microsoft Visio 2010,for a Relationship object relationship that is one-mandatory on the child side of the relationship,the correct setting in Database Properties is:

A)exactly one.
B)one or more.
C)zero or one.
D)zero or more.
E)range [At least][At most].

Question 30

In Microsoft Visio 2010,how do we create data models?

Question 31

In Microsoft Visio 2010,we can create database designs using:

A)Entity and Dynamic connector objects.
B)Entity and Relationship connector objects.
C)Category and Dynamic connector objects.
D)Category and Relationship connector objects.
E)B and D

Question 32

In Microsoft Visio 2010,we can create supertype/subtype relationships in database designs using:

A)Entity and Dynamic connector objects.
B)Entity and Relationship connector objects.
C)Category and Dynamic connector objects.
D)Category and Relationship connector objects.
E)A and C

Question 33

In Microsoft Visio 2010,describe the possible cardinality settings for a Relationship object that can be set in the Database Properties for a relationship in a database design,and how these settings correspond to the IE Crow's Foot symbols shown in Figure 4-8?

Question 34

In Microsoft Visio 2010,for a Relationship object relationship that is many-optional on the child side of the relationship,the correct setting in Database Properties is:

A)exactly one.
B)one or more.
C)zero or one.
D)zero or more.
E)range [At least][At most].

Question 35

In Microsoft Visio 2010,the Database Properties window can be used to set a relationship as identifying or non-identifying can be set in the ________ for that Relationship object.

A)identifying
B)non-identifying
C)identifying ID-dependent
D)non-identifying ID-dependent
E)A and B

Question 36

In Microsoft Visio 2010,for a Relationship object relationship that is many-mandatory on the child side of the relationship,the correct setting in Database Properties is:

A)exactly one.
B)one or more.
C)zero or one.
D)zero or more.
E)range [At least][At most].