Q&A Hero

Q: In the MySQL Workbench, a 1:N non-identifying relationship between two tables that do not contain the needed primary and foreign keys is created using ________. A) the 1:N Identifying Relationship button B) the 1:N Non-identifying Relationship button C) the N:M Identifying Relationship button D) the Place a Relationship Using Existing Columns button

Q: In the MySQL Workbench, a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using ________. A) the 1:N Identifying Relationship button B) the 1:N Non-identifying Relationship button C) the N:M Identifying Relationship button D) the Place a Relationship Using Existing Columns button

Q: In the MySQL Table Editor, the abbreviation for AUTO_INCREMENT is ________. A) PK B) NN C) UQ D) AI

Q: In the MySQL Table Editor, the abbreviation for Primary Key is ________. A) PK B) NN C) UQ D) AI

Q: In the MySQL Table Editor, the abbreviation for NOT NULL is ________. A) PK B) NN C) UQ D) BIN

Q: To place a table in a MySQL database design, start by clicking the ________. A) Table button B) Entity button C) Place a New Table button D) Place a New Entity button

Q: To create a new MySQL Workbench EER model, you can use ________. A) the add Model link on the Home page B) the File | New Model command C) the Start new EER command D) Both A or B are correct

Q: In Windows, to use MySQL Workbench to create database designs, you must log into MySQL using ________. A) the Connect to Database dialog box B) the Connect to MySQL Server dialog box C) the MySQL | Connect to Server command D) No login is required

Q:

Q: The MySQL Installer for Windows should be used to install MySQL Community Edition components on computers running which operating system(s)? A) Microsoft Windows B) Unix C) Linux D) Both B and C are correct

Q: In the MySQL Workbench, a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using the Place a Relationship Using Existing Columns button.

Q: In the MySQL Workbench, a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using the 1:N Non-identifying Relationship button.

Q: In the MySQL Table Editor, the abbreviation AI stands for AUTO_INCREMENT.

Q: In the MySQL Table Editor, the abbreviation NN stands for NOT NULL.

Q: In the MySQL Table Editor, the abbreviation PK stands for partial key.

Q: Table column characteristics can be edited in the MySQL Table Editor.

Q: Table names are edited in the MySQL EER Component Editor.

Q: To add a table to a database design, click the Place a New Table button, move the cursor to the diagram area and click the left mouse button.

Q: To create a new MySQL Workbench EER model, you can use the File | New Model command.

Q: To create a new MySQL Workbench EER model, you can use the Create new EER Model link on the Home page.

Q: The MySQL Workbench EER models are data models.

Q: Users should create a folder to hold EER models created with the MySQL Workbench.

Q: Users should create a MySQL Workspace folder to hold documents created with the MySQL Workbench.

Q: In order to create MySQL EER diagrams, users must log into MySQL using the Connect to Database and the Connect to MySQL Server dialog boxes.

Q: In the Windows 8 or 8.1 OS, to start working with the MySQL Workbench use the command Start | All Programs | MySQL | MySQL Workbench 6.1 CE.

Q: The MySQL Installer for Linux can be used to install the MySQL Workbench.

Q: The MySQL Installer for Windows can be used to install the MySQL Workbench.

Q: The installation of the MySQL Community Edition 5.6 always includes the installation of the MySQL Workbench.

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

Q: What format is used for weak entities in UML-style E-R diagrams?

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

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

Q: What new contributions to data modeling do UML-style E-R diagrams introduce?

Q: In UML notation, the relationship line in a relationship with an non-ID-dependent weak entity is labeled as ________. A) <persistent> B) <identifying> C) <nonidentifying> D) There is no label used.

Q: In UML notation, the relationship line in a relationship with an ID-dependent weak entity is labeled as ________. A) <persistent> B) <identifying> C) <nonidentifying> D) <protected>

Q: In UML notation, the relationship line in a relationship between two strong entities is labeled as ________. A) <persistent> B) <identifying> C) <nonidentifying> D) There is no label used.

Q: In the UML-style entity class ORDERS shown above, "GetOrderNo( )" is a ________. A) private method B) protected method C) public constraint D) public method

Q: In the UML-style entity class ORDERS shown above, "SumOfOrders" is ________.A) an entity attributeB) a methodC) a constraintD) a class attribute

Q: In UML, an attribute that is accessible and can be changed by any method of any object is said to be ________.A) privateB) exclusiveC) protectedD) public

Q: In UML, an attribute that is accessible only by methods of its entity class is said to be ________. A) private B) exclusive C) protected D) public

