Exam 11: Getting Started With Mysql 5.6 Community Server

In the MySQL Workbench,a 1:N identifying relationship between two tables that already contain the needed primary and foreign keys is created using:

Free

(Multiple Choice)

4.9/5

(43)

Question 1

Correct Answer:

Verified

The MySQL Workbench is included in the MySQL Community Server 5.6 installation when the MySQL Installer for Windows is used.

Free

(True/False)

4.8/5

(39)

Question 2

Correct Answer:

Verified

True

Describe how to create and run an SQL query in MySQL 5.6 Community Server Edition.

Free

(Essay)

4.8/5

(37)

Question 3

Correct Answer:

Verified

In MySQL 5.6 Community Server Edition,SQL queries are created and run in the MySQL Workbench.Use the File | New Query Tab command to open a new tabbed SQL Query window.Type the SQL query into the SQL Query text area,and then click the "Execute SQL Script" button on the MySQL Workbench toolbar to run the query.Results are displayed in the tabbed results window.

SQL query results are displayed in a tabbed ________ window.

(Short Answer)

5.0/5

(33)

Question 4

Describe how to create a new database design in the MySQL Workbench.

(Essay)

4.9/5

(37)

Question 5

The authors recommend using which of the following folder structures with the MySQL Workbench?

(Multiple Choice)

4.8/5

(42)

Question 6

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:

(Multiple Choice)

4.8/5

(28)

Question 7

To access documentation about the MySQL Workbench,use the:

(Multiple Choice)

4.8/5

(38)

Question 8

SQL statements can be run individually or as part of a related group of SQL statements known as a script.

(True/False)

4.9/5

(33)

Question 9

MySQL Community Server 5.6 requires that the .NET Framework version 4.5.1 be installed.

(True/False)

4.8/5

(31)

Question 10

To run an SQL script,click the Execute button on the Query Toolbar.

(True/False)

4.8/5

(34)

Question 11

Describe how to set table properties in a MySQL Workbench database design.

(Essay)

4.8/5

(26)

Question 12

SQL statements can be run individually or as part of a related group of SQL statements known as a:

(Multiple Choice)

4.8/5

(36)

Question 13

Table names are edited in the MySQL EER Component Editor.

(True/False)

4.9/5

(34)

Question 14

In the MySQL Table Editor,the abbreviation for NOT NULL is:

(Multiple Choice)

4.8/5

(28)

Question 15

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.

(True/False)

4.8/5

(36)

Question 16

To run an SQL script,click the ________ button on the MySQL Workbench toolbar.

(Short Answer)

4.8/5

(34)

Question 17

SQL query results are displayed:

(Multiple Choice)

4.8/5

(37)

Question 18

In the MySQL Table Editor,the abbreviation for AUTO_INCREMENT is:

(Multiple Choice)

4.8/5

(32)

Question 19

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

(True/False)

4.9/5

(32)

Question 20

Showing 1 - 20 of 71

In the MySQL Workbench,a 1:N identifying relationship between two tables that already contain the needed primary and foreign keys is created using:

The MySQL Workbench is included in the MySQL Community Server 5.6 installation when the MySQL Installer for Windows is used.

Describe how to create and run an SQL query in MySQL 5.6 Community Server Edition.

SQL query results are displayed in a tabbed ________ window.

Describe how to create a new database design in the MySQL Workbench.

The authors recommend using which of the following folder structures with the MySQL Workbench?

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:

To access documentation about the MySQL Workbench,use the:

SQL statements can be run individually or as part of a related group of SQL statements known as a script.

MySQL Community Server 5.6 requires that the .NET Framework version 4.5.1 be installed.

To run an SQL script,click the Execute button on the Query Toolbar.

Describe how to set table properties in a MySQL Workbench database design.

SQL statements can be run individually or as part of a related group of SQL statements known as a:

Table names are edited in the MySQL EER Component Editor.

In the MySQL Table Editor,the abbreviation for NOT NULL is:

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.

To run an SQL script,click the ________ button on the MySQL Workbench toolbar.

SQL query results are displayed:

In the MySQL Table Editor,the abbreviation for AUTO_INCREMENT is:

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

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters