Filters
Question type

Study Flashcards

By default,the E-R diagrams created in the MySQL Workbench use ________.


A) IE Crow's Foot notation
B) IDEF1X notation
C) UML notation
D) Microsoft Visio 2013 Arrow notation

E) A) and D)
F) B) and C)

Correct Answer

verifed

verified

Describe how to get started creating a new database design in the MySQL Workbench.

Correct Answer

verifed

verified

In the MySQL Workbench,new database desi...

View Answer

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.

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

The MySQL Workbench EER models are data models.

A) True
B) False

Correct Answer

verifed

verified

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.

A) True
B) False

Correct Answer

verifed

verified

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

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

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

E) B) and D)
F) A) and B)

Correct Answer

verifed

verified

In the MySQL Table Editor,the abbreviation for AUTO_INCREMENT is ________.


A) PK
B) NN
C) UQ
D) AI

E) A) and D)
F) B) and D)

Correct Answer

verifed

verified

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.

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

In the MySQL Table Editor,the abbreviation for NOT NULL is ________.


A) PK
B) NN
C) UQ
D) BIN

E) A) and C)
F) A) and D)

Correct Answer

verifed

verified

In the MySQL Workbench,a 1:N 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

E) All of the above
F) None of the above

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

In the MySQL Table Editor,the abbreviation for Primary Key is ________.


A) PK
B) NN
C) UQ
D) AI

E) All of the above
F) B) and D)

Correct Answer

verifed

verified

Showing 21 - 37 of 37

Related Exams

Show Answer