Q: In UML, an attribute that is accessible only by methods of its entity class or of its subclasses is said to be ________. A) private B) exclusive C) protected D) public

Q: In UML, an attribute preceded by a(n) ________ is "protected." A) <persistent> B) # C) - D) +

Q: Which of the following is not a characteristic that was introduced to E-R diagramming by UML? A) Class attributes B) Relationship attributes C) Visibility of attributes D) Methods

Q: In UML-style E-R diagrams, which of the following would be considered a class attribute of the entity class CUSTOMER? A) Customer Name (meaning, the first and last name of the customer) B) Customer Address (meaning, the street, city, state, and zip code of the customer's residence) C) Customer Count (meaning, the count of the number of customers) D) Customer Number (meaning, an assigned number to uniquely identify a customer)

Q: Which of the following is not a true statement about the current version of UML? A) UML places a filled-in diamond on the parent of a weak entity. B) UML provides a means to document exclusivity among subtypes. C) UML uses the label <identifying> to document an ID-dependent relationship. D) UML shows the cardinality on the parent entity of a weak entity as simply "1."

Q: Which of the following would indicate a minimum cardinality of 1 and a maximum cardinality of many in UML notation? A) 1:N B) 1 .. N C) 1 .. * D) 1:*

Q: In UML-style E-R diagrams, the third segment of an entity class contains ________. A) the name of the entity B) the cardinalities of the entity C) constraints and methods D) entity attributes

Q: In UML-style E-R diagrams, the second segment of an entity class contains ________. A) the name of the entity B) the cardinalities of the entity C) relationships D) entity attributes

Q: Which of the following is true about UML? 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.

Q: Attributes preceded by a + are public.

Q: Attributes preceded by a # are private.

Q: Attributes preceded by a + are protected.

Q: Three levels of visibility for attributes in UML diagrams are: Private, Protected, and Public.

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

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

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

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

Q: 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.

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

Q: One weakness of UML-style E-R diagrams is that there is no means of distinguishing between a weak entity that is ID-dependent and a weak entity that is not ID-dependent.

Q: In UML-style E-R diagrams, a weak entity is shown by placing a filled-in diamond on the parent of the weak entity.

Q: Maximum cardinalities are represented in UML-style E-R diagrams with the same notation (1:1, 1:N, N:M) as in traditional E-R diagrams.

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

Q: UML is intended for modeling and designing object-oriented programs and applications.

Q: What are IDEF1X domains?

Q: What symbols are used in IDEF1X diagrams to represent cardinalities?

Q: What line symbols are used in IDEF1X diagrams to represent relationships?

Q: What are the IDEF1X equivalents of 1:1, 1:N and N:M relationships?

Q: What is IDEF1X?

Q: In an IDEF1X identifying connection relationship, ________. A) the identifier of the child is always part of the identifier of the parent B) the identifier of the parent is always part of the identifier of the child C) the identifier of the parent is always the same as the identifier of the child D) the identifier of the parent is optional

Q: In IDEF1X, a non-specific relationship is indicated by ________. A) a hollow circle on each end of the solid relationship line B) no circles on either end of the dotted relationship line C) a solid circle on each end of the solid relationship line D) a solid circle on each end of the dotted relationship line

Q: In IDEF1X, a type domain allows ________. A) different data types B) different values C) greater specificity of values D) default values

Q: In IDEF1X, a base domain can have any of the following except a ________. A) data type B) value list C) range definition D) default value

Q: In IDEF1X, a category cluster includes BLACK and WHITE, but does not show GREY, which is also a possible category. This is an IDEF1X ________. A) complete category cluster B) incomplete category cluster C) inherited category cluster D) inconclusive category cluster

Q: In IDEF1X, a category cluster includes BLACK and WHITE, which are the only possible categories. This is an IDEF1X ________. A) complete category cluster B) incomplete category cluster C) inherited category cluster D) inconclusive category cluster

Q: In IDEF1X, the two kinds of domains are ________. A) base and column B) base and type C) type and column D) entity and type

Q: In IDEF1X, the named set of values that an attribute can have is called a ________. A) domain B) base domain C) type domain D) domain cluster

Q: In IDEF1X, extended E-R model subtype entities are grouped into ________. A) generic entities B) category entities C) nonspecific entities D) category clusters E) There is no equivalent IDEF1X term.

Q: In IDEF1X, extended E-R model subtype entities are called ________. A) generic entities B) category entities C) nonspecific entities D) category clusters

Q: In IDEF1X, extended E-R model supertype entities are called ________. A) generic entities B) category entities C) nonspecific entities D) category clusters