Question 1

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

Accepted Answer

In Microsoft Visio 2013,we can no longer create database designs as we could in Microsoft Visio 2010.We can only create data models.We can still open database designs created in Microsoft Visio 2010,but they appear unalterable block drawings.

Question 2

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

Accepted Answer

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) We cannot create data models in Microsoft Visio 2013. 
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) We cannot create data models in Microsoft Visio 2013. B

Question 3

Microsoft Visio 2013 can be used to create:

Accepted Answer

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

Question 4

In Microsoft Visio 2013,the data models in this book are created using:

Accepted Answer

A) the Chen's Database Notation template. 
B) the UML database Notation template. 
C) the IDEF1X Database Notation template. 
D) the Crow's Foot Database Notation template. 
E) the Wireframe Database Diagram template. 
A) the Chen's Database Notation template. 
B) the UML database Notation template. 
C) the IDEF1X Database Notation template. 
D) the Crow's Foot Database Notation template. 
E) the Wireframe Database Diagram template.

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

In Microsoft Visio 2013,the cardinalites of the Relationship connector object end point are formatted using:

Accepted Answer

A) the Set Begin Symbol command. 
B) the Set End Symbol command. 
C) the Set Non-primary Key Unique column 
D) the Set Non-foreign Key Unique column 
E) A and B. 
A) the Set Begin Symbol command. 
B) the Set End Symbol command. 
C) the Set Non-primary Key Unique column 
D) the Set Non-foreign Key Unique column 
E) A and B.

Question 9

In Microsoft Visio 2013,the cardinalities of the relationship are set using the Set Begin Symbol and Set End Symbol commands.

Accepted Answer

A) True 
 B)False

Question 10

In Microsoft Visio 2013,for a Relationship object relationship that is many-mandatory on the child side of the relationship,the correct setting in the Symbol menu is:

Accepted Answer

A) 1 and only 1. 
B) 1 or more. 
C) Zero or 1. 
D) Zero or more. 
E) Range [At least][At most]. 
A) 1 and only 1. 
B) 1 or more. 
C) Zero or 1. 
D) Zero or more. 
E) Range [At least][At most].

Question 11

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

Accepted Answer

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) We cannot create database designs in Microsoft Visio 2013 
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) We cannot create database designs in Microsoft Visio 2013

Question 12

In Microsoft Visio 2013,the Crow's Foot Database Notation stencil objects include:

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

In Microsoft Visio 2013,data models are

Question 15

In Microsoft Visio 2013,clicking the FILE command tab opens:

Accepted Answer

A) the File menu. 
B) the Backstage view. 
C) the Open dialog box. 
D) the Save As dialog box. 
E) the Save dialog box. 
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 16

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

Accepted Answer

A) Entity and Dynamic connector objects. 
B) Table and Relationship connector objects. 
C) Category and Dynamic connector objects. 
D) Category and Relationship connector objects. 
E) There are no separate objects to create supertype/subtype,so we use standard objects. 
A) Entity and Dynamic connector objects. 
B) Table and Relationship connector objects. 
C) Category and Dynamic connector objects. 
D) Category and Relationship connector objects. 
E) There are no separate objects to create supertype/subtype,so we use standard objects.

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

In Microsoft Visio 2013,we can create data models using Entity and Relationship objects.

Accepted Answer

A) True 
 B)False

Question 20

When using Microsoft Visio 2013,how do we create a blank diagram for use with a data model?

Accepted Answer

To create a blank diagram for a data mod

Exam 18: Getting Started With Microsoft Visio 2013

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

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

Microsoft Visio 2013 can be used to create:

In Microsoft Visio 2013,the data models in this book are created using:

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

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

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

In Microsoft Visio 2013,the cardinalites of the Relationship connector object end point are formatted using:

In Microsoft Visio 2013,the cardinalities of the relationship are set using the Set Begin Symbol and Set End Symbol commands.

In Microsoft Visio 2013,for a Relationship object relationship that is many-mandatory on the child side of the relationship,the correct setting in the Symbol menu is:

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

In Microsoft Visio 2013,the Crow's Foot Database Notation stencil objects include:

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

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

In Microsoft Visio 2013,clicking the FILE command tab opens:

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

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

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

In Microsoft Visio 2013,we can create data models using Entity and Relationship objects.

When using Microsoft Visio 2013,how do we create a blank diagram for use with a data model?

Introduction

Introduction to Structured Query Language SQL

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

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters